Organization & Organization Unit Classification

 https://docs.oracle.com/en/cloud/saas/human-resources/index.html

HCM Data Loading Business Objects 

https://docs.oracle.com/en/cloud/saas/human-resources/fahbo/index.html

The typical hierarchy, known as the Enterprise Structure, starts with the Enterprise at the top, followed by divisions, legal entities, business units, and departments

In Oracle Fusion, organizations are building blocks representing the enterprise structure (e.g., legal entities, business units, departments), while organization classifications define their purpose, functionality, and specific attributes within the application.

HDL File Structure:

• SetCode LOV's logic can be discussed with functional and need to be implemented accordingly 
• Organization and Organization Unit Classification file should be loaded via a single file - Organization.dat where Organization is Parent and Classification is child
• Organization - SourceSystemId ( Parent Key)
• Organization Unit Classification - SourceSystemId ( Parent Key) and OrganizationId(SourceSystemId) is foreign key 

Note - 

1. Source System Owner should be configured in Manage Common Lookups - HRC_SOURCE_SYSTEM_OWNER

2. Make sure Organization Name doesn't exist in the application. Otherwise you would get irrelevant error message which you would take lots of your time in debugging the issue 

You can find it under task - Manage Departments

Loaded Sales_RR as Sales was already existing in the application.

--SQL Query to get Organization details with Organization Classification      

SELECT hao.organization_id

    ,haot.NAME

    ,hao.internal_external_flag

    ,hao.type

    ,haoc.classification_code

    ,hao.effective_start_date

    ,hao.effective_end_date

    ,haot.LANGUAGE

FROM hr_all_organization_units_f    hao     --Table

    ,hr_organization_units_f_tl     haot    --Table

    ,hr_org_unit_classifications_x  haoc    --View

WHERE 1=1

AND hao.organization_id         = haot.organization_id

AND hao.organization_id         = haoc.organization_id

AND hao.organization_id         = haot.organization_id

AND hao.effective_start_date    = haot.effective_start_date 

AND Trunc(sysdate) BETWEEN hao.effective_start_date AND hao.effective_end_date

and haoc.classification_code = 'DEPARTMENT'

and haot.NAME = 'Sales_RR'

and haot.LANGUAGE = 'E'