HRGLOBAL Failed On Hrrunprc.sq,l With: ORA-20001: Phase 1 will cause exceptions to be raised (Doc ID 2249134.1)

Last updated on MARCH 30, 2017

Applies to:

Oracle HRMS (Saudi Arabia) - Version 12.2.4Cloud and later
Information in this document applies to any platform.

Symptoms

When attempting to run hrglobal.drv for "Saudi Arabia" (patch 21746871, PAY is shared) the following error occurs in hrrunprc.sql:

 

ERROR at line 1:
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

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms