Creating an Adjustment Using Adjustment API AR_ADJUST_PUB.Create_Adjustment Fails - No Valid Open or Future Enterable GL Periods Exist for the Set of Books ID (Doc ID 155914.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Attempting to create an Adjustment, using the AR_ADJUST_PUB.Create_Adjustment API and receive the following error:

Error
No valid open or future enterable GL periods exist for the set of books id

Error: FND_AS_UNEXPECTED_ERROR (PKG_NAME=AR_ADJVALIDATE_PVT)
(PROCEDURE_NAME=Validate_dates)(ERROR_TEXT=ORA-01403: no data found)

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