Expense Reports Workflow (APEXP) Gets Stuck With Error ORA-01403: no data found in Procedures AME_ENGINE.setInsertedApprovalStatus and AP_WEB_EXPENSE_WF.AMEPropagateApprovalResult
Last updated on MARCH 08, 2017
Applies to:Oracle Internet Expenses - Version: 18.104.22.168 to 22.214.171.124 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Error Name: 100
Error Message: ORA-01403: no data found
ORA-01403: no data found
AP_WEB_EXPENSE_WF.AMEPropagateApprovalResult(APEXP, 10529-2, 165645, Call AME_API2.updateApprovalStatus )
Wf_Engine_Util.Function_Call(ap_web_expense_wf.AMEPropagateApprovalResult, APEXP, 10529-2, 165645, RUN)
1 - Employee A (Manager) has 2 employees reporting into him : Employee B and Employee C.
2 - Employee A sets his vacation rules to delegate all expense report notifications to Employee B.
3 - When Employee C submits expense claims for approval, they get directed to Employee B (as expected).
4 - But even after approving the claim, Employee B receives a second notification for approval of the same expense claim.
And after approving for second time, the notification ends with the reported error.
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