Oracle Inventory

Move orders

are formal requests to move material within (one subinventory to another) the same inventory organization.

There are three types:

Requisition Move Orders - Manually crearted. User may choose to print a pick slip for the material handler to know where to get the material from.

Source Types --> subinventory transfer and account transfer

Replenishment Move Orders - pre-approved move orders that are created automatically from Min-Max Planning, Replenishment Counting, Kanban replenishment.

Source Type --> Subinventory

Pickwave Move Orders -  used in Order Management. The Oracle Shipping Execution pick release process generates a Pick Wave Move Order to move the material from its source location to the Staging subinventory.

Backend Story:

SELECT header_id, h.* FROM apps.MTL_TXN_REQUEST_HEADERS h

WHERE Request_Number IN ('16788419', '16874441');

SELECT line_status, l.* FROM apps.MTL_TXN_REQUEST_LINES l
WHERE header_id IN (16788751, 16870925); -- 5 is Closed
Select *from apps.mfg_lookups
where lookup_type LIKE 'MTL_TXN_REQUEST%'; --_STATUS';
SELECT * FROM apps.MTL_TXN_SOURCE_TYPES;

 

Categories & Category Sets

http://gaininfo.net/oracle/categories.wmv

Item Categories in a KFF (Other KFFs in Inventory are Account Aliases, Item Catalogs, Sales Orders, Stock Locators, System Items)

Inventory (R) --> Setup:Flexfields:Key:Segments

Application --> Inventory      Flexfield Titile --> Item Categories

After creating/updating any FF, Freeze FF Definition and Compile (submits 'FF View Generator').

Segments are selected as per Reporting granularity. More the granularity, more the segments. However more segments means more maintenance.

The Category Structure will/should be applicable to ALL the inventory items and not just few.
.