My Oracle Support Banner

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

Last updated on JUNE 10, 2021

Applies to:

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


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

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.


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.