My Oracle Support Banner

Oracle Loans: Not Able To Enter Loans With Future Term Start Date - GL Date is Not in An Open or Future Enterable Period (Doc ID 1508570.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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


Attempting to enter a loan with a future start date in 12.1.3, the loan fails on approval with the following:

The GL date : xx-xxx-xx is not in an open or future enterable period
Call to AR_ADJUST_PUB.Create_Adjustment failed. unknown
The following SQL error occurred: Failed API call: LNS_BILLING_BATCH_PUB.ADJUST_ORIGINAL_RECEIVABLE SQLERRM: User-Defined Exception. Contact your system administrator.

Steps to Reproduce:
: Loan Agent
: Loans Dashboard > Create Loan
Enter a loan with a future start date (a date beyond the current month and open period)
Approve the loan
Error is received


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.