ORA-01422 Error Occurs After User Applies Receipt about Related Account via "Apply and Search" Button (Doc ID 2540155.1)

Last updated on DECEMBER 08, 2020

Applies to:

Symptoms

When user tries to use Apply and Search function, the following error occurs.
This error occurs after user applies Receipt about related Account.

Reproduced Steps:

1. Un-check "Allow Payment of Unrelated Transactions" in AR system option
2. Create Customer
    Customer Name : AAAAA
    Customer Name : BBBBB
   
   
3. Create Account Relationships between AAAAA and BBBBB
    Customer Name : AAAAA
      -->>>
      Customer       : BBBBB
      Account Number : BBBBB
      Operating Unit : Operating Unit 01
      Reciprocal     : Y
      Bill To        : Y
      Ship To        : Y
   
   
4. Create Invoices for both Customers
5. Create Receipt
    Receipt 1 -->> Customer is AAAAA
    Receipt 2 -->> Customer is BBBBB <- Account Relationship
    Receipt 3 -->> Customer is AAAAA
   
   
6. Apply Receipt with Search and Apply function.
   1. Open Receipt window and search Receipts by Date and Status = Unapplied.
   2. Set cursor at Receipt 1 and click "Search and Apply" button.
      Receipt 1 is for Customer Name AAAAA
      
      
   3. Click "Apply" button and save it.
   4. Close Application window.
   5. Set cursor at Receipt 2 and click "Search and Apply" button.
      Receipt 2 is for Customer Name BBBBB.
      This Account is Account Relationship.
      
      
   6. Click "Apply" button and save it.
   7. Close Application window.
   8. Set cursor at Receipt 3 and click "Search and Apply" button.
      Receipt 3 is for Customer Name AAAAA.
   9. Click "Apply" button and the following error occurs.
      
      ORA-01422: exact fetch returns more than requested number of rows
      ORA-06512: at "APPS.ARP_PAY_REL_CUST_PKG", line 572
      
      --------------------------------------------------------------
      FRM-40735: PRE-QUERY trigger raised unhandled exception ORA-01422.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.