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

HxGN EAM Resolved Issues for 2023

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

SG-4164 Reservations - ORA-00904 for ORG_CURR when adding Currency to the layout of the dataspy

 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