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 DECEMBER 09, 2021
Applies to:Oracle Payables - Version 12.2.9 and later
Information in this document applies to any platform.
While trying to void payments related to a supplier, we are getting an error message:
with parameters (Invoice_id = ##INV##, Payment_num = 1, Check_id = ##CHK##
while performing 'Get the IBAN_NUMBER'
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
- Log into Oracle Applications using Paybles responsibility.
- Open the Payment Workbench form (N)Payments > Entry > Payments
- Query a Check to Void.
- Click on [Actions]
- Select "Void" and enter "Date", "GL Date" and select "Invoice Action"
- Click [Ok]
- The Error pops up.
Upgraded to Release 12.2.9
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