Oracle Cloud Payroll: Managing Payroll Assignments and Timecard Required Flag Using HDL
Introduction
During Oracle Cloud Payroll implementations, assigning employees to the correct payroll is one of the foundational configuration activities.
In addition to payroll assignments, organizations often need to maintain payroll processing attributes such as the Timecard Required Flag, particularly when integrating with Oracle Time and Labor (OTL) or third-party timekeeping applications.
While both tasks can be performed through the Oracle Cloud user interface, Oracle provides standard HCM Data Loader (HDL) business objects that enable these activities to be completed efficiently in bulk.
In this article, we will look at two commonly used HDL business objects:
- AssignedPayroll – Assign an employee to a payroll definition.
- PayrollAssignmentDetails – Maintain payroll assignment attributes such as the Timecard Required Flag.
Using these HDL objects together provides a scalable approach for payroll implementations, data conversions, and ongoing payroll maintenance.
Step 1: Assign the Employee to a Payroll
The first step is assigning the employee to the appropriate payroll definition.
Oracle provides the AssignedPayroll HDL business object for this purpose.
Sample HDL
METADATA|AssignedPayroll|EffectiveStartDate|AssignmentNumber|PayrollDefinitionCode|LegislativeDataGroupName|
StartDate|TimecardRequiredFlag|OvertimePeriodCode|LastStandardProcessDate|FinalCloseDate MERGE|AssignedPayroll|2025/05/01|E100755|Active|US Legislative Data Group|2025/05/01|Y|||
This HDL:
- Assigns the employee to a payroll
- Creates the payroll relationship
- Can initialize payroll processing attributes during assignment
Typical implementation scenarios include:
- Initial employee conversion
- New hire conversions
- Payroll migration projects
- Organizational restructures
- Payroll reassignment
Step 2: Maintain Payroll Assignment Details
Once the payroll assignment exists, payroll-specific attributes can be updated independently using the PayrollAssignmentDetails HDL business object.
This is especially useful when the payroll assignment already exists but payroll processing settings need to change.
Sample HDL
METADATA|PayrollAssignmentDetails|LegislativeDataGroupName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|TimecardRequiredFlag|OvertimePeriodCode MERGE|PayrollAssignmentDetails|US Legislative Data Group|E100755|2025/05/01|4712/12/31|Y|
Unlike AssignedPayroll, this HDL does not assign the employee to a payroll.
Instead, it maintains payroll assignment attributes for an existing payroll assignment.
Understanding the Timecard Required Flag
One of the most commonly maintained attributes is:
TimecardRequiredFlag
Supported values:
| Value | Description |
|---|---|
| Y | Timecards are required before payroll processing |
| N | Timecards are not required |
The appropriate configuration depends on the organization’s payroll and timekeeping design.
Typical Business Scenarios
Oracle Time and Labor (OTL)
Organizations using Oracle Time and Labor typically configure:
TimecardRequiredFlag = Y
Since Oracle maintains employee timecards, payroll expects time entries to be available for payroll processing.
Third-Party Time Systems
Organizations using applications such as:
- UKG
- Kronos
- Workday Time
- ADP Workforce Manager
may maintain employee time externally.
Depending on the integration design, only overtime or payroll-relevant transactions may be interfaced into Oracle Payroll.
In these cases, organizations often configure:
TimecardRequiredFlag = N
This allows the external application to remain the system of record for time while Oracle Payroll processes only the required payroll transactions.
Worker Classification Changes
Organizations frequently update this flag when employees move between:
- Hourly Nonexempt
- Salaried Nonexempt
- Exempt
HDL allows these updates to be performed for large employee populations in a consistent and repeatable manner.
When Should Each HDL Be Used?
| Business Requirement | AssignedPayroll | PayrollAssignmentDetails |
|---|---|---|
| Assign employees to payroll | Yes | No |
| Change payroll assignment | Yes | No |
| Update Timecard Required Flag | Only if you want to set it consistently during payroll assignment | Yes |
| Update overtime period | Only if you want to set it consistently during payroll assignment | Yes |
| Ongoing payroll maintenance | No | Yes |
As a best practice:
- Use AssignedPayroll when creating or changing payroll assignments.
- Use PayrollAssignmentDetails for ongoing maintenance of payroll processing attributes.
Benefits of Using HDL
Using these HDL business objects provides several advantages:
- Supports mass employee updates
- Eliminates repetitive manual configuration
- Simplifies payroll data conversion
- Promotes consistent payroll configuration
- Can be repeated across Development, Test, and Production environments
- Useful for payroll implementations and reorganizations
Rollback Support
These objects don’t support rollback. You need to prepare
separate delete HDL if required.
Best Practices
When using these HDL objects:
- Ensure the employee assignment already exists.
- Verify the Payroll Definition belongs to the correct Legislative Data Group.
- Use effective dates that align with payroll processing periods.
- Configure the Timecard Required Flag based on your organization’s payroll and timekeeping strategy.
- Validate payroll assignments after loading using Oracle Payroll pages or OTBI reports.
- Test both Y and N scenarios before mass loading.
- Maintain a backup copy of the source HDL file and load results for audit purposes.
Final Thoughts
Oracle Cloud Payroll provides separate HDL business objects for assigning employees to payrolls and maintaining payroll processing attributes.
Understanding the distinction between AssignedPayroll and PayrollAssignmentDetails allows implementation teams to build cleaner, more maintainable payroll data conversion and support processes.
For new payroll assignments, AssignedPayroll establishes the payroll relationship.
For ongoing maintenance activities, such as updating the Timecard Required Flag or overtime processing settings, PayrollAssignmentDetails offers a straightforward and scalable solution.
Leveraging both HDL objects appropriately helps reduce manual effort, supports large-scale payroll maintenance, and ensures consistent payroll configuration across the enterprise.
