In this article, we will try to fetch the list of all HDL Business Objects and their child business objects.
We can find the list of all business objects from the View Business Objects screen under Data Exchange. And we can search for the required business object to view the child entities.
However if there is a need to extract all BO’s and their child BO’s then we can use the below SQL Query to get the information.
SQL Query to get list of all HDL Business Objects
select hdbo.bus_obj_top_discriminator, hdbo.bus_obj_file_discriminator,
NVL(hdbo.processing_order, (select processing_order from HRC_DL_BUSINESS_OBJECTS where business_object_id = parent_business_object_id)) processing_order,
fat.user_module_name,
initcap(substr(replace(BUSINESS_OBJECT_VO_FQ_NAME, 'oracle.apps.hcm.',''), 0, instr(replace(BUSINESS_OBJECT_VO_FQ_NAME, 'oracle.apps.hcm.',''), '.')-1)) module
from HRC_DL_BUSINESS_OBJECTS hdbo, Fnd_appl_taxonomy_vl fat
where hdbo.module_id = fat.module_id
order by hdbo.bus_obj_top_discriminator, hdbo.processing_order, hdbo.business_object_idSample output will look like:
It will also fetch the processing order of the files along with the module name.
If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.
