SG-4340 CLONE - Reservations - ORA-00904 for ORG_CURR when adding Currency to the layout of the dataspy - HxGN EAM - 12.0.1 - Release Bulletin - Hexagon

HxGN EAM Resolved Issues for 12.0.1

Language
English
Product
HxGN EAM
Search by Category
Release Bulletin
HxGN EAM Version
12.0.1

 Description 

Adding the Currency field on the layout of the dataspy results in error: "_The SQL Statement is invalid: ORA-00904: "ORG_CURR": invalid identifier."_

This is correct as table R5ORGANIZATION is not referenced on the query of the dataspy.

*Steps to reproduce:*

# access the Work | Contract Management | Reservations screen

# click on the Edit button on the right of the dataspy box, to edit the default dataspy

# on the Layout tab of the Dataspy popup, move the Currency field to the list of Visible Fields

# click on Save

*Expected result:*

The dataspy should get saved correctly, as the Currency field is available on the list of Available Fields

*Actual result:*

The system generates error ORA-00904 for field ORG_CURR