R12: Standard Reports Submission Throws Error: APP-FND-00798: Invalid reference GL_SRS_COA_ID_BYSOB
Last updated on FEBRUARY 27, 2018
Applies to:Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLTRBALD Trial Balance - Detail report
Attempting to submit standard GLTRBALD 'Trial Balance - Detail' report, before selecting any submission parameters, the following error occurs; the issue might also affect other standard reports in General Ledger.
ERROR-example, it may occur slightly different:
APP-FND-00798: Invalid reference GL_SRS_COA_ID_BYSOB in value set attached to segment Pagebreak Segment.
Please check where clauses of your table validated value sets.
Acknowledging the error message (Ok button) might throw another message:
APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly table-validated value set where the table view does not exist or where there is an invalid WHERE clause.
Contact your system administrator or support representative to check the correct value sets this flexfield uses.
Upgraded from 11.5.9 to R12.0.6; this might occur on other versions too.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms