Flexfields in Oracle Inventory


Oracle Inventory provides the following flexfields:

1] Account Aliases

Flexfield Code: MDSP

Table: MTL_GENERIC_DISPOSITIONS

Unique ID Column: DISPOSITION_ID

Comment: This key flexfield supports only one structure.

2] Item Catalogs

Flexfield Code: MICG

Table: MTL_ITEM_CATALOG_GROUPS

Unique ID Column: ITEM_CATALOG_GROUP_ID

Comment: This key flexfield supports only one structure.

3] Item Categories

Flexfield Code: MCAT

Table: MTL_CATEGORIES

Unique ID Column: CATEGORY_ID

Comment: 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.

4] Sales Orders

Flexfield Code: MKTS

Table: MTL_SALES_ORDERS

Unique ID Column: SALES_ORDER_ID

Comment: The Sales Order Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Entry 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 Entry. You must set up the OE: 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 OE: Source Code profile option to ‘ORDER ENTRY’.)

5] Stock Locators

Flexfield Code: MTLL

Table: MTL_ITEM_LOCATIONS

Unique ID Column: INVENTORY_LOCATION_ID

Comment: 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.

6] System Items

Flexfield Code: MSTK

Table: MTL_SYSTEM_ITEMS

Unique ID Column: INVENTORY_ITEM_ID

Comment: 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.

Advertisements

One Response to Flexfields in Oracle Inventory

  1. Srinath says:

    Dibya,

    Nice summarization of flexfileds information of Inventory module. Helped me as a quick reference and as a ready reckon.

    – Srinath

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: