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

Last updated on SEPTEMBER 13, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.