R12: OIE: Submitting an Expense Report Errors with ORA-1422 GetVendorAWTSetupForExpRpt
(Doc ID 2927916.1)
Last updated on FEBRUARY 16, 2023
Applies to:
Oracle Internet Expenses - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Error encountered when trying to submit expense report. The employee for this expense has two supplier records which they accidentally created.
ERROR
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in GetVendorAWTSetupForExpRpt with parameters () while performing the following operation:
-----------------------
ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in GetVendorAWTSetupForExpRpt with parameters () while performing the following operation:
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to the Internet Expense responsibility
2. Create an expense report in Internet Expenses
3. Select the 'Submit' button, and receive the error
Changes
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 |