May 9, 2012

Inventory Organizations
An inventory organization is a facility where you store and transact items. Before you can use Oracle Inventory, you must define one or more inventory organizations. Inventory organizations represent distinct entities in your enterprise and can be one of the following:
        A physical entity such as a manufacturing facility, warehouse, or distribution centre.
        A logical entity such as an item master organization, which you use to define items.
·         An inventory organization may have the following attributes: An inventory organization can have its own location, ledger, costing method, workday calendar, and items.
·         An inventory organization can share one or more of these characteristics with other organizations.

Inventory Organization Structure

An inventory organization, where you store and transact items can have one or more subinventories. Subinventories are unique physical or logical separations of material inventory, such as raw material inventory, finished goods inventory, or defective goods inventory. In Oracle Inventory, all material within an organization is held in a subinventory. You must define at least one subinventory for every organization. You can track item quantities by subinventory as well as restrict items to specific subinventories. The subinventories in an inventory organization may be made up of one or more locators. You use locators to identify physical areas where you store inventory items. You can track items by locator and restrict items to a specific locator. Locator control is optional in Oracle Inventory.

Sample Inventory Organization

        Receiving Subinventory
        Raw material subinventory
        Manufacturing subinventory
        Finished goods subinventory
        Inspection subinventory
        Defective goods subinventory
        Shipping Subinventory
Multi-Organization Structure

 

Multi-Organization structure enables you to model multiple business units in an enterprise
using a single installation of Oracle applications. In a multi-organization architecture you can
keep data secure and separate from each business unit.
The following are the benefits of multi-organization structure:
        You can use a single installation of any Oracle Applications product to support any number of business units, even if those business units use a different ledger.
        Secure access to data so users can access only relevant information.
        You can define a organizational model that best suits your business requirements.
        In Oracle Inventory, you can fulfil any sales order or purchase order regardless of them being booked from any Inventory organization. You can also determine if any intercompany invoicing needs to occur based on if the Sales Order or Purchase Order was booked in a different Operating Unit other than the one to which the Inventory organization is assigned.

Setting Up Locations

        Define information describing the physical locations of employees and organizations.
        Locations are shared between Oracle Inventory, Oracle Purchasing, and Oracle Human Resource Management Systems. Locations flagged as global locations are available to all business groups. You can associate each organization with only one location; however, you can associate more than one organization with the same location.
        Physical locations are defined in Oracle Human Resource Management Systems.

Defining Organizations

 

Classify the Organization

        Choose an organization classification to describe the general purpose of your organization.
        Examples of organization classifications are inventory organization, legal company, and HR organization.
        Choose inventory organization as your organization classification to use your organization for inventory management

Ledger

Tie each inventory organization to an operating unit. Each operating unit is associated to a legal entity and a primary ledger.

Inventory Parameters

Organization Features
You must enter organization information such as the organization code, and the item master organization. The system defaults this field to the current organization. You must change this for any organization that is not an item master organization. The item master organization should be the first inventory organization you create.
Note: The Manufacturing Partner Organization functionality is only available in Japan, Taiwan and Korea.
Products and Features
You can enable specific products on the Inventory Parameters tab. These include Oracle Warehouse Management, Oracle Process Execution, and Oracle Enterprise Asset Management. If you have Oracle Warehouse Management installed, then you can enable the Warehouse Control System.

Costing Parameters

Standard costing: A costing method where a predetermined standard cost is used for charging material, resource, overhead, period close, job close, and cost update transactions and valuing inventory. Any deviation in actual costs from the predetermined standard is recorded as a variance.
Average costing: A costing method which can be used to cost transactions in both inventory only and manufacturing (inventory and work in process) environments. As you perform transactions, the system uses the transaction price or cost and automatically recalculates the average unit cost of your items.
LIFO costing: Costing method where it is assumed that items that were received most recently are transacted first.
FIFO costing: Costing method where it is assumed that items that were received earliest are transacted first.

Revision, Lot, Serial, and License Plate Number (LPN) Parameters

You determine the starting revision for all items in the organization when you define your inventory organization. You can also choose to set lot control and serial control parameters at the organization level. Revision control is discussed in the Defining and Maintaining Items module. Lot control and serial control is discussed in the Lot and Serial Control module.
LPN Generation Options
If you have Oracle Warehouse Management installed, and you are working with a Warehouse Management enabled organization, you can define License Plate Number (LPN) Generating Options. LPNs must be unique across organizations. Setting the parameters on the Revision, Lot, Serial, and LPN tab enables the system to generate LPNs on demand, or through a concurrent request. As long as the number is unique, Oracle Warehouse Management also enables you to generate your own LPNs.

ATP, Pick, Item-Sourcing Parameters

This enables to
        Set the available to Promise (ATP) default rule for the organization
        Set the picking default for the organization
        Set the item sourcing default for the organization

Inter-organization Parameters

This enables to determine the parameters the organization uses when it transfer the material between organization.

Other Account Parameters

This enables to setup receiving information, profit and loss account information, and other additional account details.

Warehouse Management Parameters

This is specifically needed for the organization which implemented Oracle Warehouse Management System.
Read More

May 1, 2012

Oracle Inventory


Oracle Inventory treats many different types of things as inventory. Inventory can be:
        Finished goods that you sell to customers.
        Services that you sell to customers.
        Spare parts for maintenance.
        Raw materials for manufacturing processes.
        Inventory you purchase from a supplier on consignment.

Inventory Capabilities

        Define Part Numbers
        Define Organization Structures
        Track On-hand Inventories
        Plan material Replenishment
        Issue Material
        Forecast demand
        Reserve Material
        Maintain Inventory Accuracy

Receipt to Issue Lifecycle


Oracle Inventory uses the receipt to issue process to maintain its inventory. When goods come to the warehouse, receipt process captures the onhand in Inventory. After receiving the goods, it can be transferred within the organization or to other organizations too. Finally, we can issue the goods from the Inventory for any business.

Receiving Inventory

There are different ways of receiving materials into organizations

Oracle Purchasing

You can use Oracle Purchasing to receive material from outside of your organization. You can receive:
        Purchase order receipts
        Internal requisitions
        In-transit receipts
        Return material authorizations
        Unexpected receipts

Oracle Work in Process

You can use Oracle Work in Process to receive material from the manufacturing floor. You can receive:
        Component returns
        Negative component issues
        Assembly returns

Types of Inventory receipts:

·         Receipt and Deliver (Direct)
·         Receipt and then Deliver (Standard)
·         Inspection
·         Receipt
·         Inspection
·         Deliver

Transferring Inventory

Different applications can generate requests to transfer inventory.

Oracle Shipping Execution

You can use Oracle Shipping Execution to generate a transfer to move material from a storage area to a staging to for shipping.

Oracle Order Management

You can use Oracle Order Management to generate a transfer to move material from a storage area to a staging area for shipping.

Oracle Work in Process

You can use Oracle Work in Process to generate a transfer to acquire components for a project.

Oracle Inventory

You can use Oracle Inventory to:
        Transfer material between organizations
        Transfer material within an organization
        Replenish materials
        Request transfers

Issuing Inventory

You can use the following applications to issue material:

Oracle Order Management

Oracle Order Management can generate an inventory issue through:
        Sales orders
        Internal orders

Oracle Purchasing

Oracle Purchasing can generate an inventory issue for:
        Return to vendor materials

Oracle Work in Process

Oracle Work in Process can generate an inventory issue through:
        Component issues
        Assembly returns

Oracle Inventory

Oracle Inventory can issue stock through:
        User-defined material issues
        Inter-Organization Transfer
        Cycle count negative Issue
        Issue Requests

Integration of Oracle Inventory to Manufacturing Applications

Oracle Inventory interacts with the following applications:
        Oracle Cost Management receives cost information and transaction rates from Oracle Inventory. Oracle Inventory integrates to Oracle General Ledger via Oracle Cost Management
        Oracle Work in Process provides work in process (WIP) activity and available to promise (ATP) supply information to Oracle Inventory and receives item and on-hand quantity information from Oracle Inventory.
        Oracle Advanced Supply Chain Planning and Oracle Global Order Promising provide ATP supply information and receive on-hand quantity and forecast information from Oracle Inventory.
        Oracle Bill of Materials receives item information from Oracle Inventory.
        Oracle Engineering provides engineering item information and receives item information from Oracle Inventory.
        Oracle Order Management provides shipping, reservations, and demand information and receives item, ATP, and on-hand quantity information from Oracle Inventory.
        Oracle Purchasing provides receipt, delivery, ATP supply, and planning supply information and receives item requisition, and inter-organization shipment information from Oracle Inventory.

Integration of Oracle Inventory to Financial Applications

        Oracle General Ledger provides ledger and currency exchange rates and receiving accounting summary and detail information via Oracle Cost Management.
        Oracle Landed Cost Management (LCM) enables you to determine the real costs (such as insurance, transportation, handling, storage costs, container fees, and import or export charges) associated with acquiring items. Oracle Landed Cost Management calculates the actual landed costs after actual values are received from invoices. The variance between the actual landed cost and the estimated landed cost are passed to Oracle Cost Management which in turn updates the proper accounts and valuation. To use Oracle LCM in Oracle Inventory, you need to:
- Set up inventory organization options in the Organization Parameters – Inventory   Parameters window.
- Set up the inventory organizations to be used with Oracle Landed Cost Management and specify the landed cost management variance account for that organization.
        Oracle Payables receives Item information from Oracle Inventory.
        Oracle Receivables provides intercompany invoice information and receives item information from Oracle Inventory.
        Oracle Assets receives item information from Oracle Inventory
Read More
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