ORA-01403: no data found in EDR_PSIG_RULE When Trying to Complete Work Order with the Setup Done as No/Disabled or Yes/Enabled (Doc ID 1524998.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

We trying to complete Work Order from EAM -> Work Orders (Self Service), why are we getting this error:
"You have encountered an unexpected error. Please contact the System Administrator for assistance."
 

The setup regarding parameters and profiles is set to No. However, the same is valid if the parameter and profile are set to Yes, as functionality is needed for other cases, but there is no setup for completion.

1. EAM -> Setup -> Parameters
<Enable Workflow for Workorders> is DISABLED

2. The profile value of "EDR :E-Records and E-Signatures" is set to NO at site level.

This profile could be set to YES already, due to usage in other parts of EBS.

Log details shows

## Detail 0 ##
oracle.apps.edr.framework.EresException: ORA-20002: 3825: Error '-20001 - ORA-20001: APP-FND-01934: ORA-20001: Approval engine for the transaction type oracle.apps.eam.wo.comp.ss has failed with following error: ORA-01403: no data found.
Change the approval setup and retry. in Package EDR_PSIG_RULE Procedure PSIG_RULE' encountered during execution of Rule function 'EDR_PSIG_RULE.PSIG_RULE' for event 'oracle.apps.eam.wo.comp.ss'

Solution

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