My Oracle Support Banner

R12: IBY: Unable To Void Payments For A Supplier, Duplicate Records Exist In IBY_ACCOUNT_OWNERS Due to Error APP-SQLAP-10000: ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 2778969.1)

Last updated on FEBRUARY 25, 2025

Applies to:

Oracle Payables - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

While trying to void payments related to a supplier, we are getting an error message:

APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in
AP_AIP_TABLE_HANDLER_PKG.Insert Row<-AP_PAY_INVOICE_PKG.ap_pay_insert_invoice_payments<-AP_PAY_INVOICE_PKG.ap_pay_invoice<-AP_VOID_PKG.AP_REVERSE_CHECK<-APXPAWKB
with parameters (Invoice_id = ##INV##, Payment_num = 1, Check_id = ##CHK##
...
while performing 'Get the IBAN_NUMBER'
Where ##INV## and ##CHK## are the actual Invoice_ID and Check_ID of the Invoice paid by the Payment you trying to Void, respectively.


Here is the screen shot of the entire pop up error message

This is happening Only for one particular supplier, for two sites so far.

STEPS TO REPRODUCE

  1. Log into Oracle Applications using Paybles responsibility.
  2. Open the Payment Workbench form (N)Payments > Entry > Payments
  3. Query a Check to Void.
  4. Click on [Actions]
  5. Select "Void" and enter "Date", "GL Date" and select "Invoice Action"
  6. Click [Ok]
  7. The Error pops up.

 

Changes

 Upgraded to Release 12.2.9

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
Changes
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.