Load Salaries with Pay Rate Components in Oracle HCM HDL

Loading salary data in Oracle HCM using HDL is usually quite simple — until Salary Components enter the picture 😄

If your organization uses:

then salary loading becomes a little more interesting.

In this post, we’ll look at how to load salaries using Salary Pay Rate Components in HDL.

🚀 The Challenge

A simple salary load only requires the:

Salary

business object.

But when salary components are involved, we need to handle:

That’s where many migrations become tricky.

📦 Objects Required

To load salary with pay rate components, we need 2 HDL objects:

Object	Purpose
Salary	Creates the salary record
SalaryPayRateComponent	Creates individual salary component lines

🧾 1. Salary Object

The Salary object is loaded normally, but two attributes become very important:

Attribute	Value	Why It Matters
MultipleComponents	Y	Indicates the salary has multiple components
ComputeSalaryRates	Y	Enables Oracle to calculate derived components automatically

⚡ Why ComputeSalaryRates = Y is Powerful

This attribute can save a lot of manual effort.

If:

then you only need to pass the editable component amount.

Oracle automatically:
✅ Calculates remaining components
✅ Applies salary formulas
✅ Creates element entries (if applicable)

Very useful during bulk migrations.

🧩 2. SalaryPayRateComponent Object

This object represents the actual component lines.

👉 One component = One line

So if you have:

then each component gets its own SalaryPayRateComponent record.

🔑 Important Attributes

Attribute	Description
RateAmount	Amount for the component
RateDefinitionCode	Pay Rate Definition short code

📄 Sample HDL

MERGE|Salary|ASG123|2026/01/01||120000|Monthly Salary Basis|Y|Y|ASG_CHANGE|HDL|SALARY123

MERGE|SalaryPayRateComponent|ASG123|SALARY123|2026/01/01||120000|CTC|CTC123|HDL

FusionAlchemist