Item Attributes
Item attributes are the collection of information about an item.
Item Attribute Group:
• Main
• Inventory
• Bills of Material
• Costing
• Asset Management
• Purchasing
• Receiving
• Physical
• General Planning
• MPS/MRP
• Lead times
• Work In Process
• Order Management
• Invoicing
• Process Manufacturing
• Service
• Web Option
Basics of Item Attributes:
1. Item
attributes are fields in the item table used to store specific
characteristics of an item, such as item status, unit of measure,
revision control, etc...
2. Attributes can be controlled at either the master or the organization level.
3. An item has the same value for Attributes that are controlled at the Master level in all organizations in which it is defined.
4. You
can enter and update the values of Master-level attributes only by
using the Master Item window. Oracle Inventory reflects your changes in
all organizations that carry the item.
5. An
item may have different values for such Attributes that are controlled
at the Organization level in each organization in which it is defined.
6. You
can update the values of organization-level attributes only by using
the Organization Item window in each organization that carries the item.
7. These attributes are stored in a table named MTL_ITEM_ATTRIBUTES.
8. The
attributes that are available to the user depend on which Oracle
applications are installed. The table MTL_ATTR_APPL_DEPENDENCIES
maintains the relationships between items attributes and Oracle
applications.
9. Two units of measure columns are stored in MTL_SYSTEM_ITEMS table.
10. PRIMARY_UOM_CODE is the 3–character unit that is used throughout Oracle Manufacturing.
11. PRIMARY_UNIT_OF_MEASURE is the 25–character unit that is used throughout Oracle Purchasing.
Main Attributes
Primary Unit of Measure is the stocking and selling unit of measure
Tracking attribute controls how on-hand balances are tracked
Pricing attribute controls if pricing is based on the primary or secondary unit of measure
Secondary specify the Secondary unit of measure
User Item Type
• There are several default item types available by installation.
• We can define our own item types using Item Type Quick Codes window and choose them here.
Item Status:
• This
is the most important attribute as it sets or defaults attributes under
the status control Like BOM Allowed, Build in WIP, Customer Orders
Enabled, Internal Orders Enabled, Invoice Enabled, Transactable,
Purchasable, Stockable.
• The default item status for new items is defined using the INV:Default Item Status profile option
Order Entry:
Customer Orders:
• Indicate whether to allow an item to be ordered by external customers.
• You can add any customer orderable items to price lists in Order Management.
• This attribute must be turned off if the BOM Item Type attribute is set to Planning.
• If you turn this attribute on, you can temporarily exclude an item from being ordered by turning Customer Orders Enabled off.
• This is an item defining attribute.
• If
you turn this attribute on, the item is automatically assigned to the
default category set for the Order Management functional area.
Customer Orders Enabled:
• Indicate whether an item is currently customer orderable.
• If you turn this attribute on you can specify the item in the Enter Orders window in Order Management.
• You
can initially define an item with Customer Ordered Item turned on and
Customer Orders Enabled turned off. This means prices can be defined for
the item, but no orders can be placed for it. This attribute is
optionally set by the Item Status code.
Shippable:
• Indicate whether to ship an item to a customer.
• Shippable
items are released by Order Management's Pick Release program, creating
confirmable shipping lines, and are printed on the pick slip.
• A warning is issued if you change the value of this attribute when open sales order lines exist.
• For
an item to be shippable, it must also be an Inventory Item and
Stockable. Both of these attributes are listed on the Inventory Tab.
• This Shippable attribute must be turned off if the BOM Item Type attribute is set to Planning.
Internal Ordered:
• Indicate
whether to allow an item to be ordered on an internal requisition in
Purchasing. These items then are transferred onto an Internal Sales
Order in Order Management.
• If
you turn this attribute on, you can temporarily exclude an item from
being ordered on an internal requisition by turning Internal Orders
Enabled off.
• This
is an item defining attribute. If you turn this attribute on, the item
is automatically assigned to the default category set for the Oracle
Purchasing functional area.
Internal Orders Enabled:
• Indicate whether you can currently order an item internally.
• If
you turn Internal Ordered Item on, you can temporarily exclude an item
from being ordered on an internal requisition by turning this attribute
off.
• This attribute is optionally set by the Item Status code.
OE Transactable:
• Indicate
whether demand can be placed for an item by Order Management (OM), and
whether shipment transactions are interfaced to Inventory.
• Most items with Shippable turned on also have OM Transactable turned on.
• For items you do not ship, you may still want OM Transactable turned on if you use the items in forecasting or planning.
• If you also want to reserve the item, turn Reservable on.
• A warning is issued if you change the value of this attribute when open sales order lines exist.
• You cannot turn this attribute off if demand exits.
Default Shipping Organization:
• Enter the warehouse from which you typically ship this product.
• This
organization can default to the Enter Orders window if Item is the
source attribute of the Warehouse object in the standard value rule set
for the order.
• This organization defaults to the Enter Returns window if a receiving warehouse is not defined on the customer or order type.
Picking Rule
• Enter the picking rule that defines the order in which sub inventories, locators, lots, and revisions are picked.
Pick Components
• Indicate whether an item has a bill of material with options, classes, or included items picked from finished goods inventory.
• Pick-to-order items must have this attribute turned on.
• Assemble-to-order items and items without a bill of material must have this attribute turned off.
Assemble to Order
• Turn
this attribute on if an item is generally built for sales order demand;
a final assembly work order is created based on sales order details.
• An item cannot have Pick Components turned on and this attribute turned on at the same time.
Check ATP
• Select
Check Material Only, Check Material and Resources, Check Resources
Only, or None to indicate whether to check available to promise and/or
capable to promise information when placing demand.
• This attribute also determines whether you can view component ATP information for material requirements in Work in Process.
ATP Components
• Indicate
whether to include, in available to promise checking, additional
components in the bill of material for ATO and PTO items.
• These components are included in ATP checking if Check ATP for the component is turned on.
ATP Rule
• Enter
a user-defined available to promise rule. ATP rules define supply and
demand sources, time-fence parameters, and available-to-promise
calculation methods.
• You can give ATP rules meaningful names, such as ATO ATP Rule.
• If there is no ATP rule for the item, the organization's default ATP rule is used.
Ship Model Complete:
• Indicate
whether any configuration derived from this model can ship only when
all required quantities of all configuration components (options or
included items) are available.
• If
you turn this attribute on, the Pick Components attribute and the
profile option OE: Reservations must be Yes; the BOM Item Type attribute
can be Model or Standard.
Returnable:
• Indicate whether to allow customers to return an item.
• If an item is returnable, you can enter it on the Returns window in Order Management.
• Order
Management uses this attribute along with Stockable and Transactable to
determine which authorized returned items you can physically receive
into inventory.
RMA Inspection Required
• Indicate whether inspection is required for items returned by the customer.
• The item then must be separately transferred to inventory.
• Credits are never automatically generated by Order Management for customer return items awaiting inspection.
Over Shipment Tolerance
• The amount by which you want to allow shipments over the sales order quantity.
• This is expressed in terms of a percentage.
Under Shipment Tolerance
• The amount by which you want to allow shipments under the sales order quantity.
• This is expressed in terms of a percentage.
Over Return Tolerance
• The amount by which you want to allow returns over the sales order quantity.
• This is expressed in terms of a percentage.
Under Return Tolerance
• The amount by which you want to allow returns under the sales order quantity.
• This is expressed in terms of a percentage.
Financing Allowed
• Indicate whether a customer can finance this item.
Master Level vs. Organization Level
Item attributes are the collection
of information about an item. Using the Item Attribute Controls window,
you can designate whether an item attribute is defined/maintained at the
Master level or the Organization level. Attributes at the Master level
are the same across all organizations, giving you centralized control
over the values assigned. If an attribute is maintained at the
Organization level, you can have different values in each organization
the item is assigned to and therefore have decentralized control over
that attribute.
For example, you can define and
maintain an item's unit of measure at the Master level. This means that
the unit of measure is always the same for the item, no matter in which
organization you assign the item. Or, you can designate that an item's
unit of measure is maintained at the Organization level. This means that
each organization you assign the item to can have a different unit of
measure for the item.
Some
attributes can be maintained only at one of these levels. The following
table lists the attributes that require control at a specific level:
Control Level
| |
Base Model
|
Master
|
BOM Item Type
|
Master
|
Cost of Goods Sold Account
|
Organization
|
Cumulative Total Lead Time
|
Organization
|
Cumulative Manufacturing Lead Time
|
Organization
|
Encumbrance Account
|
Organization
|
Engineering Item
|
Master
|
Expense Account
|
Organization
|
Fixed Lead Time
|
Organization
|
Planner
|
Organization
|
Planning Exception Set
|
Organization
|
Postprocessing Lead Time
|
Organization
|
Preprocessing Lead Time
|
Organization
|
Processing Lead Time
|
Organization
|
Sales Account
|
Organization
|
Source Organization
|
Organization
|
Source Subinventory
|
Organization
|
Variable Lead Time
|
Organization
|
WIP Supply Locator
|
Organization
|
WIP Supply Subinventory
|
Organization
|
Item-Defining Attributes
An item-defining attribute
identifies the nature of an item. What designates an item as an
engineering item is the attribute Engineering Item, but what controls
the functionality of the item is the collection of attributes that
describe it. You can buy an engineering item if you want to; set
Engineering Item, Purchased, and Purchasable to Yes.
The following table presents item defining attributes:
Item-Defining Attributes
Functional Area
|
Item Defining Attribute
|
Oracle Inventory
|
Inventory Item
|
Oracle Purchasing
|
Purchased, or Internal Ordered Item
|
Oracle Master Scheduling/MRP and Oracle Supply Chain Planning
|
MRP Planning Method
|
Oracle Cost Management
|
Costing Enabled
|
Oracle Engineering
|
Engineering Item
|
Oracle Order Management
|
Customer Ordered Item
|
Oracle Service
|
Support Service, or Serviceable Product
|
When you set an item defining attribute to Yes the item is automatically assigned to the default category set of the corresponding functional area. For example, if you set Inventory Item to Yes the item is automatically assigned to the default category set for the Inventory functional area.
Status Attributes and Item Status Control
Status attributes enable and disable the functionality of an item over time. Each status attribute allows you to enable the item for a particular use. For example, if you set the status attribute Purchasable to Yes, you can put the item on a purchase order.The status attributes are related to the item defining attributes. You cannot enable a status attribute if you do not set the corresponding item defining attribute to Yes.
The following table presents status attributes:
Status Attributes
Status Attribute
|
Item Defining Attribute
|
Functional Area / Oracle Product
|
Functionality
|
Stockable
|
Inventory Item
|
Inventory
|
Enables you to store the item in an asset subinventory.
|
Transactable
|
Inventory Item
|
Inventory, Order Management, Purchasing, Work in Process
|
Enables you to transact the item in Oracle Inventory, Oracle Order Management, Oracle Purchasing and Oracle Work in Process.
|
Purchasable
|
Purchased
|
Purchasing
|
Enables you to place the item on a purchase order.
|
Build in WIP
|
NA
|
Work in Process
|
Enables you to build the item on a discrete job, a repetitive schedule, or both.
|
Customer Orders Enabled
|
Customer Ordered Item
|
Order Management
|
Enables you to place the item on a sales order.
|
Internal Orders Enabled
|
Internal Ordered Item
|
Inventory, Order Management, Purchasing
|
Enables you to create an internal sales order for the item
|
BOM Allowed
|
Inventory Item
|
Bills of Material
|
Enables you to create a bill of material for the item
|
Invoice enabled
|
Invoiceable Item
|
Receivables
|
Enables you to create an invoice for the item
|
Recipe Enabled
|
NA
|
Process Manufacturing
|
Enables you to create a recipe or formula for this item in process manufacturing.
|
Process Execution Enabled
|
Inventory Item
|
Process Manufacturing
|
Enables you to use the item in a production batch as an ingredient, product, or by-product.
|
You set status control for a status attribute with the Item Attributes Control window.
Interdependencies for Status Attributes
Each status attribute is dependent on the value of at least one other attribute. For example, you cannot set Stockable to Yes if you set Inventory Item to No. The following table presents interdependencies for the status attributes:
Interdependencies for Status Attributes
Attribute
|
Must be set to
|
If
|
Stockable
|
No
Yes |
Inventory Item is set to No
ASL is VMI enabled |
Transactable
|
No
Yes |
Stockable is set to No
ASL is VMI enabled |
Purchasable
|
No
|
Purchased is set to No
|
Build in WIP
|
No
|
Inventory Item is set to No OR BOM Item Type is NOT set to Standard
|
Customer Orders Enabled
|
No
|
Customer Ordered Item is set to No
|
Internal Orders Enabled
|
No
|
Internal Ordered Item is set to No
|
BOM Allowed
|
No
|
Inventory Item is set to No
|
Invoice Enabled
|
No
|
Invoiceable Item is set to No
|
Process Execution Enabled
|
No
|
Inventory Item or Recipe Enabled Flag is set to No
|
Item Status Control
When defining an item, you can use the item attribute Item Status to control status attribute values. You determine the list of values for the Item Status attribute by defining Item Status codes. An Item Status code has a user-defined set of Yes and No values for the status attributes. The values are applied to the status attributes when you choose an Item Status code when defining an item. For example, assume that you define an Item Status named Prototype with all status attributes set to Yes except for Customer Orders Enabled. Next, you define another item status, Active, with all status attributes set to Yes. In the beginning of a product development cycle, assign the status code Prototype to an item so that you cannot place the item on a sales order. Later, assign the status code Active to allow all functions for the item.Use pending statuses to automatically update an item's status on a specified date. For each item, specify a list of pending statuses and the corresponding effective dates
Relationships Between Attributes
When you define items, Oracle Inventory enforces particular relationships between some of the item attributes:
· Required attributes: You must enter a value for the attribute based on the settings for other related attributes.
· Interdependent attributes: You can enter only certain values depending on other attribute values.
· Updatable attributes: You can update values under certain conditions.
· Control
level dependencies: You can update the control level of some attributes
only under special conditions and with certain consequences.
Required Attribute Values
You must enter values for certain attributes if some related attributes have values as shown in the following table:
Attribute
|
If
|
Contract Coverage Template
|
Contract Item Type is set to Service or Warranty
|
Contract Duration
|
Contract Item Type is set to Service or Warranty
|
Contract Duration Period
|
Contract Item Type is set to Service or Warranty
|
Demand Time Fence Days
|
Demand Time Fence is set to User-defined
|
Encumbrance Account
|
Reverse Encumbrance parameter is set to Yes
|
Expense Account
|
Inventory Asset Value is set to No and Inventory Item is set to Yes
|
Outside Processing Unit Type
|
Outside Processing Item is set to Yes
|
Planning Time Fence Days
|
Demand Time Fence is set to User-defined
|
Planning Time Fence Days
|
Planning Time Fence is set to User-defined
|
Release Time Fence Days
|
Release Time Fence is set to User-defined
|
Repetitive Planning
|
MRP Planning Method is set to MPS planning or MRP planning
|
Service Duration
|
Service Duration Period is not null
|
Shelf Life Days
|
Lot Expiration (Shelf Life) Control is set to Item shelf life days
|
Source Organization
|
Replenishment Source Type is set to Inventory or Subinventory.
|
Starting Lot Number
|
Lot Control is set to Full lot control, and Lot Generation Organization Parameter is set to Item Level
|
Starting Lot Prefix
|
Lot Control is set to Full lot control and Lot Generation organization parameter is set to Item Level
|
Starting Serial Number
|
Serial Number Control is set to Predefined serial numbers
|
Starting Serial Prefix
|
Serial Number Control is set to Predefined serial numbers
|
Substitution Window Days
|
Substitution Window is set to User Defined
|
Interdependent Attributes
Certain attribute values depend on other attribute values. For example, Planning Method must be Not Planned if Pick Components is set to Yes. The attribute interdependencies are:
Interdependent Attributes
Attribute
|
Must be
|
If
|
Activity Source
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Assemble to Order
|
No
|
Pick Components is set to Yes or BOM Item Type is set to Planning
|
Assemble to Order or Pick Components
|
Yes
|
BOM Item Type is set to Model or Option Class
|
Asset Activity Cause
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Notification
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Shutdown Type
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Source
|
Null
|
Asset Item Type is set to anything other than Asset Activity
|
Asset Activity Type
|
Null
|
Asset Item Type is anything other than Asset Activity
|
AutoCreated Configuration
|
Null
|
Base Model is Null
|
Base Model
|
Null
|
BOM Item Type does not equal Standard or Pick Components is set to Yes
|
BOM Allowed
|
No
|
If organization process manufacturing enabled, and tracking is set to primary and secondary.
|
ATP Components
|
None
|
Pick Components is set to No, and Assemble to Order is set to No, and WIP Supply Type is set to anything other than Phantom
|
Billing Type
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Billing Type
|
Not Null
|
Enable Service Billing set to Yes
|
BOM Item Type
|
Standard
|
Effectivity Control is set to Model / Unit Number
|
BOM Item Type
|
Model
|
Configurator Model Type is set to container
|
BOM Model Type
|
No
|
If the organization is process manufacturing enabled, and tracking is set to primary and secondary.
|
Build in WIP
|
No
|
Inventory Item is set to No or BOM Item Type does not equal Standard
|
Check ATP
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Check Material Shortage
|
No
|
Transactable is set to No
|
Container Type
|
Null
|
Container is set to No
|
Contract Coverage Template
|
Null
|
Contract Item Type is set to No
|
Contract Duration
|
Null
|
Contract Item Type is set to No
|
Contract Duration Period
|
Null
|
Contract Item Type is set to No
|
Contract Item Type
|
Null or Subscription
|
Inventory Item is set to Yes
|
Contract Item Type
|
Subscription
|
Subscription Dependency enabled is set to Yes
|
Create Configured Item, BOM
|
Null
|
If the item is not an ATO model.
|
Create Fixed Asset
|
Yes
|
Track in Install Base is set to Yes
|
Costing Enabled
|
Yes
|
Inventory Asset is set to Yes
|
Customer Ordered
|
No
|
BOM Item Type is set to Planning or Product Family
|
Customer Ordered
|
No
|
Contract Item Type is Warranty
|
Customer Orders Enabled
|
Yes
|
Configurator Model Type is set to container
|
Customer Orders Enabled
|
No
|
Customer Ordered is set to No
|
Customer Orders Enabled
|
Yes
|
Customer Ordered is set to Yes
|
Cycle Count Enabled
|
No
|
Contract Item Type is set to anything other than Subscription
|
Defaulting
|
Fixed, Default, or No Default
|
Tracking is Set to Primary & Secondary
|
Defaulting
|
Default or No Default
|
Tracking is set to Primary and Pricing is set to Secondary
|
Default Lot Status
|
Null
|
Lot Status Enabled is set to No
|
Default Serial Status
|
Null
|
Serial Status Enabled is set to No
|
Default SO Source Type
|
Internal
|
Ship Model Complete is set to Yes
|
Demand Time Fence Days
|
null
|
Demand Time Fence is not User-defined
|
Deviation Factor +
|
Null
|
UOM Dual Control is set to No Control
|
Deviation Factor -
|
Null
|
UOM Dual Control is set to No Control
|
Effectivity Control
|
Model / Unit Number
|
Asset Item Type is Asset Group
|
Expense Account
|
Yes
|
Inventory Asset Value is No and Inventory Item is Yes
|
Grade
|
N
|
If Lot Control is null
|
Height
|
Null
|
Dimensions UOM is Null
|
Inspection Required
|
No
|
Receipt Routing is set to anything other than Inspection
|
Installed Base Trackable
|
Yes
|
Serviceable is set to shelf Yes and Contract Item Type is set to Null or Subscription
|
Instance Class
|
Null
|
Contract Item Type is set to anything other than Subscription
|
Instance Class
|
Null
|
Install Base Trackable is set to No
|
Internal Ordered
|
No
|
BOM Item Type does not equal Standard
|
Internal Orders Enabled
|
No
|
Internal Ordered is set to No
|
Internal Volume
|
Null
|
Container, Vehicle, or Weight UOM are set to Null.
|
Inventory Item
|
No
|
Contract Item Type is set to anything other than Null or Subscription
|
Inventory Item
|
Yes
|
Asset Item Type, Default Receiving Subinventory, Default Move Orders Subinventory, Default Shipping Subinventory are set to anything other than Null; or BOM Item Type is set to Product Family,
|
Invoice Enabled
|
No
|
Invoiceable Item is set to No
|
Lead Time Lot Size
|
1
|
Repetitive Planning is set to Yes
|
Length
|
Null
|
Dimensions UOM is Null
|
Lot Status Enabled
|
No
|
Lot Control is set to No Control
|
Lot Split Enabled
|
No
|
Lot Control is set to No Control
|
Lot Merge Enabled
|
No
|
Lot Control is set to No Control
|
Lot Substitution Enabled
|
No
|
Lot Control is set to No Control
|
Lot Translation Enabled
|
No
|
Lot Control is set to No Control
|
Match Configuration
|
Null
|
If the item is not an ATO model
|
Maximum Load Weight
|
Null
|
Container, Vehicle, or Weight UOM is set to Null
|
Minimum Fill Percentage
|
Null
|
Container and Vehicle are both set to No
|
Move Order Receipts Subinventory
|
Null
|
Transactable is set to No
|
Orderable On Web
|
No
|
Customer Orders Enabled is set to No
|
Outside Processing Item
|
N
|
If Purchased is set to No or if ASL has VMI.
|
Outside Processing Unit
|
Y
|
Outside Processing Item is Yes
|
Pick Components
|
No
|
Assemble to Order is set to Yes or BOM Item Type is set to Planning or Planning Method does not equal Not planned
|
Pick Components
|
Yes
|
Ship Model Complete is set to Yes
|
Planning Time Fence Days
|
null
|
Planning Time Fence is not User-defined
|
Planning Method
|
Not Planned
|
Pick Components is set to Yes
|
Postprocessing lead time
|
0 (Zero)
|
Make or Buy is set to Make
|
Purchasable
|
No
|
Purchasing Item is set to No or Contract Item Type is set to anything other than Subscription
|
Purchasable
|
Yes
|
Default SO Source Type is set to External
|
Purchasing Tax Code
|
Null
|
Taxable is set to Null
|
Recovered Part Disposition
|
Null
|
Billing Type is Labor
|
Release Time Fence Days
|
Null
|
Release Time Fence is not User-defined
|
Replenishment Point
|
Minimum Quantity
|
Either Maximum Quantity or Fixed Quantity Attributes isenabled.
|
Replenishment Point
|
Minimum Days of Supply
|
Either Maximum days of Supply of Fixed Quantity is enabled.
|
Restrict Locators
|
Locators not restricted to predefined list
|
Restrict Subinventories is set to Subinventories not restricted to predefined list or Stock Locator Control is set to Dynamic entry locator control
|
Restrict Subinventories
|
Subinventories restricted to predefined list
|
Restrict Locators is set to Locators restricted to predefined list
|
Returnable
|
No
|
Contract Item is set to anything other than Subscription
|
Safety Stock Method
|
Non-MRP Planned
|
MRP Planning Method is set to Not Planned
|
Secondary UOM
|
Null
|
UOM Dual Control is set to No Control, or Tracking and Pricing are both set to Primary
|
Serial Number Generation
|
At Receipt or Predefined
|
Equipment is set to Yes or Effectivity Control is set to Model / Unit Number
|
Serial Status Enabled
|
No
|
Serial Control is set to No Control
|
Service Request
|
Null. Disabled, or Inactive
|
Contract Item Type is Service, Warranty, or Usage
|
Service Importance Level
|
Null
|
Contract Item Type is set to Service
|
Serviceable Product
|
No
|
Support Service is set to Yes
|
Shippable
|
No
|
BOM Item Type is set to Planning or Contract Item Type is set to anything other than Subscription
|
Source Organization
|
Null
|
Inventory Planning Method is set to Vendor Managed
|
Source Type
|
Null
|
Inventory Planning Method is set to Vendor Managed
|
Stockable
|
No
|
Inventory Item is set to No
|
Stockable
|
No
|
Billing Type is Labor or Expense
|
Stockable
|
Yes
|
ASL is VMI
|
Stock Locator Control
|
No locator control or Pre- specified locator control
|
Restrict Locators is set to Locators restricted to predefined list
|
Support Service
|
No
|
Serviceable Product is set to Yes
|
Taxable
|
Yes
|
Tax Code is set to anything other than Null
|
Transactable
|
No
|
Stockable is set to No
|
Transactable
|
No
|
Billing Type is Labor or Expense
|
Transactable
|
Yes
|
ASL is VMI
|
Unit Volume
|
Null
|
Volume UOM is Null
|
Unit Weight
|
Null
|
Weight UOM is Null
|
Width
|
Null
|
Dimensions UOM is Null
|
WIP Overcompletion Tolerance Value
|
Null
|
Overcompletion Tolerance Type is set to Null
|
WIP Supply Locator
|
Null
|
On Organization Parameters window, Locator is set to None or Locator controls is Subinventory Level and Selected WIP Supply Subinventory has Locator Control as None
or Locator controls is Subinventory Level, Selected WIP Supply
Subinventory has Locator Control as Item Level, and Item Locator Control
is None.
|
WIP Supply Type
|
Phantom
|
BOM Item Type is set to Option Class
|
Updatable Attributes
You can change the values of some attributes in special cases. The following table shows updatable attributes and the conditions under which you can change their values:Updatable Attributes
Attribute
|
Updatable
|
If
|
Asset Item Type
|
yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|
ATP Components
|
from No to Yes
|
Assemble to Order equals Yes or Pick Components equals Yes or WIP Supply Type equals Phantom
|
BOM Item Type
|
No
|
Bill of Material exists or Exists as a component of a BOM or Exists as a substitute component of a standard BOM. Exception: Can change from Product Family for components and substitute components.
|
Costing Enabled
|
Yes
|
No on-hand quantity exists
|
Demand Time Fence Days
|
Yes
|
Demand Time Fence equals User-defined time fence
|
Effectivity Control
|
No
|
If on-hand quantity is greater than 0 or a BOM exists for the item.
|
Inventory Asset Value
|
Yes
|
No on-hand quantity exists
|
Locator Control
|
Yes
|
No on-hand quantity exists
|
Lot Control
|
Yes
|
No on-hand quantity exists
|
OM Indivisible
|
With a warning
|
OM Indivisible is set to No
|
OE Transactable
|
from Yes to No
|
No demand exists
|
Outside Processing Item
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag unchecked.
|
Outside Processing Unit
|
Yes
|
Purchasing Item equals Yes
|
Planning Time Fence Days
|
Yes
|
Planning Time Fence equals User-defined time fence
|
Release Time Fence Days
|
Yes
|
Release Time Fence equals User-defined time fence
|
Reservable
|
Yes
|
No reservations exist for the item
|
Repetitive Planning
|
Yes
|
Not scheduled by MRP
|
Reservation Control
|
Yes
|
No demand exists
|
Revision Control
|
Yes
|
No on-hand quantity exists
|
Serial Number Control
|
Yes
|
No on-hand quantity exists
|
Shelf Life Control
|
Yes
|
No on-hand quantity exists
|
Shippable
|
With a warning
|
If open sales order line exists with a value different from the new value
|
Stockable
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|
Transactable
|
Yes
|
Approved Supplier list does not have the VMI flag enabled or the Consigned Inventory flag deselected.
|
the loan company that grants me loan of 5,000,000.00 USD When other loan investors has neglect my offer but mr benjamin lee granted me success loan.they are into directly in loan financing and project in terms of investment. they provide financing solutions to companies and individuals seeking access to capital markets funds, they can helped you fund your project or expand your business.. Email Contact:::: Also 247officedept@gmail.com or Write on whatsapp Number on +1-(989-394-3740)
ReplyDeleteThanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Procurement. Actually, I was looking for the same information on internet for Oracle Fusion HCM and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
ReplyDelete