Error while changing the workflow in Approval History tab in Maintenance Super User page if the custom workflow is not registered under EAM application: ORA-06512: at "APPS.EAM_WORKORDER_UTIL_PKG"

(Doc ID 1304048.1)

Last updated on OCTOBER 28, 2016

Applies to:

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

Symptoms

Getting Error while changing the workflow in approval history tab in Maintenance Super User page if the custom workflow is not registered under EAM application

ERROR
-----------------------
java.sql.SQLException: ORA-01403: no data found ORA-06512: at "APPS.AME_API2", line 586 ORA-06512: at "APPS.EAM_WORKORDER_UTIL_PKG", line 1897 ORA-06512: at "APPS.EAM_WORKORDER_UTIL_PKG_W", line 103 ORA-06512: at line 1

We also examined with our developer. We noticed that in EAM_WORKORDER_UTIL_PKG package 426 is used as a hard coded application_id. As we are using custom developed workflow here, we think that the problem can be overcomed by providing a variable for application_id, rather than giving a hard coded application_id here.

The change I had made at the package is at 1882. row.

The query is like that;



STEPS
-----------------------
1. Went to Maintenance super User => Work Orders
query: WO265421

Click on Approval History

Customer has another workflow for controlling workorder status change apart from workorder release workflow.

And the error is coming up when changing the workflow from workorder release to workorder status control workflow under approval history tab.

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