Have you checked our new Android App!!! Please download and learn oracle at ease

July 7, 2013

Interview Q&A -4: Basic Concepts of Organization

Bishnu Prasad Choudhury / / 2
Q. What is the difference between Operating Unit and Inventory Organization?
Operating Unit :- An Organization that uses  Oracle Cash management, Order management and Shipping Execution, Oracle Payables, Oracle Purchasing, and Oracle Receivables. It may be a sales Office, a division, or a dept. An operating unit is associated with a legal entity. Information is secured by operating unit for these applications. Each user sees information only for their operating unit. To run any of these applications, you choose a responsibility associated with an organization classified as an operating unit.
An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Examples, include (but are not limited to) manufacturing plants, warehouses, distribution centers, and sales offices. The following applications secure information by inventory organization: Oracle inventory, Bills of Material, Engineering, and Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.

Q. What is Set of Books?
A financial reporting entity that uses a particular chart of accounts, functional currency,
And accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.

Q. What is Item Validation Organization?
The organization that contains your master list of items. You define it by setting the OM: Item Validation Organization parameter. You must define all items and bills in your Item Validation Organization, but you also need to maintain your items and bills in separate organizations if you want to ship them from other warehouses.
OE_System_Parameters à master item organization à contains the item validation org

Q. Mention the table or views where Inventory Org, Items, Set of Books, GL Code Combinations, Operating Unit, Location, Customers, Vendors, and Invoices are stored in Apps.
          Inventory Org: - MTL_PARAMETERS/ORG_ORGANIZATION_DEFINITIONS
          Items: - MTL_SYSTEM_ITEMS_B
          Set of Books: - GL_SETS_OF_BOOKS
          GL Code Combinations: - GL_CODE_COMBINATIONS
          Operating Unit: - HR_ALL_OPERATING_UNITS
          Location: - MTL_ITEM_LOCATIONS
          Customers: - RA_CUSTOMERS
          Vendors: - PO_VENDOR_CONTACTS
          Invoices: - AP_INVOICES_ALL

Q. What is the profile to be read to find out what Inventory Organization and Operating Unit are you on?
Help à Diagonistics à Examine à $PROFILES$(org_id is the Operating Unit)
                                                                    (organization_id is the Inventory Org)

Q. What is Inventory Master Organization?
Items are defined in an Inventory Master Organization

2 comments:

Help us to know you

Do you like learnoracle.in

Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here