Payroll error ORA-20001: Variable EFFECTIVE_DATE not initialized at line 48 of AU_PAYROLL_TAX (Doc ID 2884088.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
AU_PAYROLL_TAX Fast formula failing

When calling the standard Fast Formula AU_PAYROLL_TAX it is failing with the below error:

Exception: ORA-20001: Variable EFFECTIVE_DATE not initialized at line 48 of AU_PAYROLL_TAX

Cause: An attempt has been made to use a local variable before it was initialized. This is normally detected by the verifier, but in certain cases this is not possible, and will result in this error. This problem can be corrected by the altering the formula. Assign an initial value to the variable before it is referenced in the formula.

Action: Please refer to your system administrator.

EXPECTED BEHAVIOR
-----------------------
AU_PAYROLL_TAX Fast formula should not fail

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Run payroll using seeded elements with no issue
2.  Run payroll using custom script calling AU_PAYROLL_TAX

XX HRMS Manager > Processes and Results > Submit Processes > Payroll

3.  Observe error:

ORA-20001: Variable EFFECTIVE_DATE not initialized at line 48 of AU_PAYROLL_TAX

Changes

 Issue started after patches applied, after RUP Patch 31800665 upgrade (on 02-Jul-2022) and 33697780:R12.PAY.C  (on 29-Jun-2022).

Cause

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