My Oracle Support Banner

R12: AP: Internet Expenses Workflow Bothpay Process/Build Bothpay Expenses gives ORA-20001 APP-SQLAP-10000 ORA-01422 at AP_WEB_EXPENSE_WF.BuildBothpayReport (Doc ID 2982433.1)

Last updated on OCTOBER 25, 2023

Applies to:

Oracle Internet Expenses - Version and later
Information in this document applies to any platform.


When attempting to process expense report,
the following error occurs in the work flow.


Error Name -20001
Error Message ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in GetExpReportInfo with parameters () while performing the following operation:
Error Stack AP_WEB_EXPENSE_WF.BuildBothpayReport( Obtain the card number and the full name and the vendor information for the new expense report) Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.BUILDBOTHPAYEXPREPORT, APEXP, , , RUN)

The issue can be reproduced at will with the following steps:
1. Create an expense report
2. Submit for approval
3. Expense report struck in the work flow with above error..


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

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