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.


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
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:
2022 01-JAN-09 23275


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