R12 : Bank Statement Import Error Message: GL date that you entered is not in an open or future (Doc ID 1418263.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

While importing the bank statement from interface Open Period Error message when all the relevant periods in AP, PO, AR and GL are open.
Bank Statement Import Execution Report Report
Statement Exceptions
-------------------------------
Error
---------
The GL date that you entered is not in an open or future enterable period in Payables and Receivables.
Case 1:
There is some data corruption here.. the set of books id should be 101 for the legal entity with legal_entity_id 0.

Case 2:
SET_OF_BOOKS_ID CASHBOOK_BEGIN_DATE LEGAL_ENTITY_ID
2022 01-JAN-09 23275

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