Bills Receivable Maturity And Risk Program Error With: A Cash Receipt With This Number, Date, Amount And Customer Already Exists
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
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