Oracle HRMS HRGLOBAL Basics

APPLIES TO:

Oracle Human Resources - Version 11.5.10.2 and later
Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

GOAL

Intent of this document is to provide a better understanding of HRGLOBAL, datainstall, and related patches.  Extensive troubleshooting of problems encountered when applying hrglobal.drv is NOT included here.

SOLUTION

One of the most perplexing requests an HRMS or Payroll user can encounter is apply HRGLOBAL. What does apply HRGLOBAL really mean?  What steps are needed ?

HRGLOBAL Facts:

Oracle HRMS and Oracle Payroll products need to support the legislative requirements of multiple countries.  The primary way legislative updates are delivered is via patches which contain HRMS Legislative Data.  Collectively this set of patches and data is often referred to as 'HR GLOBAL' or 'HRGLOBAL'.  The way updates are delivered underwent a significant change mid 2006.  In the past there was an "HRGLOBAL: DELIVERY OF LATEST HRMS LEGISLATIVE DATA", patch which would get updated very frequently.   HRGLOBAL files (including the driver - hrglobal.drv) are now being included in the actual legislative pre-reqs instead of being delivered within an all encompassing HRGLOBAL patch. This will enable better support for delivering different states of legislative data across different patchset levels and a more streamlined patching process.
  Latest HRMS (HR Global) Legislative Data Patch available, is the official source for details on HR GLOBAL updates, prerequisite patches needed, and steps for applying updates.

DataInstall Facts:

Many of the actions to be performed when hrglobal.drv is applied are controlled via utility program DataInstall.  Technically DataInstall is a small java program.  The command line for the DataInstall program is as follows:

java oracle.apps.per.DataInstall
where / refers to the APPS schema
             should normally be "thin"
          is connection information in the form of hostname:dbport:oraclesid
for example:  java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb
For Apps 11.5.9 and below please substitute jre instead of java

Note: Syntax for selecting actions has changed over time.  More current versions of DataInstall, have been simplified to use just Install and Clear.  The old Force Install is gone.  Always select Install for any item that needs to be updated, even if it displays as 'Installed'.

On what server do I run the datainstall utility and hrglobal.drv?

The datainstaller and hrgobal driver are run on your database tier. If one tier is a DMZ,  and the DMZ is level of security and not related specifically to db tier then: apply the patches to the internal tier, run HRGLOBAL on the internal tier, and then apply the patches to the DMZ tier.

Typical Process Steps:

1. Review current version of  Note:145837.1 "Latest HRMS (HR Global) Legislative Data Patch available"
2. Go to the column for the current HRMS Family pack applied
3. Check the patch or patches listed for Global.  If not already installed, download and install the Global prerequisites
4. Go down the column and check patch or patches listed for each legislation that needs to be updated.
5. Verify if the legislative patch already been installed.  Download and apply any legislative prerequisite needed.
6. Execute DataInstall utility.  Select Global and any needed legislation for Install.
   
   1. Per Document:145837.1 If  a new Global patch was NOT installed,  no need to select Global legislation for Install action.
   2. Optionally, select Jit/Geocode for Install.  This is needed for Quarterly Jit updates, Annual Geocode updates and update of rates and limits used by US Payroll (401k annual limits for example).
7. Use adpatch to apply $PER_TOP/patch/115/driver/hrglobal.drv

In Summary:
· Multiple patches deliver legislative seed data files.
· DataInstall sets actions to be performed.
· Application of hrglobal.drv is when the actual database updates are done.