HRGLOBAL Failed On Hrrunprc.sq,l With: ORA-20001: Phase 1 will cause exceptions to be raised
(Doc ID 2249134.1)
Last updated on MAY 25, 2018
Applies to:Oracle HRMS (Saudi Arabia) - Version 12.2.4Cloud and later
Information in this document applies to any platform.
When attempting to run hrglobal.drv for "Saudi Arabia" (patch 21746871, PAY is shared) the following error occurs in hrrunprc.sql:
ORA-20001: Phase 1 will cause exceptions to be raised.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_LEGISLATION", line 7868
ORA-06512: at line 1
When reviewing the HR Stu_Exceptions table, the following is seen
select * from hr_stu_exceptions returns
PAY_BALANCE_TYPES 71 Parent balance dimension does not exist Employee PPA Annuities
PAY_BALANCE_TYPES 72 Parent balance dimension does not exist Employee PPA Arrears
PAY_BALANCE_TYPES 73 Parent balance dimension does not exist PPA Annuities
PAY_BALANCE_TYPES 74 Parent balance dimension does not exist PPA Hazards
PAY_BALANCE_TYPES 75 Parent balance dimension does not exist PPA Reference Earnings
PAY_BALANCE_TYPES 76 Parent balance dimension does not exist Subject To PPA
Also table PAY_BALANCE_TYPES is empty.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Run hrglobal.drv
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!