Revolving Loan: Principal Paydown does not Create AR Invoices Consistently (Doc ID 2214315.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version,

When creating a Principal Paydown against a Revolving Loan, it should automatically create an AR invoice (using Transaction Source: OKL_MANUAL). But this is not happening consistently. For the same contract, the Principal paydown is creating an AR invoice in some cases. But for some cases, it is not creating any AR Invoice. The seeded Workflow OKL: Customer Service Principal Paydown'' shows the following error:

ERROR
-----------------------
ORA-01400: cannot insert NULL into ("OKL"."OKL_TRX_AR_INVOICES_B"."ID") in Package OKL_STREAM_BILLING_PVT Procedure BULK_PROCESS’


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a new Transaction Source in AR called 'OKL_MANUAL'.
2. Create a 'Revolving' Credit Line for $1,000,000
3. Create a 'Revolving Loan' Contract and associate the above Credit Line
4. Book the above Contract
5. Create a Funding Request for the above contract for an amount of $100,000 (Funding Type: Borrower Payment)
6. Process 'OKL Transfer to AP' Request Set
7. Invoice created in Payables for the funding amount
8. Validate, Approve and Pay the above AP Invoice in full
9. Process the 'Loan Balances Update' program for this contract
10. Create a Principal Paydown in Lease Center for the above contract for an amount of $11,111
11. This should create an Invoice in Oracle Receivables using the source as 'OKL_MANUAL' for an amount of $ 11,111
12. Create one more Principal Paydown in Lease center for an amount of $ 22,222
13. This should create another Invoice in Oracle Receivables using the source as 'OKL_MANUAL' for an amount of $ 22,222
14. Create one more Principal Paydown in Lease center for an amount of $ 33,333
15. This should create another Invoice in Oracle Receivables using the source as 'OKL_MANUAL' for an amount of $ 33,333



Changes

 

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