Cancelling a Loan with Credit Errors with Savepoint 'APPROVELOANCANCELREQUEST' Never Established (Doc ID 2150000.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

Cancelling a loan with the option of "Credit" results in the following error:

"Exception in LnsPayoffPub.approveloancancelrequest api call: java.sql.SQLException: ORA-01086: savepoint 'APPROVELOANCANCELREQUEST' never established in this session or is invalid
ORA-06512: at ""APPS.LNS_PAYOFF_PUB"", line 3157
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
"
"oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-01086: savepoint 'APPROVELOANCANCELREQUEST' never established in this session or is invalid
ORA-06512: at ""APPS.LNS_PAYOFF_PUB"", line 3157
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

The debug log for LNS: Billing will show an error similar to:

Exception : Others in validate_request_parameters
arp_util.Validate_Desc_Flexfield()-
Err. Transaction Information FF Validation
Done with validate_request_parameters
Failed validation routine. Raising exception
Exception validation_failed
User-Defined Exception
l_return_status: E

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