Workflow Approver response fails with 'Error in Workflow OKLAMAPP ORA-20001: The Transaction ID Specified Returned An Incorrect Number Of Rows For TRANSACTION_REQUESTOR_PERSON_ID' (Doc ID 1325142.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Lease and Finance Management - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance on 29-Jul-2013

Symptoms


On: 12.1.3 version, Workflow Issues

When attempting to use user Supervisory Hierarchy for the OKL LA Contract Approval Transaction the transaction goes back to the requestor with the following error.

ERROR
-----------------------
Error in Workflow OKLAMAPP/OKLAMAPP35919 ORA-20001: The transaction ID specified returned an incorrect number of rows for TRANSACTION_REQUESTOR_PERSON_ID. Ensure you specify a valid transaction ID and the dynamic query of the attribute returns correct number of rows.
Error Stack =
AME_ENGINE. FetchAttributeValues(34143)
AME_ENGINE.setContext(34143
AME_ENGINE.updateTransactionState(34145)
AME_ENGINE.updateApprovalStatus(34146)
AME_API2.updateApprovalStatus(34147)
OKL_AME_WF.SET_APPROVAL_STATUS(OKLAMAPP.OKLAMAPP34919, 207457, RUN)
Wf_Engine_Util.Function_Call(OKL_AM_WF.SET_APPROVAL_STATUS, OKLAMAPP, OKLAMAPPP35919, 207457, RUN)
Activity Id =207457
Activity Label = APPROVAL_PROC_SET_STATUS_FUNC
Result Code #EXCEPTION
Notification Id =
Assigned User =
Error Message = An error was encountered but no message was found in the error stack


STEPS to Reproduce

1. Define 2 employees in HR with one as the manager of the other.
2. Setup OKL LA Contract approval AME transaction
3. Enable AME approvals for OKL.
4. Use the first employee user to create & submit a contract & make the other employee approve it.
5. Check the requestor employee notification. This shows an error.

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