Oracle Inventory provides the following flexfields:
Account Aliases
Item Catalogs
Item Categories
Sales Orders
Stock Locators
System Items
Depending on your system's setup, Inventory may also use some or all of the following flexfields provided by other Oracle products:
Accounting (Oracle General Ledger)
Sales Tax Location (Oracle Receivables)
Territory (Oracle Receivables)
Related Topics
Designing Your Accounting Flexfield, Oracle General Ledger User's Guide
Defining a Sales Tax Location Flexfield Structure, Oracle Receivables User's Guide
Territory Flexfield, Oracle Receivables User's Guide
| Owner | Oracle Inventory |
| Used by | Oracle Inventory |
| Flexfield Code | MDSP |
| Table Name | MTL_GENERIC_DISPOSITIONS |
| Number of Columns | 20 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | No |
| Unique ID Column | DISPOSITION_ID |
| Structure Column | ORGANIZATION_ID |
This key flexfield supports only one structure.
| Owner | Oracle Inventory |
| Used by | Oracle Inventory |
| Flexfield Code | MICG |
| Table Name | MTL_ITEM_CATALOG_GROUPS |
| Number of Columns | 15 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | No |
| Unique ID Column | ITEM_CATALOG_GROUP_ID |
| Structure Column | None |
This key flexfield supports only one structure.
| Owner | Oracle Inventory |
| Used by | Oracle Inventory, Oracle Order Entry |
| Flexfield Code | MCAT |
| Table Name | MTL_CATEGORIES |
| Number of Columns | 20 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | No |
| Unique ID Column | CATEGORY_ID |
| Structure Column | STRUCTURE_ID |
You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories.
You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme. You can then associate these structures with the categories and category sets you define.
| Owner | Oracle Inventory |
| Used by | Oracle Inventory, Oracle Order Entry |
| Flexfield Code | MKTS |
| Table Name | MTL_SALES_ORDERS |
| Number of Columns | 20 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | Yes |
| Unique ID Column | SALES_ORDER_ID |
| Structure Column | None |
The Sales Order Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Management interfaces to Oracle Inventory.
Your Sales Order Flexfield should be defined as Order Number, Order Type, and Order Source. This combination guarantees each transaction to Inventory is unique.
You must define this flexfield before placing demand or making reservations in Oracle Order Management.
You must set up the OM: Source Code profile option to determine the source code you will use in for the third segment of this flexfield to guarantee that each transaction is unique. (Oracle Inventory defaults the value of the OM: Source Code profile option to 'ORDER MANAGEMENT'.)
For your value sets, you must use Dynamic Inserts. The Validation Type should be None. Value Required should be Yes to improve performance of concurrent programs. The value set must be alphanumeric. The value set maximum size must be 40.
You should set the Required field to Yes in the Validation Information region when enabling the flexfield segments. Setting this field to Yes, improves performance when updating existing demand or reservations by guaranteeing that Oracle Order Management always supplies a value.
Set Right-justify Zero-fill Numbers to No so sales order numbers are not padded with zeros.
Oracle Inventory defines a unique ID for each order in MTL_SALES_ORDERS based on this flexfield. The Inventory unique ID, as opposed to the Order Management unique ID, is used throughout Oracle Manufacturing applications.
| Owner | Oracle Inventory |
| Used by | Oracle Inventory, Oracle Order Entry |
| Flexfield Code | MTLL |
| Table Name | MTL_ITEM_LOCATIONS |
| Number of Columns | 20 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | Yes |
| Unique ID Column | INVENTORY_LOCATION_ID |
| Structure Column | ORGANIZATION_ID |
You can use the Stock Locators Flexfield to capture more information about stock locators in inventory. If you do not have Oracle Inventory installed, or none of your items have locator control, it is not necessary to set up this flexfield.
If you keep track of specific locators such as aisle, row, bin indicators for your items, you need to configure your Stock Locators Flexfield and implement locator control in your organization.
This key flexfield supports only one structure.
| Owner | Oracle Inventory |
| Used by | Oracle Inventory, Oracle Order Entry, Oracle Receivables, Oracle Payables |
| Flexfield Code | MSTK |
| Table Name | MTL_SYSTEM_ITEMS |
| Number of Columns | 20 |
| Width of Columns | 40 |
| Dynamic Inserts Possible | No |
| Unique ID Column | INVENTORY_ITEM_ID |
| Structure Column | ORGANIZATION_ID |
You can use the System Items Flexfield (also called the Item Flexfield) for recording and reporting your item information. You must design and configure your Item Flexfield before you can start defining items.
All Oracle Applications products that reference items share the Item Flexfield and support multiple-segment implementations. However, this flexfield supports only one structure.
You must set up your OE: Item Flexfield profile option to specify the Item Flexfield structure that you will use for your Oracle applications.
Users can also set up the OE: Item Flexfield Entry Method profile option to specify your preferred method of entry for this flexfield.
You can optionally use the item flexfield to default item information for invoice, debit memo, and credit memo lines or you can enter your own line information.