DevOps, CI/CD and Automation

Hi Oracle Experts,

I am building a report and need to get Business Unit name in the output report but there are no Key Fields in the BU table to join with. Can you please tell me what are the key fields which can be joined?

I am using the below SQL to get the BU names:

select ORG.* from HR_ORG_UNIT_CLASSIFICATIONS_X CLS, HR_ALL_ORGANIZATION_UNITS_F_VL ORG

where CLS.ORGANIZATION_ID = ORG.ORGANIZATION_ID

and CLS.classification_code = 'FUN_BUSINESS_UNIT'

The Organization_ID filed are not KEY field with other tables, can anyone guide me ?

Thanks,

Shivam