ORA-20002 Seen in FND_LOGS After Updating Position Details in the Positions Description Form(HRWSPSF) with a Past Date
(Doc ID 2974720.1)
Last updated on SEPTEMBER 19, 2023
Applies to:Oracle Human Resources - Version 12.2 HRMS RUP16 and later
Information in this document applies to any platform.
When the seeded business event oracle.apps.wf.callback.delay is called, it then calls the wf_util.call_me_later_wf procedure. The wf_util.call_me_later_wf procedure in turn calls the hf_psf_shd.call_back procedure. However, the call_back procedure in the hr_psf_shd package is not in the spec and consequently can't be called publicly. Consequently we are encountering the following error in workflow when this happens:
PLS-00302: component 'CALL_BACK' must be declared' encountered during execution of Rule function 'wf_util.call_me_later_rf' for event 'oracle.apps.wf.callback.delay' with key 'hr_psf_shd.call_back'.
ORA-06512: at "APPS.WF_EVENT", line 2250
ORA-06512: at "APPS.WF_EVENT", line 821
ORA-06512: at "APPS.WF_CORE", line 318
ORA-06512: at "APPS.WF_CORE", line 315
ORA-06512: at "APPS.WF_EVENT", line 742
ORA-06512: at "APPS.WF_EVENT", line 2144
The issue can be reproduced at will with the following steps:
- Responsibility: US HRMS Manager.
- Navigate: Work Structures > Position > Description.
- Select the Datetrack button and datetrack to any past date.
- Update the Position Details.
- Automatic Position Synchronization is triggered via Business Event oracle.apps.wf.callback.delay but fails.
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