We call XLA_ACCOUNTING_PUB_PKG.accounting_program_events to execute Create Accounting after populating XLA_ACCT_PROG_EVENTS_GT in WF node but now noticed
After upgrade to Release 12C we getting the below error
An internal error has occurred in the program xla_accounting_pkg.events_processor. ORA-01001: invalid cursor
ORA-06512: at "APPS.XLA_ACCOUNTING_CACHE_PKG", line 1722
ORA-01403: no data found.
Please note this error doesn't appear when using 11g DB, Oracle seems to suggest to change the optimizer to 11g for a resolution of this bug.
Additional information
From FND LOG Messages table, we notice P_source_ledger_id being null which is causing this error.
Also notice in XLA_ACCOUNTING_PUB_PKG.accounting_program_events procedure if we qualify the schema name on XLA_TRANSACTION_ENTITIES(running in APPS schema) for the below update statement
UPDATE xla_acct_prog_events_gt xpa
SET (ledger_id) =
(SELECT ledger_id
FROM xla_events xe
, xla_transaction_entities xte
WHERE xte.application_id = xe.application_id
AND xte.entity_id = xe.entity_id
AND xe.application_id = p_application_id
AND xe.event_id = xpa.event_id);
Then the issue disappears.
Is there any MO_POLICY needed to defined in 12c DB?
Thanks
Badri