R12: OIE: Expense Report Errors with Process Mileage Lines APP-SQLAP-10000: ORA-01403: No Data
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
After expense report is manager approved and audited, then the following workflow error occurs within the Mileage Process
Process Mileage Lines APP-SQLAP-10000: ORA-01403: no data found
ORA-20001: APP-SQLAP-10000: ORA-20001: APP-SQLAP-10000: ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in updateNewDistNumber with parameters () while performing the following operation: occurred in processCrossThreshold with parameters () while performing the following operation: occurred in ProcessMileageLines with parameters () while performing the following operation:
Error Stack : Wf_Engine_Util.Function_Call(AP_WEB_EXPENSE_WF.PROCESSMILEAGELINES, APEXP, 449450, 304234, RUN)
Steps to Reproduce
1. Submit 2 mileage expense reports
2. The first expense report is manager and payables approved.
3. When the second expense report is approved both by manager and payables, then the expense report errors in workflow within the Mileage Process
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms