R12

Purchasing Org of an Operating Unit in Oracle R12

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.

Purchasing Org Definition Navigation
Purchasing Org Definition Navigation

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...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

Purchasing Org
Purchasing Org is the Inventory Organization



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.

How useful was this post?

Click on a star to rate it!

Average rating 1 / 5. Vote count: 61

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?