Tuesday 9 January 2018

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’





8 comments:

  1. Thanks for sharing such a great article about Punchout CXML, it will help me in my work.
    Punchout CXML Catlog




    ReplyDelete
  2. Thanks for your information sir,good article it helps many students.for more details please visit our website.
    Oracle Fusion HCM Training in Hyderabad

    ReplyDelete

  3. Good to read article about open catalog interface Punchout.
    OCI Punchout




    ReplyDelete
  4. Nice Information.
    PunchOut cXML- Vurbis Interactive used punchout cxml protocol developed by Ariba which helps for online shopping and ordering between e-procurement systems.
    PunchOut cXML

    ReplyDelete
  5. Vurbis Interactive used punchout cxml protocol developed by Ariba which helps for online shopping and ordering between e-procurement systems.
    PunchOut cXML

    ReplyDelete