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 |