FSG - Where Used Report Fails With Error: ORA-00907: missing right parenthesis
(Doc ID 1460220.1)
Last updated on MARCH 20, 2025
Applies to:
Oracle General Ledger - Version 12.1.3 and laterInformation in this document applies to any platform.
FSG, FSG - Where Used, ORA-00907, REP-300
Symptoms
When running the report FSG - Where Used, you get the following errors:
--------------------------------------------------------------------------------------------------
ORA-00907: missing right parenthesis
'||SEGMENT8_HIGH) C_COL_DATA_HIGH FROM RG_REPORT_AXIS_SETS SETS , RG_REPORT_AXES AX , RG_REPORT_AXIS_CONTENTS CONS , GL_LEDGERS GLLED WHERE SETS.AXIS_SET_TYPE = 'C' AND SETS.AXIS_SET_ID = NVL('5116', SETS.AXIS_SET_ID) AND SETS.AXIS_SET_ID = AX.AXIS
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: missing right parenthesis
'||SEGMENT8_HIGH) C_COL_DATA_HIGH FROM RG_REPORT_AXIS_SETS SETS , RG_REPORT_AXES AX , RG_REPORT_AXIS_CONTENTS CONS , GL_LEDGERS GLLED WHERE SETS.AXIS_SET_TYPE = 'C' AND SETS.AXIS_SET_ID = NVL('5116', SETS.AXIS_SET_ID) AND SETS.AXIS_SET_ID = AX.AXIS
The Ledger name contains an apostroph (') and Ledger is a value of the Accounting Flexfield parameter.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |