Fusion HCM - Customizing the Global Payslip

1. Copy the Existing Pay slip Template & Sub Template from the Location : Human Capital Management -> Payroll -> Payment Distribution

2. Paste the Copied Payslip Template to the Custom Folder

3. Edit the Template according to your Requirement

4. Login to Application with implementation user and click Data Exchange in Navigator

5. Click ‘Manage HCM Extract Definitions’ link

6. In the search region enter ‘Payslip’ for the name, select ‘Archive Retrieval’ for the Type and select the Legislative Data Group (LDG) for which you want to create/customize the Payslip, and then click the Search button

7. Click on Payslip. The Edit Extract Definition page will open. Click Extract Delivery Options and click Add in Extract Delivery Options section.  Create a record for your custom Payslip

8. Add the Following Details :

·         Start date

·         End Date

·         Delivery Option Name (In example, name is ‘AH Online Payslip’)

·         Output Type

·         Report (Report was created in /Custom/Human Capital Management/Payroll/Payment Distribution folder and report name was AH_USOnlinePayslip, enter complete path as /Custom/Human Capital Management/Payroll/Payment Distribution/AH_USOnlinePayslip.xdo)

·         Output Name

·         Template (Name should match the layout name in the report created in BIP. It was created with name ‘AH_USOnlinePayslip’)

·         Delivery Type: - ‘Document of Records’

·         Bursting Node: - ‘/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/REL_ACTION_ID’

·         Overriding Delivery Mode: - ‘US Online Payslip’

9. In the ‘Additional Details’ region, add details similar to ‘Online Payslip’ Record that is already provided by oracle :

·         Date From :-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_PAYROLL/PAYROLL_PERIOD_START_DATE

·         Date To:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_PAYROLL/PAYROLL_PERIOD_END_DATE

·         Information Text1:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_EE_INFO/EMAIL_ADDRESS

·         Information Category:- GLB_PAYSLIP

·         Information Date1:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_PAYROLL/PAYROLL_PAYSLIP_VIEW_DATE

·         Information Number1:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_PAYROLL/PAYROLL_ID

·         Information Number2:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_PAYROLL/PAYROLL_PERIOD_NUMBER

·         Information Number3:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/NET_PAY

·         Information Number5:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_INFO/GLB_ARCH_CBID/GLB_PAY_ARCH_CBID_INFORMATION/PREPAYMENT_RELATIONSHIP_ACTION_ID

·         Information Number6:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_PR_INFO/GLB_ARCH_CBID/GLB_PAY_ARCH_CBID_INFORMATION/CALC_BREAKDOWN_ID

·         Document Name:- PAYSLIP

·         Issued Date:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/PAYMENT_DETAILS/PAYMENT_DATE

·         Key: - Calculation Breakdown Identifier

·         Locale: - en-US.  It can be different depending upon the language of the report

·         Person Id: -
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/GLB_ARCH_PR/GLB_PAY_ARCH_EE_INFO/PERSON_ID

·         Related Object Id: -
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/REL_ACTION_ID

·         Related Object Id Col: - PAYROLL_REL_ACTION_ID

·         Related Object Name: -  PAY_PAYROLL_REL_ACTIONS

·         System Document Type: -  GLB_PAYSLIP

10. In Additional Details (the section after Report categories), add an entry for the delivery option name for your report.  Here, the Delivery option name was given as ‘AH Online Payslip’