Skip to main content

Posts

Showing posts with the label terminate work relationship

Do you know how to Reverse Terminate Work Relationship using HDL in Oracle Cloud HCM?

In this blog, we are going to see how to Reverse Terminate Work Relationship In order to cancel a Terminated Work Relationship, we need to Reverse Terminate that Work Relationship first Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|ReverseTerminationFlag MERGE|WorkRelationship|FUSION|1234|WRK_1234|LegalEmployer|Y In the above template, we do not know the values of the source keys SourceSystemOwner SourceSystemId PersonId(SourceSystemId) Use below query to fetch the SourceSystemOwner Query: select source_system_owner from hrc_integration_key_map where surrogate_id = period_of_service_id  -- pass period_of_service_id corresponding to Work Relationship Use below query to fetch the SourceSystemId Query: select source_system_id from hrc_integration_key_map where surrogate_id = period_of_service_id  -- pass period_of_service_id corresponding to Wo...