1.11.5 Copying HR Rate Codes from the HRDMO to the HRSYS Database
Oracle delivers the GP Rate Code Elements for Country Extensions in both the HRSYS and HRDMO databases. However, the HR Rate Codes that are referenced by these elements are only delivered in the HRDMO database. If you would like to copy the related HR Rate Code elements directly into your HRSYS database for the GP Country Extensions that you have licensed, you can do so by using the gpcerate_exp.dms and gpcerate_imp.dms scripts. These scripts have conditional export/import logic that is based on the Installation Indicators (as previously discussed) to only copy the referenced HR Rate Codes that are required for the GP Country Extensions that you have licensed.
After you install both the HRSYS and HRDMO databases, carry out these steps:
-
Use PeopleSoft Data Mover to run the gpcerate_exp.dms script, which you can find in your <PS_APP_HOME>\scripts directory, against your HRDMO database.
Note:
If you only want to copy HR Rate Codes for a subset of the PeopleSoft Country Extensions that you have licensed, you should modify the gpcerate_exp.dms script before running and comment out the export logic for the licensed PeopleSoft Country Extensions that you do not want to copy. By default, only those HR Rate Codes for your licensed PeopleSoft Country Extensions will be exported, based on your Installation Indicators.
-
Use PeopleSoft Data Mover in bootstrap mode to run the gpcerate_imp.dms script (in your <PS_APP_HOME>\scripts directory) against your HRSYS database (using the dat file that was just generated).
Note:
If you are running on DB2 z/OS, follow the instructions in the script gpcerate_imp.dms to alter it to work properly in your environment.