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 JANUARY 02, 2018

Applies to:

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

Symptoms

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:
Responsibility
: Loan Agent
Navigation
: 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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.