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 JUNE 28, 2021
Applies to:
Oracle Self-Service Human Resources - Version 12.1 HRMS RUP11 and laterInformation 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
-----------------------
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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |