Automatic Receipt Master Program Error REP-1401: 'b_12formattrigger' ORA-1403 (Doc ID 1968656.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Receipts Related

You are attempting to create Automatic Receipts in one Operating Unit.
The Operating Unit functional currency is GBP.

You have created an invoice in EUR.

When you run the Automatic Receipt Master program, and select EUR payment method, the program completes with the following error:

ARZCARPO module: Automatic Receipts/Remittances Execution Report

ERROR
-----------------------
Enter Password:
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

FND debug shows the following:

APP-AR-96883: Invalid arguments EXCHANGE_RATE(_TYPE) for the procedure INSERT_AUTO_BATCH

You are able to generate Automatic Receipts manually.

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