Undo Accounting Errors out with "XLA-95103: An internal error occurred." or "Journal entry cannot be reversed as its not transferred to General Ledger." (Doc ID 1664403.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Subledger Accounting - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

RDBMS version 11g (11.1.07 Typically shows this error)


Undo Accounting ERROR can be as below :


Journal entry cannot be reversed as its not transferred to General Ledger.
"-: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla.plsql.xla_datafixes_pub.reverse_journal_entries. Journal entry cannot be reversed as its"

 

FND log shows:

l_Return_Status=U

"Undo_Accounting : Error in xla_DataFixes_Pub.Reverse_Journal_entries
:FND"
Undo Accounting Unsuccessful for Invoice id event id

 

To confirm the issue execute both SQL statements given below.  If select * return rows and select column name doesn't issue is confirmed.

1. SELECT /*+ leading(xah) */
gl.currency_code, xsu.je_source_name,
xah.entity_id, xah.accounting_date,
xle.event_id, xah.ledger_id,
xte.legal_entity_id, xah.accrual_reversal_flag,
xle.budgetary_control_flag
FROM XLA_LEDGER_OPTIONS opt,
XLA_LEDGER_RELATIONSHIPS_V rs,
xla_gl_ledgers_v gl,
xla_ae_headers xah,
xla_subledgers xsu,
XLA_EVENTS XLE,
xla_transaction_entities_upg xte
WHERE opt.LEDGER_ID = xah.ledger_id
AND opt.APPLICATION_ID = xah.application_id
AND xsu.application_id = xah.application_id
AND xah.event_id in (&p_event_id)
AND xah.application_id = &p_application_id
AND xah.event_id = xle.event_id
AND xah.application_id = xle.application_id
AND xah.entity_id = xte.entity_id
AND xah.application_id = xte.application_id
AND XAH.PARENT_AE_HEADER_ID IS NULL
AND xah.accounting_entry_status_code = 'F'
AND opt.ENABLED_FLAG = 'Y'
AND rs.LEDGER_ID = opt.LEDGER_ID
AND ( rs.LEDGER_CATEGORY_CODE = 'PRIMARY'
OR rs.LEDGER_CATEGORY_CODE = 'SECONDARY')
AND rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND rs.ledger_id = gl.ledger_id
AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
AND NOT EXISTS (SELECT 1
FROM xla_ae_headers xah2
WHERE xah2.application_id = &p_application_id
AND XAH2.EVENT_ID IN (&p_event_id)
AND xah2.accounting_entry_status_code = 'F'
AND NVL(xah2.gl_transfer_status_code,'N') IN
('N','NT')) -- can be reversed only if it is transferred
AND EXISTS
( SELECT 1
FROM xla_ae_lines xal, gl_import_references gir
WHERE xah.ae_header_id = xal.ae_header_id
AND xah.application_id = xal.application_id
AND xal.gl_sl_link_id = gir.gl_sl_link_id
AND XAL.GL_SL_LINK_TABLE = GIR.GL_SL_LINK_TABLE
);

2. SELECT /*+ leading(xah) */
xah.*
FROM XLA_LEDGER_OPTIONS opt,
XLA_LEDGER_RELATIONSHIPS_V rs,
xla_gl_ledgers_v gl,
xla_ae_headers xah,
xla_subledgers xsu,
XLA_EVENTS XLE,
xla_transaction_entities_upg xte
WHERE opt.LEDGER_ID = xah.ledger_id
AND opt.APPLICATION_ID = xah.application_id
AND xsu.application_id = xah.application_id
AND xah.event_id in (&p_event_id)
AND xah.application_id = &p_application_id
AND xah.event_id = xle.event_id
AND xah.application_id = xle.application_id
AND xah.entity_id = xte.entity_id
AND xah.application_id = xte.application_id
AND XAH.PARENT_AE_HEADER_ID IS NULL
AND xah.accounting_entry_status_code = 'F'
AND opt.ENABLED_FLAG = 'Y'
AND rs.LEDGER_ID = opt.LEDGER_ID
AND ( rs.LEDGER_CATEGORY_CODE = 'PRIMARY'
OR rs.LEDGER_CATEGORY_CODE = 'SECONDARY')
AND rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND rs.ledger_id = gl.ledger_id
AND rs.SLA_ACCOUNTING_METHOD_CODE IS NOT NULL
AND NOT EXISTS (SELECT 1
FROM xla_ae_headers xah2
WHERE xah2.application_id = &p_application_id
AND XAH2.EVENT_ID IN (&p_event_id)
AND xah2.accounting_entry_status_code = 'F'
AND NVL(xah2.gl_transfer_status_code,'N') IN
('N','NT')) -- can be reversed only if it is transferred
AND EXISTS
( SELECT 1
FROM xla_ae_lines xal, gl_import_references gir
WHERE xah.ae_header_id = xal.ae_header_id
AND xah.application_id = xal.application_id
AND xal.gl_sl_link_id = gir.gl_sl_link_id
AND XAL.GL_SL_LINK_TABLE = GIR.GL_SL_LINK_TABLE
);

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