My Oracle Support Banner

AME Approval For Work Order Not Notifying User (Doc ID 2011076.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.0.6 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.



AME approval for Work Order not notifying user. This works in clone of production but not in production


Expect this work in Production


The issue can be reproduced at will with the following steps:
1. Setup AME
2. Create work order and release it
3. Notification stuck in error

Workflow Errors: EAMWOREL,1000

Failed Activity        Get Next Approver
Activity Type          Function
Error Name            100
Error Message        ORA-01403:no data found ORA-01403:no data found
Error Stack            AME_ENGINE.compareApplicaleRules(46608) AME_ENGINE.sortApplicaleRules(46609) AME_ENGINE.fetchApplicaleActions(46610) AME_ENGINE.updateTransactionState(46611)
                           AME_ENGINE.getNextApprovers(46612) AME_API2. getNextApprovers(46613) Wf_Engine_Util.Function_Call(EAM_WORKORDER_PVT.GET_NEXT_APPROVER, EAMWOREL,1000,264590,RUN)


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.