R12: OIE: Expense Report Errors with Process Mileage Lines APP-SQLAP-10000: ORA-01403: No Data

(Doc ID 2027395.1)

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.

Symptoms

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

ERROR
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

Cause

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