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 MARCH 08, 2017

Applies to:

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

Symptoms

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

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

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


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