My Oracle Support Banner

The HRGLOBAL.drv Failed With file "payprep.sql" After Applying The 'R12.HR_PF.C.delta.17 - 34444470' Patch , Error "FAILED: file payprep.sql on worker 1." (Doc ID 2997727.1)

Last updated on JANUARY 11, 2024

Applies to:

Oracle Human Resources - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When attempting to run HRGlobal, the following error occurs,
the following error occurs.

ERROR
-----------------------
ATTENTION: All workers either have failed or are waiting:

FAILED: file payprep.sql on worker 1.
FAILED: file payprep.sql on worker 2.
FAILED: file payprep.sql on worker 3.
FAILED: file payprep.sql on worker 4.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Worker Error:
==========
per_ad_zd_seed_wrapper.prepare('BEN_BENEFIT_CLASSIFICATIONS',l_sequence,l_worker,l_total_workers); 

ERROR at line 10:
ORA-06550: line 10, column 4:
PLS-00306: wrong number or types of arguments in call to 'PREPARE'
ORA-06550: line 10, column 4:
PL/SQL: Statement ignored
ORA-06550: line 13, column 4:
PLS-00306: wrong number or types of arguments in call to 'PREPARE'
ORA-06550: line 13, column 4:
PL/SQL: Statement ignored
ORA-06550: line 16, column 4:
PLS-00306: wrong number or types of arguments in call to 'PREPARE'

STEPS
-----------------------
1. Apply 'R12.HR_PF.C.delta.17 - 34444470' Patch.
2. Run HRGlobal.drv
3. HRGlobal.drv patch failed with above mentioned error and file.

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.