My Oracle Support Banner

R12 E-Business Suite Workflow Administration Users Report Workflow Processes Fail With Error 'ORA-01403: NO DATA FOUND' After Applying Patch 24294590 And Setting 'WF: Disable Reassign to Submitter' to YES (Doc ID 2375161.1)

Last updated on JULY 20, 2018

Applies to:

Oracle Workflow - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Workflow, Workflow Administration related issues

 

 

 

 

After installing <Patch 24294590> and setting the profile option 'WF: Disable Reassign to Submitter' to YES at site level, some workflows fail with the following error:

'ORA-01403 no data found.'

Further investigation shows when vacation rules were in place the following workflow returned the error:

CMREQ_COLLECTOR_APPROVAL #EXCEPTION 100

In other cases the receivables collection workflow failed with the above error.

Changes

 Applied 24294590

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.