My Oracle Support Banner

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:

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


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
: 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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