Unable To 'Adjust' Or 'Credit' Billed And Unbilled Transactions When Cancelling A Loan (Doc ID 1666805.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Loans - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When clicking the Cancel Loan button, the following error is observed:

"'You have encountered an unexpected error. Please contact the System Administrator for assistance."

Further details about the error show:
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'APPROVELOANCANCELREQUEST' never established in this session or is invalid
ORA-06512: at "APPS.LNS_PAYOFF_PUB", line 3151
ORA-01086: savepoint 'APPROVE_CANCEL_REM_DISB' never established in this session or is invalid
ORA-06512: at "APPS.LNS_FUNDING_PUB", line 7430
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

The debug shows the following:

calling XLA_ACCOUNTING_PUB_PKG.accounting_program_doc_batch
"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_accounting_pub_pkg.accounting_program_doc_batch. ORA-00001: unique constraint (XLA.XLA_EVT_CLASS_ORDERS_GT_U1) violated."
l_return_status = E
User-Defined Exception
l_return_status: E
BUDGETARY CANCEL_FAILED

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