Unable To 'Adjust' Or 'Credit' Billed And Unbilled Transactions When Cancelling A Loan
Last updated on JANUARY 25, 2018
Applies to:Oracle Loans - Version 12.1.3 and later
Information in this document applies to any platform.
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:
"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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms