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"
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.
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
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;
1. Went to Maintenance super User => Work Orders
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.
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