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 OCTOBER 13, 2015

Applies to:

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

Symptoms

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.

STEPS

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.


BUSINESS IMPACT

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

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