Total Pageviews

Sunday, August 8, 2021

Global Transfer - HDL

                                                 Global Transfer - HDL

Termination of existing work relationship within a legal entity and creation of a new work relationship with a new legal entity is called as Global Transfer.

To do Global Transfer we need below 3 METADATAs:

1. Work Relationship

2. Work Terms (In New work relationship)

3. Assignment  (In New work relationship)

We should include GlobalTransferFlag as Y and an action code from the EMPL_GLB_TRANSFER action type in the new work relationship.

Here we don’t need to include the old WorkRelationship for termination, it will automatically be terminated. The termination date of the existing work relationship is one day before the start date of the new work relationship.

Note: (Need to check the Data consistency)

1.      Active an employee can’t be with a non-primary Work relationship.

2.      We can’t do the Global Transfer on the primary work relationship if the employee has two active work relationships. (Need to make the primary work relationship non-primary before doing the global transfer)

Hire Records:

METADATA|Worker|PersonNumber|StartDate|EffectiveStartDate|DateOfBirth|ActionCode

MERGE|Worker|Employee1|2018/01/01|2018/01/01|1992/06/17|HIRE

METADATA|PersonName|PersonNumber|EffectiveStartDate|LegislationCode|NameType|FirstName|MiddleNames|LastName

MERGE|PersonName|Employee1|2018/01/01|US|GLOBAL|S|N|R

METADATA|WorkRelationship|PersonNumber|DateStart|PrimaryFlag|LegalEmployerName|WorkerType

MERGE|WorkRelationship|Employee1|2018/01/01|Y|Legal_employer|E

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode

MERGE|WorkTerms|ETEmployee1|Employee1|Legal_employer|2018/01/01|2018/01/01|1|Y|HIRE|Employee||E|Business_unit|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS

METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode

MERGE|Assignment|EEmployee1|ETEmployee1|Employee1|Legal_employer|2018/01/01|2018/01/01|1|Y|HIRE|Employee||Business_unit|E|EMP|assignment_name|E|ACTIVE_PROCESS

 

Global Transfer records:

METADATA|WorkRelationship|PersonNumber|DateStart|PrimaryFlag|LegalEmployerName|WorkerType|GlobalTransferFlag

MERGE|WorkRelationship|Employee1|2019/05/10|Y|New_Legal_Employer|E|Y

METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonTypeCode|JobCode|WorkerType|BusinessUnitShortCode|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode

MERGE|WorkTerms|ETEmployee1|Employee1|Legal_employer|2018/01/01|2019/05/10|1|Y|GLB_TRANSFER|Employee||E|Business_unit|EMP|Work_terms_Assign_name|ET|ACTIVE_PROCESS

METADATA|Assignment|AssignmentNumber|WorkTermsNumber|PersonNumber|LegalEmployerName|DateStart|EffectiveStartDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonTypeCode|JobCode|BusinessUnitShortCode|WorkerType|SystemPersonType|AssignmentName|AssignmentType|AssignmentStatusTypeCode

MERGE|Assignment|EEmployee1|ETEmployee1|Employee1|Legal_employer|2018/01/01|2019/05/10|1|Y|GLB_TRANSFER|Employee||Business_unit|E|EMP|assignment_name|E|ACTIVE_PROCESS

 

 

Sunday, August 1, 2021

HDL File for Compensatory plan Balances Load

                                        HDL File for Compensatory plan Balances Load

To load the Compensatory plan balances use the below HDL.

The accrual Type for compensatory plans: ORA_ANC_COMPTME_DL

HDL: (PersonAccrualDetail.dat)

METADATA|PersonAccrualDetail|PersonNumber|WorkTermsNumber|PlanName|ProcdDate|AccrualType|Value
MERGE|PersonAccrualDetail|2345|ET2345|PlanName|2020/05/08|ORA_ANC_COMPTME_DL|1





Thanks

Sainath  

 

Enable Advanced Edit in HCM Extracts- After 24A update

 Enable Advanced Edit in HCM Extracts- After 24A update After 24A update Oracle deprecated the advanced edit in HCM Extracts. To Enable the ...