My Oracle Support Banner

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:

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

Symptoms

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

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.

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

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
Symptoms
Cause
Solution
References


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