When trying to view event details in Subledger Accounting there is error "You have encountered an unexpected error" (Doc ID 2210561.1)

Last updated on DECEMBER 08, 2016

Applies to:

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

Symptoms

On Application Release 12.1.3:

It was found that, after clicking on Error link on SLA Accounting Events page, for an event in Error status, following error is occurring:

"You have encountered an unexpected error".

Detailed Java error stack is also showing:

java.sql.SQLException: ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_transaction_id_pkg.get_transaction_identifiers. ORA-00932: inconsistent datatypes: expected - got -.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 110
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 289
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 162
ORA-06512: at "APPS.XLA_TRANSACTION_ID_PKG", line 861
ORA-06512: at line 1

Error is found for events related to Subinventory Transfers and Logical Intercompany transactions.

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