My Oracle Support Banner

Automatic Receipts Issue: Automatic Receipts/Remittances Execution Report ORA-01403: No Data Found or APP-AR-11203: GL Date, 10-FEB-15, is Not in an Open or Future-Enterable Period (Doc ID 1970079.1)

Last updated on MAY 20, 2024

Applies to:

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


On : 12.2.3 version, Receipts Related

You are attempting to run Automatic Receipts ,in a request set, and receive the following intermittent error in the output report:

REP-1401: 'b_12formattrigger': Fatal PL/SQL error occurred.
ORA-01403: No Data Found

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: 'b_12formattrigger': Fatal PL/SQL error occurred.
ORA-01403: no data found

Error message in the fnd debug log:

APP-AR-11203: GL date, 10-FEB-15, is not in an open or future-enterable period.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Control > Request > Set
1. Create a request set with two programs, Automatic Receipts Master and Automatic Remittance Master
2. Control > Request > Run
3. Submit the request set


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.