Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 13 Vote(s) - 2.46 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Inventory question
12-25-2015, 05:27 AM,
Inventory question
Hello Experts,

Please help me with the following

My Banking client has one Headoffice in Hyderabad and its branches(150+) are spread in rest of India. They are trying to implement Oracle R12 and got the license for most of the Finance modules(GL,AP,CM,AR,FA etc)
However they got license only for purchasing module. As per them, whatever they procure it will be consumed and they dont have a concept of inventory storing.

They want three distinct features to be defined in the system
Maeterial Code,Vendor Code and Location Code
How many inventory orgs is feasible for such business? Do we need to create 1 inventory org for each branch as they are asking specifically for location code?
or Can we have one inventory(head office) and rest all of the branches to be defined as subinventory(location name embedded in subinventory name)? Im bit confused here.

In addition to it, for purchase orders, the requirement is as follows
"PO will have one standard default page which will cover standard terms and conditions and same
will remain unchanged for all the PO’s. Another page should be for General Terms and Conditions which could be amendable"

Your guidance is required and is always valued

Thanks given by:
02-10-2016, 08:31 PM,
RE: Inventory question
the concept behind Organizations describe distinct entities in your company and may include separate manufacturing facilities, warehouses, distribution centers, and branch offices.

Two flavors of inventory organizations are found in Oracle Applications. They are defined the same, and both are assigned a Ledger (set of books), a legal entity organization, an operating unit organization, and a location. An item master organization is used for item number maintenance and validation.
This master organization serves as a data repository storing items and item attributes, master level categories and category sets, master level cross references, and numerous data defaults. On-hand balances, inventory movements, and other on-going inventory activities are not performed in an item master organization.

Generally, the master organization is used as the validation organization for Purchasing and Order Entry. It is recommended that a single item master organization be defined, even in multiple organization, multiple Ledgers environments.
Thanks given by:

Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle Inventory Transaction Worker error Harish Duleep 2 8,931 08-26-2014, 01:50 AM
Last Post:
Thumbs Down Fuel management in oracle Ebs inventory mouazir 0 2,299 04-06-2014, 12:15 AM
Last Post: mouazir
  Adding freight cost into inventory without LCM Lavender 1 2,392 11-12-2013, 08:19 PM
Last Post: Kashif Manzoor

Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!