Query to get content_item_id for HDL

 select hci.name,
hci.content_item_code,
hci.content_item_id
from hrt_content_tp_valuesets_vl hctv,
hrt_content_items_vl hci
where hctv.value_set_name like 'Degrees'
and hctv.content_type_id = (select content_type_id from HRT_CONTENT_TYPES_TL CT where 1=1 and CONTENT_TYPE_NAME ='Degrees')
and hci.content_value_set_id = hctv.content_value_set_id
order by hci.content_item_code, hci.name

Talent Profile Item HDL

 When loading Talent Profile Data, first go thru doc id - Load Talent Profile Data For Persons Using HDL (Doc ID 2798626.1)

Use the queries to get relevant data for HDL from above DOC id.

Sample HDL 

METADATA|ProfileItem|ProfileCode|SourceSystemOwner|SourceSystemId|ContentTypeId|SectionId|DateFrom|ItemText2401|ItemText2409|ItemDate1|ItemDate2

MERGE|ProfileItem|PERS_1234|SSOWNER|1234_PREVEMP2|129|300000001994419|2021/11/22|MS Industries|Manager|2011/01/01|2011/01/01

METADATA|ProfileItem|ProfileItemId|ProfileId|ItemDate2

MERGE|ProfileItem|300000040539722|300000040539720|2017/12/31

METADATA|ProfileItem|ProfileItemId|ProfileId

DELETE|ProfileItem|300000056889089|300000044616273

Query to pull Legal Entity Registration Number

 SELECT XREG.registered_name,XJUR.name,XREG.REGISTRATION_NUMBER
     FROM XLE_JURISDICTIONS_TL XJUR , XLE_REGISTRATIONS XREG 
where 1=1
and XJUR.jurisdiction_id = XREG.jurisdiction_id
and XJUR.language='US'
and XJUR.name='Quebec Provincial Tax'--Jurisdiction Name, which you will find on Manage Legal Entity Registrations Page    
and XREG.source_table='XLE_ENTITY_PROFILES'
and XREG.registered_name='XYZ'--LE Name

Global Transfer HDL

METADATA|WorkRelationship|LegalEmployerName|PersonNumber|DateStart|WorkerType|ActualTerminationDate|EnterpriseSeniorityDate|LastWorkingDate|OnMilitaryServiceFlag|PrimaryFlag|GlobalTransferFlag|ActionCode|RehireRecommendationFlag

MERGE|WorkRelationship|AL Legal Employer Name|20000001|2021/12/01|E||2019/06/01||N|Y|Y|GLB_TRANSFER|Y

METADATA|WorkTerms|ActionCode|AssignmentStatusTypeCode|AssignmentNumber|AssignmentType|WorkerType|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|GradeCode|PeriodOfServiceId(SourceSystemId)|PersonNumber|DateStart|LegalEmployerName|BusinessUnitId|PersonTypeCode

MERGE|WorkTerms|GLB_TRANSFER|ACTIVE_PROCESS|ET20000001-1|ET|E|4712/12/31|Y|1|2021/12/01|Grad1||20000001|2021/12/01|AL Legal Employer Name|300000045830045|Regular

METADATA|Assignment|ActionCode|PersonNumber|EffectiveStartDate|EffectiveEndDate|AssignmentNumber|WorkTermsNumber|AssignmentType|EffectiveSequence|EffectiveLatestChange|BusinessUnitId|DateProbationEnd|WorkerCategory|AssignmentCategory|GradeCode|HourlySalariedCode|PositionCode|JobCode|LocationId|ManagerFlag|OrganizationId|DateStart|LegalEmployerName|PersonTypeCode|PrimaryAssignmentFlag|AssignmentStatusTypeCode|WorkerType

MERGE|Assignment|GLB_TRANSFER|20000001|2021/12/01|4712/12/31|E20000001-1|ET20000001-1|E|1|Y|300000045830045||Senior Management|Full-time Regular|Grad1|S|123134||300000002378027||300000001871927|2021/12/01|AL Legal Employer Name|Regular|Y|ACTIVE_PROCESS|E

Cancel Work Relationship HDL

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId|CancelWorkRelationshipFlag
DELETE|WorkRelationship|FUSION|300000012545898|300000012549658|Y
select hik.source_system_owner, hik.source_system_id, ppos.person_id
 from per_periods_of_service ppos, hrc_integration_key_map hik
 where ppos.period_of_service_id = hik.surrogate_id
  and ppos.person_id in (select person_id from per_all_people_f
where person_number = '12345678')

Process to be run to enable DFF fields for BI Reporting

Before running the process ensure the fields created as DFF segments is BI Enabled by selecting the BI Enabled checkbox while creating the Global segment.

Process Name - Import Oracle Fusion Data Extensions for Transactional Business Intelligence

When is Absence Plan required

 An absence plan is required if you need the absence to be integrated to payroll, there are some adjustments, or it needs to be sent across to third party.

An absence plan is not required if absence type just needs an approval from Manager and there is no further processing of the absence anywhere in the system.