1. Copy the Existing Pay slip
Template & Sub Template from the Location : Human Capital Management -> Payroll -> Payment Distribution
3. Edit the Template according to your Requirement
4. Login to Application with implementation user
and click Data Exchange in Navigator
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
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
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
Start date
·
End Date
End Date
·
Delivery Option Name (In example, name is ‘AH Online Payslip’)
Delivery Option Name (In example, name is ‘AH Online Payslip’)
·
Output Type
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)
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
Output Name
·
Template (Name should match the layout name in the report
created in BIP. It was created with name ‘AH_USOnlinePayslip’)
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’
Delivery Type: – ‘Document of Records’
·
Bursting Node: –
‘/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/REL_ACTION_ID’
Bursting Node: –
‘/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/REL_ACTION_ID’
·
Overriding Delivery Mode: – ‘US Online Payslip’
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 :
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 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
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 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 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 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 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 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 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 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
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
Document Name:- PAYSLIP
·
Issued Date:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/PAYMENT_DETAILS/PAYMENT_DATE
Issued Date:-
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/PAYMENT_DETAILS/PAYMENT_DATE
·
Key: – Calculation Breakdown Identifier
Key: – Calculation Breakdown Identifier
·
Locale: – en-US. It
can be different depending upon the language of the report
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
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: –
/DATA_DS/G_1/FILE_FRAGMENT/PAYSLIP/PAYMENT_RECORD/REL_ACTION_ID
·
Related Object Id Col: – PAYROLL_REL_ACTION_ID
Related Object Id Col: – PAYROLL_REL_ACTION_ID
·
Related Object Name: – PAY_PAYROLL_REL_ACTIONS
Related Object Name: – PAY_PAYROLL_REL_ACTIONS
·
System Document Type: – GLB_PAYSLIP
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’
categories), add an entry for the delivery option name for your report. Here, the Delivery option name was given as
‘AH Online Payslip’
Recent Posts