R12:IBY :APP-SQLAP-10000: ORA-01422 Error on Payment Workbench
(Doc ID 2625445.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Trading Community - Version 12.1.3 and laterOracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
STEPS
-----------------------
1. Login to Oracle Payables responsibility
2. Navigate to Payments > Entry > Payments
3. Create a Quick payment
While creating the payment for one Supplier Via Payment Workbench throws below error
ERROR :
APP.SQLAP-10000: ORA-01422: Exact fetch returns more than the requested number of rows
AP_AC_TABLE_HANDLER_PKG.INSERT_ROW
Get the IBAN_NUMBER
FND Debug :
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log 4.00 "APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in
AP_AC_TABLE_HANDLER_PKG.INSERT_ROW<-AP_CHECKS_PKG.INSERT_ROW<-APXPAWKB
with parameters (ROWID = , CHECK_ID = XXXXX)
while performing the following operation:
Get the IBAN_NUMBER"
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 |