Bills Receivable Maturity And Risk Program Error: Customer bank account identifier is invalid. (Doc ID 567395.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version: 11.5.10.2 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
ConcurrentProgram:ARBRCLRG - Bills Receivable Maturity and Risk Program

Symptoms

Oracle Receivables (AR): Receipts Workbench Information Center >  Note 567395.1
Oracle Receivables (AR): Transactions Workbench Information Center > Note 567395.1

The Bills Receivable Maturity and Risk Program - ARBRCLRG fails with error. Review of the log file shows:

ERROR
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.ARP_BR_HOUSEKEEPER_PKG", line 341
API error count : AR_RECEIPT_API_PUB.Create_and_apply : 2
1 : Customer bank account identifier is invalid.
2 : Please enter a receipt number.
API Exception: arp_br_housekeeper_pkg.create_and_apply_Receipt User-Defined Exception


Steps to Reproduce:
  1. Responsibility: Receivables Manager
    Navigation:
    Customers > Standard
    Create a customer
    Define a BILL-TO Site for this customer
    Associate a bank at the Site level
    Define a DRAWEE Site for this customer
  2. Responsibility: Receivables Manager
    Navigation
    : Bills Receivable > Transactions
  3. Create a BR associated to a Drawee which when defined first created a Bill to Site  that has a Bank account details at Site level
  4. Responsibility: Receivables Manager
    Navigation: Bills Receivable > Remittances
  5. Create a BR remittance to include the BR above. Use Standard or Factored with Recourse remittance methods
  6. Responsibility: Receivables Manager
    Navigation: Bills Receivable > Maturity and Risk Programs
  7. Submit the process entering date parameters to ensure the BR above is processed. The process fails and the log shows the errors above.

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