My Oracle Support Banner

R12.2: Publish Tax Reconciliation By Taxable Account (JGRXTXBL) Shows Error APP-FND-0079 Invalid reference GL_SRS_COA_UNVALIDATED (Doc ID 2042277.1)

Last updated on MAY 14, 2019

Applies to:

Oracle Financials Common Country - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.2.4 version, RXi based reports

When attempting to run the 'Publish Tax Reconciliation by Taxable Account' concurrent program, the following error occurs.


The issue can be reproduced at will with the following steps:
  1. In the Requests submit screen, enter the program name 'Publish Tax Reconciliation by Taxable Account' concurrent program.

  2. The below error occurs before entering the report parameters
  APP-FND-00798: Invalid reference GL_SRS_COA_UNVALIDATED in value set attached to segment Balancing Segment
  Please check the WHERE clauses of your table validated value sets.

 3. Click the Details button, the below error occurs
   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 a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.
Contact your system administrator or support representative to check and correct the value sets this flexfield uses.


The issue has the following business impact:
Due to this issue, users cannot submit the 'Publish Tax Reconciliation by Taxable Account' concurrent program.


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.