Posts

Changing Legal Employer or Work Type Using Cancel Work Relationship

One of the most common challenges in Oracle Fusion HCM is correcting an employee's Legal Employer or Work Type after the worker has already been hired. Since these attributes are tied to the Work Relationship, Oracle does not provide a straightforward update mechanism to modify them directly. In such scenarios, the recommended approach is often: Cancel the existing Work Relationship. Recreate the worker with the correct values. Restore historical records that were removed during the cancellation process. This article explains a developer-centric approach using HDL, supported SQLs, and backup templates to safely perform the activity while maintaining the ability to restore records if required. Why Is Backup Important? When a Work Relationship is cancelled, Oracle removes multiple records associated with the worker, including: Work Relationships Assignments Work Terms Seniority Dates Salary Records Other emp...
Post a Comment
Read more

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: CTC structures Basic/HRA splits Derived salary calculations Pay Rate Definitions Element-entry based components 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: Different component types Auto-calculated components Pay rate definitions Element entry creation Derived salary logic 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 ...
Post a Comment
Read more