in Oracle R12, every Operating Unit has a Purchasing Org which is used to store many important set ups. A business scenario is that If you have multiple Operating Units in your system, each operating unit can have it’s own Purchasing Org. And this Org can have it’s own item master organization. This Item Master Organization is the inventory in which any item must be created first and then only it can be assigned to other inventory orgs of the Operating Unit. so question is how do you fetch the Purchasing Org of an operating unit at run time. Well, query is small but before that let me give you the navigation which will make your life easier.
So log in to EBS R12.. Go to Purchasing Super User –> Set Up –> Organization –>Financial Set Ups –> Provide the name of your Business Unit –>Press the button Find –> Go to the tab “Supplier- Purchasing” and here you have the purchasing org.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
And cutting the chase short, below is the query to find it:
Select p.organization_Code
From FINANCIALS_SYSTEM_PARAMS_ALL f,
hr_all_organization_units_tl h ,
mtl_parameters p
where f.org_id = h.organization_id
and h.language = USERENV(‘LANG’)
AND name = ‘<Your Operating Unit Name>’
AND p.organization_id = f.Inventory_organization_id;
Reference:
support.oracle.com
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.