My Oracle Support Banner

Payroll Costing Using HDL (HCM Data Loader) (Doc ID 2683792.1)

Last updated on JUNE 17, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Payroll Cloud Service - Version 11.13.21.01.0 to 11.13.21.01.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Payroll Costing may be loaded using HDL (HCM Data Loader) at different levels of the application.  This note will list some of those levels with sample .dat files, screen shots and analysis sample sql to assist in loading using HDL.

Levels of payroll costing: (SourceType) are from the Common Lookup Type =ORA_PAY_COST_SOURCE_TYPE

 

Lookup Code  Meaning Description
ASG Assignment Option used to create the cost account for payroll assignment.
BA Balance adjustment Option used to create the cost account in balance adjustment process.
ORG Department Option used to create the cost account for department.
EL Element eligibility Option used to create the cost account for element eligibility.
EE Element entry Option used to create the cost account for element entry.
JOB Job Option used to create the cost account for job.
PM Payment method Option used to create the cost account for payment method.
PAY Payroll Option used to create the cost account for payroll.
AET Payroll assignment element Option used to create the cost account for payroll assignment element.
PREL Payroll relationship Option used to create the cost account for payroll relationship.
PRET Payroll relationship element Option used to create the cost account for payroll relationship element.
TERM Payroll terms Option used to create the cost account for payroll terms.
TET Payroll terms element Option used to create the cost account for payroll terms element.
POS Position Option used to create the cost account for position.
     

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Levels of payroll costing: (SourceType) are from the Common Lookup Type =ORA_PAY_COST_SOURCE_TYPE
Solution
 Payroll Level Costing (PAY)
 Sample Payroll costing level HDL files
 Navigation: Setup and Maintenance->Costing of Payrolls
 
 Costing of payrolls sql
 Element Level Costing (EL)
 Navigation: Setup and Maintenance-> Costing of Elements

 Costing of elements sql
 Element Entry Level Costing (EE)
 Sample Element Entry costing level HDL files
 Navigation: Person Management->Search Person->Click Name->Payroll-Element Entries->Click Element Entry Element Name->Costing tab
  Element Entry Level Costing sql
 Position Level Costing (POS)
 Sample Position costing level HDL files
 Navigation: Setup and Maintenance-> Costing of Positions
Search for position, click on position Name
 Position Level Costing sql
 Person Level Costing (PREL, PRET, ASG, AET)
 User Key Table CostAllocationId
 User Key Table CostAllocationAccountId
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.