My Oracle Support Banner

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.

Symptoms



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:


ORA-20002: 3825: Error '-6550 - ORA-06550: line 1, column 18:
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:

  1.  Responsibility: US HRMS Manager.

  2.  Navigate: Work Structures > Position > Description.
     
  3.  Select the Datetrack button and datetrack to any past date.

  4. Update the Position Details.

  5. Save.

  6. Automatic Position Synchronization is triggered via Business Event oracle.apps.wf.callback.delay but fails.

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.