POXDOFDO: Forwarding requisitions from Forward Documents intermittently fail with PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD (Doc ID 1954559.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

Intermittently when attempting to forward a requisition using the Forward Documents form, the requisition gets stuck in process and the following errored activities are generated:

ERROR
-----------------------
• ACTIVITY = UPDATE_ACTION_HISTORY_FORWARD
• Activity Display Name = Update Action History (Forward)
• RESULT = #EXCEPTION
• ERROR_NAME = -6512
• ERROR_MESSAGE = ~ORA-06512: at line ~
• ERROR_STACK = Wf_Engine_Util.Function_Call(PO_APPROVAL_LIST_WF1S.UPDATE_ACTION_HISTORY_FORWARD, REQAPPRV, 196435-995956, 265952, RUN)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Management > Forward Documents
2. Find documents to be forwarded
3. Select documents
4. Specify the new approver in New Approver field
5. Save

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot forward requisitions using the Forward Documents form.

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