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

Last updated on AUGUST 30, 2016

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLTRBALD Trial Balance - Detail report

Symptoms

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.

Changes

Upgraded from 11.5.9 to R12.0.6; this might occur on other versions too.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms