Payroll Process Errors: PLS-00306: Wrong Number Or Types Of Arguments In Call To 'EXP_CHK' (Doc ID 2666416.1)

Last updated on SEPTEMBER 22, 2021

Applies to:

Symptoms

After upgrade to 12.2.7, payroll process is completing with error.

ERROR
-----------------------
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO XXXX
APP-PAY-51118: Error was encountered when processing assignment XXXX
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'EXP_CHK'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

SQL_NO 567
TABLE_NAME pylvexc.exp_chk
APP-PAY-06881: Error ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'EXP_CHK'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
 has occurred in table pylvexc.exp_chk at location 567

Cause: an oracle error has occurred. The failure was reported on table pylvexc.exp_chk at location 567 with the error text ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'EXP_CHK'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Payroll after upgrade

Changes

 Upgrade to 12.2.7

Cause

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