My Oracle Support Banner

After Upgrade While Running Payroll Getting Error PLS-00306: wrong number or types of arguments in call to 'CHECK_EXPIRATION (Doc ID 2909729.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 12.1.3 to 12.2.10, payroll and quickpay process ending with the following 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 'CHECK_EXPIRATION'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login HRMS Manager Responsibility
2. Navigate to Enter and Maintain-> Query for employee -> assignment-> Other-> Quick Pay
3. Run Quick Pay/ Payroll RunAbove error comes

Changes

 Upgrade to 12.2

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


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