GLXRCTRS_XML Reconciliation - Unreconciled Transactions (XML) Report Errors with ORA-20303: KFF Structure is not frozen (Doc ID 1956508.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.2.4 and later
Information in this document applies to any platform.
GLXRCUNR_XML - Reconciliation - Unreconciled Transactions (XML)
Report:GLXRCUNR.RDF - Reconciliation - Unreconciled Transactions
Report:GLXRCTRS.RDF - Reconciliation - Reconciled Transactions
GLXRCTRS_XML- Reconciliation - Reconciled Transactions (XML)

Symptoms

On : 12.2.4 version, Journal Entry

GLXRCTRS_XML Reconciliation - Reconciled Transactions (XML) and GLXRCUNR_XML Reconciliation - Unreconciled Transactions (XML) XML reports end with error.
The TEXT version of these reports run properly: GLXRCTRS Reconciliation - Reconciled Transactions and GLXRCUNR Reconciliation - Unreconciled Transactions

ERROR
-----------------------
Calling XDO Data Engine...
[122214_103118412][][EXCEPTION] java.sql.SQLException: ORA-20100: kff_where(C_WHERE_FLEX, SQLGL, GL#, 101, ALL, BETWEEN, 00001.000000.00000.000000.00000.00000000000000000.00000.0000.0000, 00001.zzzzzz.00000.000000.00000.00000000000000000.00000.0000.0000) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 2705
ORA-20100: get_kff_str(101, GL#, 101) raised exception.
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 180
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 242
ORA-06512: at "APPS.FND_FLEX_XML_PUBLISHER_APIS", line 958
ORA-20303: KFF Structure is not frozen.
ORA-06512: at line 9

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