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 JUNE 08, 2016

Applies to:

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

Symptoms

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:

ERROR
-----------------------
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

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