Query to get the Business unit and Legal Entity in Oracle Cloud ERP
This query Gets all the active Business units and associated Legal entities in Oracle Cloud ERP. The query is shared below: SELECT ffbuv.bu_name BU_NAME ,xep.name LEGAL_ENTITY_NAME FROM fun_fin_business_units_v ffbuv ,xle_entity_profiles xep WHERE ffbuv.legal_entity_id=xep.legal_entity_id The Query can be directly pasted in Oracle cloud Report Data model to get the output.
Read More