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.

Symptoms

ACTUAL BEHAVIOR

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

EXPECTED BEHAVIOR

Expect this work in Production

STEPS

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)


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