My Oracle Support Banner

Bills Receivable Maturity And Risk Program Error With: A Cash Receipt With This Number, Date, Amount And Customer Already Exists (Doc ID 2181969.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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


Bills Receivable Maturity and Risk Program Phase completed with status error.

EP-1401: 'beforereport': Fatal PL/SQL error occurred. ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.ARP_BR_HOUSEKEEPER_PKG", line 344 REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1401

Log file shows:

API error count : AR_RECEIPT_API_PUB.Create_and_apply : 1
A cash receipt with this number, date, amount and customer already exists.
API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt User-Defined Exception
Exception: arp_br_housekeeper_pkg.create_and_apply_ReceiptUser-Defined Exception
Exception: arp_br_housekeeper_pkg.process_standard_remitted User-Defined Exception
Exception: arp_br_housekeeper_pkg.ar_br_housekeeper User-Defined Exception

The issue can be reproduced at will with the following steps:
1. Run the Bills Receivable Maturity and Risk Program
2. Got error out with above error




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.