Oracle Inventory Q&A

Introduction:

Herewith I have compiled some of the common questions around Oracle Inventory and answers

Questions and Answers:

1. What is item status? Name the related table.

INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INVSDOIS)like “easyapps”

Active

Inactive

Engineer

Obsolete

Phase-Out

Prototype

OPM

Lease

Production

Concept

Design

DEM_Status

Pending

2.Define steps of assigning items to an organization.