My Oracle Support Banner

R12: AME Contingent Worker Not Able To Create Requisitions Fails At GET_NEXT_APPROVER_AME (Doc ID 781794.1)

Last updated on JULY 27, 2019

Applies to:

Oracle Purchasing - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2012***


Symptoms

On Release 12, when a contingent worker attempts to create a requisition, the Approvals Management Engine (AME) is not able to generate the approval hierarchy. The profile HR: Expand Role of Contingent Worker is set to 'Yes'

The failure displays in the wfstat.sql at:

ERROR:
ACTIVITY RESULT ERROR_NAME
----------------------------------- --------------- --------------
ERROR_MESSAGE
----------------------------------------------------------------------------------------------------
ERROR_STACK
----------------------------------------------------------------------------------------------------
GET_NEXT_APPROVER_AME #EXCEPTION WFENG_ITEM_ATT
R
3103: Attribute 'DOCUMENT_ID' does not exist for item 'REQAPPRV/39-81'.

AME_ABSOLUTE_JOB_LEVEL_HANDLER.getJobLevelAndSupervisor(24008)
AME_ABSOLUTE_JOB_LEVEL_HANDLER.handler(24009)
AME_ENGINE.processActionType(24010)
AME_ENGINE.processRules(24011)
AME_ENGINE.updateTransactionState(24012)
AME_ENGINE.getNextApprovers(24013)
AME_API2.getNextApprovers4(24014)
POR_AME_REQ_WF_PVT.Get_Next_Approvers: Unable to get the next approvers from
AME.(Get_Next_Approver: 002-39-REQUISITION-PURCHASE, ORA-20001: Cascaden, Susan
lacks a supervisor, so AME cannot complete the chain of authority for the transaction.)
Wf_Engine.GetItemAttrNumber(REQAPPRV, 39-81, DOCUMENT_ID)
POR_AME_REQ_WF_PVT.Get_Next_Approvers - Unexpected Exception: (Get_Next_Approver:
002-39-REQUISITION-PURCHASE, ORA-20002: 3103: Attribute 'DOCUMENT_ID' does
not exist for item 'REQAPPRV/39-81'.)
Wf_Engine.GetItemAttrNumber(REQAPPRV, 39-81, DOCUMENT_ID)
Wf_Engine_Util.Function_Call(POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS, REQAPPRV, 39-81, 193411, RUN)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.