Technical Foundation - Inventory

Technical Foundation Inventory David Woolbright DARC Corporation

Agenda • • • • • • •

Review - Reading an ERD Help->Examine-> Block: SYSTEM Field: LAST QUERY Overview - Oracle Inventory Inventory Organizations Setting up Items Inventory Transactions Inventory APIs – Descriptions and Supporting Tables

Reading an ERD

Utility Diagnostics

Overview • Oracle Inventory is one of Oracle’s enterprise applications products. Oracle Inventory enables companies to satisfy business needs such as these: • Modeling organization structures • Defining part numbers • Tracking perpetual inventory • Maintaining accurate on-hand balances • Planning material replenishments • Forecasting anticipated demand

Inventory Integration

Inventory Structure Set of Books Legal Entity Operating Unit Inventory Organization • Item Master • Item Validation

Inventory Structure Inventory Organization Subinventory Locator Location

Organization Form Define Organization Form

Inventory Parameters Define Inventory Parameters Form

Organization ERD

Item Definition Forms Define Master Items

Item Definition Forms Define Organization Items

Item Definition ERD MTL_SYSTEM_ITEMS_B

HR_ALL_ORGANIZATION_UNITS

MTL_ITEM_CATEGORIES

MTL_CATEGORIES_B

MTL_CATEGORY_SETS_B

Inventory Control Forms • Expected Receipts

Inventory Control Forms • Subinventory Transfer

Inventory Control Forms • Inter-Organization Transfer, I

Inventory Control Forms • Inter-Organization Transfer, II

Inventory Control Forms • Material Transaction Interface

Inventory Control ERD MTL_MATERIAL_TRANSACTIONS

MTL_ONHAND_QUANTITIES_DETAIL

MTL_TXN_SOURCE_TYPES

MTL_TRANSACTION_TYPES

Inventory APIs Open Item Interface You can import items from any source into Oracle Inventory and Oracle Engineering using the Item Interface. With this interface, you can convert inventory items from another inventory system, migrate assembly and component items from a legacy manufacturing system, convert purchased items from a custom purchasing system, and import new items from a Product Data Management package. The Item Interface validates your data, ensuring that your imported items contain the same item detail as items you enter manually in the Master Item window.

Inventory APIs Open Item Interface ERD

Inventory APIs Material Transactions Interface The Material Transactions Interface (MTI) allows you to easily load transactions into Oracle Inventory from external applications and feeder systems. MTI is a very flexible interface that is able to perform a wide variety of transactions within the Oracle Inventory module.

Inventory APIs Material Transactions Interface ERD

Questions and Answers