Oracle Cloud Blog

In this blog we are going to see how to create external bank account and map it to personal payments through HDL in Oracle Cloud HCM First and foremost the Bank Branch details of the External Bank Account should be available in Oracle Cloud. If Bank Branch details were not available, then first load the Bank Branch details through HDL or key in manually using "Manage Bank Branches" page. BankBranch HDL Sample: METADATA|BankBranch|CountryCode|BankName|BankBranchName|BankBranchNumber MERGE|BankBranch|US|BANK NAME|BANK NAME-1234567|1234567 Once Bank Branch is loaded successfully, load the external bank account using below sample HDL BankAccount HDL Sample: METADATA|ExternalBankAccount|AccountNumber|AccountType|AccountName|BankBranchName|BankName|CountryCode|CurrencyCode|BankBranchNumber MERGE|ExternalBankAccount|1234567|CHECKING|Checking 1|BANK NAME-1234567|BANK NAME|US|USD|1234567 METADATA|ExternalBankAccountOwner|PersonNumber|AccountNumber|AccountType|BankName...

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...

In this blog, we are going to see how to cancel the Work Relationship using HDL (HCM Data Loader) Please make sure you have taken the back up of all the necessary data before cancelling the Work Relationship To cancel the Work Relationship, we use HDL Source Key method. Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|FUSION|1234|WRK_1234|Legal_Employer|1234|2018/02/01|E|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 SourceSy...