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'.
Step 1) Data Installer, a java tool to select the legislations and modules you want to load. Your selection is stored within the Hr_legislation_installations table.
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
java oracle.apps.per.DataInstall
where
for example: java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb
Step
2) Run the global driver through adpatch, the standard tool to launch a
Apps patch. The global driver will mainly load data for the selection
made earlier.
$ java oracle.apps.per.DataInstall apps apps thin myprdhost:1521:orebiz
DataInstall version 115.37
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 1
$ java oracle.apps.per.DataInstall apps apps thin myprdhost:1521:orebiz
DataInstall version 115.37
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 1
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 1I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 9I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed Install
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 10I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed Install
9 United States Payroll Installed Install
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 2
# Localisation College Data? Action
-- -------------- ------------- -------------
1 United Kingdom
2 United States Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 2I
# Localisation College Data? Action
-- -------------- ------------- -------------
1 United Kingdom
2 United States Installed Install
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 3
Currently installed JIT/Geocode data
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode
2 Oracle Time and Labor (OTL) Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) : 1I
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 1I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 9I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed Install
9 United States Payroll Installed
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 10I
# Localisation Product(s) Leg. Data? Action
-- ------------------- ------------------------ ---------- -------------
1 Global Human Resources Installed Install
2 Australia Human Resources
3 Australia Payroll
4 United Arab Emirates Human Resources
5 United Arab Emirates Payroll
6 United Kingdom Human Resources
7 United Kingdom Payroll
8 United States Human Resources Installed Install
9 United States Payroll Installed Install
10 United States US Federal Human Resources
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 2
# Localisation College Data? Action
-- -------------- ------------- -------------
1 United Kingdom
2 United States Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) : 2I
# Localisation College Data? Action
-- -------------- ------------- -------------
1 United Kingdom
2 United States Installed Install
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 2I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 3
Currently installed JIT/Geocode data
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode
2 Oracle Time and Labor (OTL) Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) : 1I
Currently installed JIT/Geocode data
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode Install
2 Oracle Time and Labor (OTL) Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) : 2I
Currently installed JIT/Geocode data
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode Install
2 Oracle Time and Labor (OTL) Installed Install
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 4
DataInstall - Actions confirmation
Do you really wish to exit and save your changes?
[Y] - Yes, save then exit
[N] - No, don't save but exit
[Return] - To return to the DataInstall Main Menu
Enter your choice (for example Y) : Y
DataInstall - Actions summary
-----------------------------
The following actions will be performed:
Localisation Product(s) Leg. Data? Action
-------------------- ------------------------ ---------- -------------
Global Human Resources Installed Install
United States Human Resources Installed Install
United States Payroll Installed Install
Localisation College Data? Action
-------------- ------------- -------------
United Kingdom
United States Installed Install
Option Data? Action
------------------------------ ------------- -------------
JIT/Geocode Install
Oracle Time and Labor (OTL) Installed Install
To run the hrglobal.drv file, you need to cd to the directory "$PER_TOP/patch/115/driver", then run adpatch and when it asks for the patch driver file, specify "hrglobal.drv".
$ ll $PER_TOP/patch/115/driver/hr*drv
-rwxr-xr-x 1 applmgr dba 6615 Jun 27 2003 hrupgcom.drv
-rwxr-xr-x 1 applmgr dba 203096 Sep 25 00:30 hrglobal.drv
$
Patching HRMS module is just like patching any other application module. However, there are some more steps you need to consider (like running DataInstall and apply hrglobal.drv).
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode Install
2 Oracle Time and Labor (OTL) Installed
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) : 2I
Currently installed JIT/Geocode data
Patch Applied Date
----------------------------- ------------
JIT_Q2_2010 27-JUL-2010
JIT_Q1_2010 21-MAY-2010
JIT_Q4_2009 09-JAN-2010
GEOCODE_ANNUAL_2009 19-DEC-2009
JIT_Q3_2009 18-DEC-2009
JIT_Q1_2009 21-NOV-2009
GEOCODE_ANNUAL_2008 18-JAN-2009
JIT_Q4_2008 18-JAN-2009
GEOCODE_ANNUAL_2007 27-DEC-2008
GEOCODE_ANNUAL_2006 27-DEC-2008
JIT_Q3_2007 04-NOV-2007
JIT_Q1.1_2006 26-JUL-2007
GEOCODE_ANNUAL_2005 26-JUL-2007
# Option Data? Action
-- ------------------------------ ------------- -------------
1 JIT/Geocode Install
2 Oracle Time and Labor (OTL) Installed Install
- Change Action
where is [I : Install, C : Clear]
[Return] - To return to main menu.
Enter your choice (for example 1I) :
+-------------------------------------------------+
| DataInstall Main Menu |
+-------------------------------------------------+
1. Select legislative data to install/upgrade
2. Select college data to install/upgrade
3. Select JIT/Geocode or OTL to install/upgrade
4. Exit to confirmation menu
Enter your choice : 4
DataInstall - Actions confirmation
Do you really wish to exit and save your changes?
[Y] - Yes, save then exit
[N] - No, don't save but exit
[Return] - To return to the DataInstall Main Menu
Enter your choice (for example Y) : Y
DataInstall - Actions summary
-----------------------------
The following actions will be performed:
Localisation Product(s) Leg. Data? Action
-------------------- ------------------------ ---------- -------------
Global Human Resources Installed Install
United States Human Resources Installed Install
United States Payroll Installed Install
Localisation College Data? Action
-------------- ------------- -------------
United Kingdom
United States Installed Install
Option Data? Action
------------------------------ ------------- -------------
JIT/Geocode Install
Oracle Time and Labor (OTL) Installed Install
To run the hrglobal.drv file, you need to cd to the directory "$PER_TOP/patch/115/driver", then run adpatch and when it asks for the patch driver file, specify "hrglobal.drv".
$ ll $PER_TOP/patch/115/driver/hr*drv
-rwxr-xr-x 1 applmgr dba 6615 Jun 27 2003 hrupgcom.drv
-rwxr-xr-x 1 applmgr dba 203096 Sep 25 00:30 hrglobal.drv
$
Patching HRMS module is just like patching any other application module. However, there are some more steps you need to consider (like running DataInstall and apply hrglobal.drv).
~~~~ Cheers
No comments :
Post a Comment