Absence Manage Global Payroll Packages

Create/Export Rule Package

Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Elements > Manage Global Payroll Packages > Create/Export Rule Package

select GP_PKG_ID, DESCR, DESCRSHORT, GP_VERSION_IND, GPDBNAME, LANGUAGE_CD, PKG_CREATE_DTTM, PKG_SCRIPTS_DTTM, PKG_EXPORT_DTTM 

from ps_GP_PKG_DFN where gp_pkg_id like '%Pkg%';

select PIN_NUM, PIN_NM from ps_GP_PIN_NM_VW;

select GP_PKG_ID, PIN_NUM, PIN_CODE, COUNTRY, PIN_NM, PIN_TYPE, PIN_OWNER, GP_PKG_UPG_ACTION, PKG_LNG_OPTN, PIN_NUM_TGT, GP_PKG_NEW_PIN_FLG, GP_PKG_ELEM_CMP_ST, GP_PKG_FAIL_REASON, GP_PKG_UPG_OPTN, GP_PKG_ELEM_UPG_ST 

from ps_GP_PKG_ELEMENTS

where gp_pkg_id like '%Pkg%';

Create Non-Rule Package

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Elements  Manage Global Payroll Packages  Create Non-Rule Package

 

select GP_PKG_ID, DESCR, DESCRSHORT, GPDBNAME, PKG_CREATE_DTTM, PKG_EXPORT_DTTM, PKG_EXPORT_NR_DTTM, PKG_IMPORT_DTTM, PKG_COMPARE_DTTM, PKG_IMPORT_NR_DTTM, PKG_UPGRADE_DTTM, COMMENTS

from ps_GP_NR_PKG_DFN;

select GP_PKG_ID, RECNAME, FIELDNAME, FLD_FMT, GP_SQL_OPERATOR, DATE_VALUE, DECIMAL_VALUE, CHARACTER

from ps_GP_NR_PKG_DTL;

select GP_PKG_ID, RECNAME, RECNAME_EXPORT, WHERE_CLAUSE_OPTN, GRP_WHERE_CLS 

from ps_GP_NR_PKG_RECS;

Some examples

Absence Take Types

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Elements  Absence Elements  Absence Take Types

select * from ps_GP_ABS_TYPE where ABS_TYPE_OPTN in ('TFW','TRN');

select * from ps_GP_ABS_REASON where ABS_TYPE_OPTN in ('TFW','TRN');

 

Eligibility Groups

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Framework  Organizational  Eligibility Groups

 

Select * from ps_GP_ELIG_GRP where  ELIG_GRP like 'HDS%%';

Select * from ps_GP_ELIG_GRP_MBR where  ELIG_GRP like 'HDS%%';

 

Time Reporting Codes – TRC

Set Up HCM  Product Related  Time and Labor  Time Reporting  Time Reporting Codes – TRC

/EMPLOYEE/HRMS/c/DEFINE_TIME_AND_LABOR.TL_TRC_MAIN_PNLGRP.GBL

Select * from ps_TL_TRC_TBL where  TRC like 'HS%%';

Select * from ps_TL_ERNCD_TBL where  TRC like 'HS%%';

 

TRC Program

/EMPLOYEE/HRMS/c/DEFINE_TIME_AND_LABOR.TL_TRCPGM_PNLGRP.GBL

 

Select * from ps_TL_TRC_PGM_TBL where  TRC_PROGRAM like 'USRH%%' and effdt = '01-Oct-2020';

Select * from ps_TL_TRCPGELE_TBL where  TRC_PROGRAM like 'USRH%%' and effdt = '01-Oct-2020';

 

Absence Earns/Deductn Mapping

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Integration  Absence Earns/Deductn Mapping

/EMPLOYEE/HRMS/c/DEFINE_PAYROLL_RULES_(GBL).GP_ABS_ERN_DED_MAP.GBL

 

Select * from ps_GP_ABS_ERN_DED where ABS_PAY_SYSTEM_CD = 'PI' and effdt = '01-Oct-2020';

Select * from ps_GP_ABS_ERNDDMAP where ABS_PAY_SYSTEM_CD = 'PI' and effdt = '01-Oct-2020';

 

 

Country Take

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Absence Management  Country Take

/EMPLOYEE/HRMS/c/DEFINE_PAYROLL_RULES_(GBL).GP_ABS_BAL_SS_DEF.GBL

select * from ps_GP_ABS_SS where effdt = '01-Oct-2020' and country = 'USA'

and pin_take_num in (select pin_num from ps_gp_pin gp where gp.pin_num = pin_take_num and effdt = '01-Oct-2020'

and (pin_nm like 'ANF HDS%' or pin_nm like 'ANF HDCT%') );

SELECT USED_BY, COUNTRY, ABS_TYPE_OPTN, EFFDT, EFF_STATUS, DESCR, DESCRSHORT, REQUEST_IND 
FROM ps_GP_ABS_TYPE 
WHERE ABS_TYPE_OPTN in ('TFW','TRN');
SELECT USED_BY, COUNTRY, ABS_TYPE_OPTN, EFFDT, ABSENCE_REASON, DESCR, DESCRSHORT 
FROM ps_GP_ABS_REASON 
WHERE ABS_TYPE_OPTN in ('TFW','TRN');
SELECT ELIG_GRP, EFFDT, EFF_STATUS, DESCR, DESCRSHORT 
FROM ps_GP_ELIG_GRP 
WHERE ELIG_GRP like 'HDS%%';
SELECT ELIG_GRP, EFFDT, PIN_ELEM_GRP_NUM 
FROM ps_GP_ELIG_GRP_MBR 
WHERE ELIG_GRP like 'HDS%%';
SELECT TRC, EFFDT, EFF_STATUS, DESCR, DESCRSHORT, TRC_TYPE, UNIT_OF_MEASURE, CURRENCY_CD, SEND_TO_PAYROLL, MAX_QTY, MIN_QTY, FACTOR_MULT, FACTOR_RATE_ADJ, PER_INSTANCE, PER_INST_OVR_FLAG, RATE, RATE_OVR_FLAG, ADD_GROSS, DILUTE_LBDST_FLAG, HRS_REPRESENT_IND, SEND_TO_TCD, COMP_LEAV_IND, USED_COPY_FROM , TL_COPY_FROM , GP_ABSENCE_FLG, SYNCID, TRC_SUM_CATEGORY, TRC_PUB_FLG, TRC_FILTER, TL_APPR_PAY_ADHOC, TL_APPR_PAY_DEFN, TL_APPR_PAY_FLG, TL_APPR_PAY_GRP1, TL_APPR_PAY_GRP2, TL_APPR_PAY_PRCS, TL_APPR_RPT_ADHOC, TL_APPR_RPT_DEFN, TL_APPR_RPT_GRP1, TL_APPR_RPT_GRP2, TL_APPR_RPT_PRCS, TL_APRV_RPT_FLG, LASTUPDDTTM, COMMENTS 
FROM ps_TL_TRC_TBL 
WHERE TRC like 'HS%%';
SELECT TRC, EFFDT, PAY_SYSTEM, TL_ERNCD, TL_COPY_FROM , EFF_STATUS, TL_TAKECD, ERNCD 
FROM ps_TL_ERNCD_TBL 
WHERE TRC like 'HS%%';
SELECT TRC_PROGRAM, EFFDT, DESCR, DESCRSHORT 
FROM ps_TL_TRC_PGM_TBL 
WHERE TRC_PROGRAM like 'USRH%%' and effdt = '01-Oct-2020';
SELECT TRC_PROGRAM, EFFDT, TRC, TRC_ACCESS, ORDER_BY_SEQ 
FROM ps_TL_TRCPGELE_TBL 
WHERE TRC_PROGRAM like 'USRH%%' and effdt = '01-Oct-2020';
SELECT ABS_PAY_SYSTEM_CD, EFFDT, EFF_STATUS 
FROM ps_GP_ABS_ERN_DED 
WHERE ABS_PAY_SYSTEM_CD = 'PI' and effdt = '01-Oct-2020';
SELECT ABS_PAY_SYSTEM_CD, EFFDT, PIN_NUM, ENTRY_TYPE_TAKE, ERNCD, PI_FIELD_VALUE 
FROM ps_GP_ABS_ERNDDMAP 
WHERE ABS_PAY_SYSTEM_CD = 'PI' and effdt = '01-Oct-2020';
SELECT * 
FROM ps_GP_ABS_SS 
WHERE effdt = '01-Oct-2020' and country = 'USA'
and pin_take_num in (SELECT pin_num 
FROM ps_gp_pin gp 
WHERE gp.pin_num = pin_take_num and effdt = '01-Oct-2020' 
and (pin_nm like 'ANF HDS%' or pin_nm like 'ANF HDCT%') );

Apply Rule Package

Set Up HCM  Product Related  Global Payroll & Absence Mgmt  Elements  Manage Global Payroll Packages  Apply Rule Package

Instruction to import Rule and Non-Rule packages

Import Rule package:

1)      Run the clean-up script first in Target environment.

-- *************************************************************************

-- ATTENTION: This script will delete all 50,000,000+ pin numbers that      

--            exist on Element Definition tables.                           

--                                                                          

--            You should ONLY run this if you need to clean-up 50,000,000+  

--            pin numbers.      

--                                                                          

--            You should NOT run this if you are in the MIDDLE of applying  

--            a Rule Package (unless you want to back out what you have     

--            just imported). Do NOT run this script and then try to run    

--            a Package Compare or Upgrade (as you will have deleted the    

--            elements that the package is trying to compare/upgrade and    

--            this could also cause the original element definitions to be  

--            deleted).                                                     

-- ************************************************************************

SET LOG gp_cleanup.log;

DELETE FROM PS_GP_ABS_ENTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TAKE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TAKE_CFG WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TAKE_DAY WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TAKE_ELM WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TAKE_ENT WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ABS_TK_FCST WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ACCUMULATOR WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ACM_MBR WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ARRAY WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ARRAY_FLD WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ARRAY_KEY WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ARRAY_PRC WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_AUTOGEN_DFLT WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_BRACKET WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_BRACKET_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_COUNT WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_DATE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_DURATION WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_DUR_GNRN WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ELEM_GRP WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ELEM_GRP_MBR WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ELM_DFN_SOVR WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ERN_DED WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FC_IN WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FC_OUT WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FC_OUT_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FC_SEG WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FC_TBL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FORMULA WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FORMULA_CLUE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FORMULA_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_FORMULA_VAR WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_GCTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_GCTL_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_HIST_ELEM WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_HIST_RULE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PIN WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PIN_CMPNT WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PROCESS WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PROCESS_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PRORATION WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_RATE_CODE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_ROUND_RULE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_SECTION WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_SECTION_DTL WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_SYSTEM_PIN WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_VARIABLE WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_WA_ARRAY WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_WA_FLD WHERE PIN_NUM > 50000000;

DELETE FROM PS_GP_PIN_LANG WHERE PIN_NUM > 50000000;

UPDATE PS_GP_PKG_DFN SET PKG_IMPORT_DTTM = %DateTimeNull, PKG_COMPARE_DTTM = %DateTimeNull WHERE PKG_UPGRADE_DTTM IS NULL;

2)      Import the Rule package

Run the DMS script in Datamover and should load successfully without any error.

3)      Navigate to the below path in Target environment to Compare and Upgrade the rule package.

Main Menu -> Set Up HCM -> Product Related -> Global Payroll&Absence Mgmt -> Elements -> Manage Global Payroll Packages -> Apply Rule Package

As we have already run the script in Data mover, by default imported check box is tick marked as shown in above snip.

 

1)      On the same page check the Compare package, create compare report and select the appropriate compare report option as shown in below snip. Also provide the server path in script location and the click on process. Wait till the process get success.

1)      After successful compare report, please check the compare report from the View Log/Trace from the process monitor. If everything is fine please continue with the upgrade of rule package if not please check and correct from step one.

2)      Navigate to the Apply rule package page (the path given in step 3) and open the respective Rule package and the check the box for upgrade as shown in below diagram. And then click on process and wait till the package copy process went to success

 

Check for the package status

Import Non-Rule package:

1)      Run the import elements script first in target Datamover and make sure the script loaded completely.

Sample Export Script

SET OUTPUT pkg_elements.dat;

SET LOG pkg_elements_exp.log;

UPDATE PS_GP_NR_PKG_DFN SET PKG_EXPORT_DTTM=%CURRENTDATETIMEIN WHERE GP_PKG_ID='pkg';

EXPORT GP_NR_PKG_DFN WHERE GP_PKG_ID = 'pkg';

EXPORT GP_NR_PKG_RECS WHERE GP_PKG_ID = 'pkg';

EXPORT GP_NR_PKG_DTL WHERE GP_PKG_ID = 'pkg';

EXPORT GP_NR_PKG_ELMTS WHERE GP_PKG_ID = 'pkg';

Sample Import Script

SET INPUT pkg_elements.dat;

SET LOG pkg_elements_imp.log;

DELETE FROM PS_GP_NR_PKG_DFN WHERE GP_PKG_ID = 'pkg';

DELETE FROM PS_GP_NR_PKG_RECS WHERE GP_PKG_ID = 'pkg';

DELETE FROM PS_GP_NR_PKG_DTL WHERE GP_PKG_ID = 'pkg';

DELETE FROM PS_GP_NR_PKG_ELMTS WHERE GP_PKG_ID = 'pkg';

IMPORT PS_GP_NR_PKG_DFN;

IMPORT PS_GP_NR_PKG_RECS;

IMPORT PS_GP_NR_PKG_DTL;

IMPORT PS_GP_NR_PKG_ELMTS;

UPDATE PS_GP_NR_PKG_DFN SET PKG_IMPORT_DTTM=%CURRENTDATETIMEIN WHERE GP_PKG_ID='pkg';

UPDATE PS_GP_NR_PKG_DFN SET PKG_CREATE_DTTM = %DateTimeNull WHERE GP_PKG_ID='pkg';

UPDATE PS_GP_NR_PKG_DFN SET PKG_EXPORT_DTTM = %DateTimeNull WHERE GP_PKG_ID='pkg';

UPDATE PS_GP_NR_PKG_DFN SET PKG_EXPORT_NR_DTTM = %DateTimeNull WHERE GP_PKG_ID='pkg';

2)      Navigate to the below path to compare the non-rule package as we have already imported the script from Datamover(as given in above step).

Main Menu -> Set Up HCM -> Product Related -> Global Payroll&Absence Mgmt -> Elements -> Manage Global Payroll Packages -> Compare Non-Rule Package

 

Please select the appropriate Non-Rule package and go to the Package Elements tab as shown in below snip. Click on compare and should completed successfully, in case of any issue please check the error and correct it.

 

Check for the package status.

 

3)      Run Import script for Non-Rule Records in Datamover and make sure script loaded completely.

Sample Export Script

SET OUTPUT _records.dat;

SET LOG _records_exp.log;

UPDATE PS_GP_NR_PKG_DFN SET PKG_EXPORT_NR_DTTM=%CURRENTDATETIMEIN WHERE GP_PKG_ID='pkg';

EXPORT GP_ABS_NRP_EDVW  where  ABS_PAY_SYSTEM_CD='PI' and EFFDT=%datein('2019-06-01');

EXPORT GP_ABS_ERN_DED  where  ABS_PAY_SYSTEM_CD='PI' and EFFDT=%datein('2019-06-01');

EXPORT GP_ABS_NRP_FMVW  where  EFFDT=%datein('2019-06-01');

EXPORT GP_ABS_REASON  where  EFFDT=%datein('2019-06-01');

EXPORT GP_NRP_ASS_VW  where  COUNTRY='ESP' and EFFDT=%datein('2019-06-01');

EXPORT GP_ABS_CFNRP_VW  where  EFFDT=%datein('2019-06-01');

EXPORT GP_ABS_TYPE  where  EFFDT=%datein('2019-06-01');

EXPORT GP_ELIG_GRP  where  EFFDT=%datein('2019-06-01');

EXPORT GP_NRP_EGMBR_VW  where  EFFDT=%datein('2019-06-01');

EXPORT TL_ERNCD_TBL  where  EFFDT=%datein('2019-06-01');

EXPORT TL_TRCPGELE_TBL  where  EFFDT=%datein('2019-06-01') and TRC_PROGRAM like '%';

EXPORT TL_TRC_PGM_TBL  where  DESCR like '%' and EFFDT=%datein('2019-06-01');

4)      Upgrade Non-Rule Package: Navigate to the below path

5)      Main Menu -> Set Up HCM -> Product Related -> Global Payroll&Absence Mgmt -> Elements -> Manage Global Payroll Packages -> Upgrade Non-Rule Package

 

 

 

So, the over all steps followed as under for any non-rule based package import -

·       Run the Import element script in Datamover in target environment.

·       Compare the Non-rule package.

·       Import the Non-rule Records script in Datamover in target environment.

·       Upgrade the Non-rule package.