HOW TO APPLY HRMS PATCH IN APPS 11i/R12:
==============================
Instruction for applying HRMS Legislative Data (hrglobal.drv)
hrglobal files (including the driver) are now being included into the 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. The following guide should ease the process of applying
this data. Please follow these steps to install your legislative seed data. Change history detailing which pre-req has been
changed and a link to the relevant bug detailing any updates/fixes is provided towards the the end of the document.
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. The following guide should ease the process of applying
this data. Please follow these steps to install your legislative seed data. Change history detailing which pre-req has been
changed and a link to the relevant bug detailing any updates/fixes is provided towards the the end of the document.
Please ensure to have consulted My Oracle Support Note 135266.1 prior to continuing with the steps in this Note so that
all other legislative patches have been applied prior to actioning the hrglobal specific prereqs mentioned in this Note.
all other legislative patches have been applied prior to actioning the hrglobal specific prereqs mentioned in this Note.
General information regarding HRMS patching process can be found in My Oracle Support Note 130369.1
Overview - Apply the set of patches listed against your patchset level for first Global then all intended legislations - then run
DataInstall - then run hrglobal.drv. The driver is no longer delivered in a generic hrglobal patch as in the past but is now
delivered in at least one of the legislative pre-reqs you will have installed in Step 2.
DataInstall - then run hrglobal.drv. The driver is no longer delivered in a generic hrglobal patch as in the past but is now
delivered in at least one of the legislative pre-reqs you will have installed in Step 2.
Step 1 - Infrastructure patch installation
Ensure you have the following infrastructure pre-reqs installed and you are a FULL Legislative HRMS customer:
Note: If you are on R12.2 and above, then please consult My Oracle Support Note 1469456.1
Note: If you are on R12.2 and above, then please consult My Oracle Support Note 1469456.1
For R11i:
· Oracle HR (PER) product installation status: Full
· Oracle Applications Release 11.5.10 (3140000 - Nov 2004) or later.
· Mini-pack AD.H (2673262) or later (details of the latest AD minipack can be found on
My Oracle Support Note 135266.1)
My Oracle Support Note 135266.1)
For R12.0:
· Oracle HR (PER) product installation status: Full
· Release 12.0.6 or later
For R12.1:
· Oracle HR (PER) product installation status: Full
Step 2 - PreReq Installation
In the master pre-req table below, ensure the patches listed in the Global row for the patchset level you are on have
been applied. This is very important.
been applied. This is very important.
For each legislation you intend to install, apply those pre-reqs listed in the intersection of the legislation row and relevant patchset
level column. Also note to check your installation matches the requirements specified in these individual patches; for instance a HR
only installation would only look to install those patches that do not require Payroll to be installed.
level column. Also note to check your installation matches the requirements specified in these individual patches; for instance a HR
only installation would only look to install those patches that do not require Payroll to be installed.
If you have been directed to this page from the instruction in a legislative patch readme then installing the Global pre-req patches
after the legislative patch(es) is fine - the only requirement is all pre-reqs are installed prior to moving to Step 3 below.
after the legislative patch(es) is fine - the only requirement is all pre-reqs are installed prior to moving to Step 3 below.
A key at the end of the table describes meanings of non patch number values. The hyperlinks in the table will direct you to the
ARULink download page for the Generic platform version of that patch. Other available platform downloads for the patch can
be selected in the drop-down menu you will see on the ARULink page.
ARULink download page for the Generic platform version of that patch. Other available platform downloads for the patch can
be selected in the drop-down menu you will see on the ARULink page.
To check if you have already installed a particular patch, you can use the following SQL statement run under the APPS user:
SQL> select 'installed' from ad_bugs where bug_number = 'patch_number';
Step 3 - Run DataInstall
The command line DataInstall java utility should be run on the tier which has the $APPL_TOP available.
It will perform view creation actions against the database tier pertaining to the options selected.
For multi-node/RAC setups, DataInstall need only to be run on the primary node.
It will perform view creation actions against the database tier pertaining to the options selected.
For multi-node/RAC setups, DataInstall need only to be run on the primary node.
Run the DataInstall java utility in order to select the legislations you want to apply as follows:
java oracle.apps.per.DataInstall <un> <pw> thin <host:port: sid >
where
< un > is the username of the main apps account
<pw> is the password for this account
<host:port: sid > represents the database connection information
For example: java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb
<pw> is the password for this account
<host:port: sid > represents the database connection information
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
Please note the following regarding the Global item selection in DataInstall menu 1:
· If you have had to install any patches from the Global row in Step 2 above (for instance a new Global patch has replaced
one you installed last time you applied hrglobal ), please select Global for Install.
one you installed last time you applied hrglobal ), please select Global for Install.
· If you have not had to install any patches from the Global row in Step 2 above as either they have already been applied
previously or the field is blank, and you have not upgraded to a newer RUP, you do not need to select Global for Install.
previously or the field is blank, and you have not upgraded to a newer RUP, you do not need to select Global for Install.
RUP Upgrade best practices
· On upgrade to a newer RUP, it is advised to apply all live localisations and Global/Core (even if no new prereqs are listed).
For customers running non supported localisations , they should install just Global/Core on RUP upgrade
For customers running non supported localisations , they should install just Global/Core on RUP upgrade
In summary:
Global option does not need to be installed if ALL of the following apply:
Global option does not need to be installed if ALL of the following apply:
· You have already installed Global before and no new Global pre-reqs are listed since that installation
· You have not upgraded to a new RUP since last running the hrglobal driver
· You have not encountered any issue with a previous hrglobal application*
* If you experienced an error running hrglobal whilst only selecting localization options in DataInstall, please try reapplying the driver from the beginning
after having also selected the Global option in DataInstall. It has been noticed in the past that this can resolve such types of issues.
Usage of DataInstall is fairly straightforward, basically select/deselect legislations to install using the index number of the
legislation shown in the list in menu 1 followed by I for install or C for clear; e.g. In menu 1, to install Global choose 1I, to
cancel a selected operation, choose 1C etc. Menu 4 to choose to save your changes when you are OK with them. For further
information and help on usage and troubleshooting of this utility, please consult the following My Oracle Support Note 158275.1
after having also selected the Global option in DataInstall. It has been noticed in the past that this can resolve such types of issues.
Usage of DataInstall is fairly straightforward, basically select/deselect legislations to install using the index number of the
legislation shown in the list in menu 1 followed by I for install or C for clear; e.g. In menu 1, to install Global choose 1I, to
cancel a selected operation, choose 1C etc. Menu 4 to choose to save your changes when you are OK with them. For further
information and help on usage and troubleshooting of this utility, please consult the following My Oracle Support Note 158275.1
Step 4 - Apply hrglobal.drv
The driver is located at $PER_TOP/patch/115/driver/hrglobal.drv and should be run on the tier which has the $APPL_TOP available.
In most cases this will be the Apps tier.
hrglobal.drv is a pure "database, d type" driver so the actions in the driver apply only to the database tier.
As such, for RAC/multi-node setups, it is only required to run the hrglobal.drv on one node.
Be mindful to only run the driver located in the directory $PER_TOP/patch/115/driver
hrglobal.drv driver should be applied as per a normal patch using the adpatch utility.
In most cases this will be the Apps tier.
hrglobal.drv is a pure "database, d type" driver so the actions in the driver apply only to the database tier.
As such, for RAC/multi-node setups, it is only required to run the hrglobal.drv on one node.
Be mindful to only run the driver located in the directory $PER_TOP/patch/115/driver
hrglobal.drv driver should be applied as per a normal patch using the adpatch utility.
Once completed you have successfully installed your legislative HRMS data.
Optional (Step 5)
For customers using other languages than US and wishing to apply translated legislative seed data, please apply the relevant language specific
version of the consolidated translation patch after successfully completing the hrglobal.drv above. Instructions for applying this patch can be
found in the patch readme. For additional information please consult the notes indicated below for your relevant codeline .
version of the consolidated translation patch after successfully completing the hrglobal.drv above. Instructions for applying this patch can be
found in the patch readme. For additional information please consult the notes indicated below for your relevant codeline .
· For R11i: 16834458 Note JP NLS customers on 11i.HR_FP.K.RUP1 should additionally apply 16691430, JP NLS is unsupported for
earlier patchsets .
earlier patchsets .
· For R12.0: Please consult My Oracle Support note 414434.1 for actions required. You will have already completed steps 1-4 in that note
simply by arriving here. Complete Step 5 only if you have note done so previously. 16834502 is the hrglobal NLS translation
patch. Note 414434.1 is referring you to this note in Step 6, so you should action application of the NLS version of this patch for the
languages you require, followed by completing steps 7 and 8 as described in 414434.1
simply by arriving here. Complete Step 5 only if you have note done so previously. 16834502 is the hrglobal NLS translation
patch. Note 414434.1 is referring you to this note in Step 6, so you should action application of the NLS version of this patch for the
languages you require, followed by completing steps 7 and 8 as described in 414434.1
· For R12.1: Please consult My Oracle Support note 414434.1 for actions required. You will have already completed steps 1-4 in that note
simply by arriving here. Complete Step 5 only if you have note done so previously. 16834502 is the hrglobal NLS translation
patch. Note 414434.1 is referring you to this note in Step 6 so you should action application of the NLS version of this patch for the
languages you require, followed by completing steps 7 and 8 as described in 414434.1
simply by arriving here. Complete Step 5 only if you have note done so previously. 16834502 is the hrglobal NLS translation
patch. Note 414434.1 is referring you to this note in Step 6 so you should action application of the NLS version of this patch for the
languages you require, followed by completing steps 7 and 8 as described in 414434.1
No comments:
Post a Comment