My Oracle Support Banner

R12: Standard Reports Submission Throws Error: APP-FND-00798: Invalid reference GL_SRS_COA_ID_BYSOB (Doc ID 824901.1)

Last updated on JULY 10, 2020

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.