My Oracle Support Banner

After Upgrade RUP11 (Patch 27115060) When Workflow Transaction Resubmitted Error Occur - Error 3000: Invalid value(s) passed for arguments. NID= ANAME=WF_NOTE (Doc ID 2492818.1)

Last updated on NOVEMBER 23, 2020

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.
pqwftswi.pkb
pqwftswi.pkh

Symptoms

On : 12.1 HRMS RUP11 version, Workflow,Approval,Common Funct

When the transaction is resubmitted by the approver after upgrade RUP 11,
the following error occurs.

ERROR
-----------------------

3000: Invalid value(s) passed for arguments. NID= ANAME=WF_NOTE
Failed Activity V5.0 Complete Notified activity in Approval Flow
Activity Type Function
Error Name WFSQL_ARGS
Error Message 3000: Invalid value(s) passed for arguments. NID= ANAME=WF_NOTE
Error Stack Wf_Engine.AddItemAttr(HRSSA, 1830067, CREATOR_PERSON_USERNAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, APPROVAL_CREATOR_USERNAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, CURRENT_PERSON_USERNAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, CURRENT_PERSON_DISPLAY_NAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, FORWARD_TO_USERNAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, FORWARD_FROM_USERNAME) Wf_Engine.AddItemAttr(HRSSA, 1830067, FORWARD_FROM_ROLE_NAME) Wf_Notification.SetAttrText(, WF_NOTE) pqh_ss_workflow.start_approval_wf(HRSSA, 1830067) Wf_Engine_Util.Function_Call(pqh_ss_workflow.start_approval_wf, HRSSA, 1830067, 501517, RUN)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Employee Self Service.
2. Create Termination transaction and submit.
3. Log in as one of the approvers
4. Open the notification and click on Update Action link.
5. Make changes and submit. Now check the status from Status Monitor, the transaction is errored.




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
References


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