LNS Billing Errors After Creating Manual Bill - ORA-01086: savepoint BILL_LOANS_PVT (Doc ID 1959542.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

Symptoms

When running LNS:Billing, the following error occurs after creating a manual bill on the loan:

ORACLE error 1086 in FDPSTP

Cause: FDPSTP failed due to ORA-01086: savepoint 'BILL_LOANS_PVT' never
established in this session or is invalid
ORA-06512: at

Steps to Reproduce:

Responsibility: Loan Agent
Navigation: Loan Dashboard

1. Create a new loan and approve.
2. Created a manual bill for the new loan, for the entire amount.
3. Run the loans billing, for all loans, and it produces the error in LNS Billing.
4. If the AR invoice created by the manual bill is adjusted to 0 first, then there is no error in loans billing.
5. It only happens on new loans.

Cause

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