Quickpay Error ORA-04063: package body "APPS.PAY_RETRO_PKG" has error occurred in table hrdynsql.get_tax_unit at location
(Doc ID 2966871.1)
Last updated on AUGUST 16, 2023
Applies to:
Oracle Payroll - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Quickpay completes in error with the log file showing the below error message.
HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO xxxxxx
APP-PAY-51118: Error was encountered when processing assignment xxxxxx
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
SQL_NO 1565
TABLE_NAME hrdynsql.get_tax_unit
APP-PAY-06881: Error ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
has occurred in table hrdynsql.get_tax_unit at location 1565
Cause: an oracle error has occurred. The failure was reported on table hrdynsql.get_tax_unit at location 1565 with the error text ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
ASGNO xxxxxx
APP-PAY-51118: Error was encountered when processing assignment xxxxxx
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
SQL_NO 1565
TABLE_NAME hrdynsql.get_tax_unit
APP-PAY-06881: Error ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
has occurred in table hrdynsql.get_tax_unit at location 1565
Cause: an oracle error has occurred. The failure was reported on table hrdynsql.get_tax_unit at location 1565 with the error text ORA-04063: package body "APPS.PAY_RETRO_PKG" has errors
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: HRMS Manager
2. Navigate to People > Enter and Maintain > Assignment > Others > Quickpay
3. Run Quickpay
4. Check the result and log
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 |