R12: AP Invoice Workflow Ends In Error ORA-01403: no data found

(Doc ID 2324607.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Invoice Issues & MassAdd

AP invoice workflow ends in error




ERROR
-----------------------
(Navigation with Workflow Administrator responsibility , Administrator Workflow->Status Monitor
to search workflows for @AP Invoice Approval type that are in error :)


Failed Activity Check Header Requirements
Activity Type Function
Error Name 100
Error Message ORA-01403: no data found ORA-01403: no data found
Error Stack APINVLDP.Check_Header_Requirements(APINVAPR, ..., ..., RUN) Wf_Engine_Util.Function_Call(AP_WORKFLOW_PKG.CHECK_HEADER_REQUIREMENTS, APINVAPR, ..., ..., RUN)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
initiate approval in invoice workbench via invoice actions.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot initiate invoice approval.

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