Pages

Showing posts with label Oracle Inventory. Show all posts
Showing posts with label Oracle Inventory. Show all posts

14 May 2013

To Access Data from Multiple Operating Units from a Single Responsibility

Each user can access, process, and report on data only for the operating units assigned to the MO: Operating Unit or MO: Security Profile profile option

The MO: Operating Unit profile option only provides access to one operating unit.
The MO: Security Profile provides access to multiple operating units from a single responsibility

Note: If the MO: Security Profile is set, then the MO: Operating Unit profile is ignored.

Access to Operating Units:
Your responsibility determines which operating units you can access when you use Oracle Applications. If you want a responsibility to access only one operating unit, then
set the profile option called MO: Operating Unit. If you want a responsibility to access multiple operating units, then define a security profile with multiple operating units
assigned and assign it to the MO: Security Profile profile option. Additionally, if using the MO: Security Profile profile option, you can also set the MO: Default Operating Unit
profile option to specify a default operating unit that will default in transaction entry pages

It is correct to enable MO: Security Profile to have access to multiple operating units from a single responsibility

13 July 2011

Physical Inventory Counting Process

The Physical Inventory Count allows you to take a stock check on a specific
physical inventory. The system allows you to take a snapshot of the on-hand
figures at a point in time to allow the company to continue processing
transactions without those transaction affecting the results of the stock
take. Later when the stock take figures are entered the program compares the
count figures entered with these 'snapshot' values NOT the current on hand
figures. Adjustments are then entered, approved (if necessary) and posted


Transaction flow

1. Define Physical Inventory 

Allows a physical inventory to be defined and a snapshot of the qty on hand to be taken. The Approval Options
allows the following options:
a. Required for all adjustments - ALL adjustments entered need to be approved
(could be very time consuming!)
b. Not required for adjustments - adjustments do not need approval
c. Required for adjustments out of tolerance - adjustments out of the range of
the approval tolerances need to be approved (the norm!). The Approval
adjustments are also entered on this form and are in the form of quantity

07 July 2011

Oracle Inventory Organization Structure (Release 11i )

Oracle Applications uses multiple types of organizations to build the business
execution structure. At the top of the structure is the accounting set of books
SOB), defined in the General Ledger. Next, different types of organizations are
used to further define the organization structure and relationships. All
organizations are defined and updated with the Define Organization form.

Set of Books: A General Ledger SOB, linked to the inventory organization,
controls the financial accounting of inventory transactions. A SOB is made up
of a chart of accounts, a financial calendar, and a currency. The general
ledger secures transactions (journal entries, balances) by SOB.

Legal Entity. A legal entity organization defines the tax and fiscal reporting
level. The legal entity represents the legal company.

Operating Unit: An operating unit organization defines the Purchasing, Order
Entry, Accounts Payable and Accounts Receivable level of operation. An operating
unit may span multiple manufacturing facilities, distribution points and sales
offices, or it may be limited to a single site.

Inventory Organization: Two flavors of inventory organizations are found in
Oracle Applications. They are defined the same, and both are assigned a 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 sets of books environments.

In addition to the item master organization there are one or more non-master
inventory organizations. Like the item master inventory organization, the 

28 June 2011

Inventory To GL Reconciliation Step

In R12, the GL transfer is a two-step process. The first step is from Costing to SLA. The second step is from SLA to GL. Costing team is only responsible for the first step. We can provide some guideline to check the inventory material distributions have been accounted in SLA.  To confirm the integrity between SLA and GL, we need to go to a Financials referrals