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:Oracle HRMS (Australia) - Version 12.2.10 and later
Information in this document applies to any platform.
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.
AU_PAYROLL_TAX Fast formula should not fail
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
Issue started after patches applied, after RUP Patch 31800665 upgrade (on 02-Jul-2022) and 33697780:R12.PAY.C (on 29-Jun-2022).
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