Item Status Attributes
Status control describes whether certain status attributes have default values that appear when you assign a status code to an item, and whether status codes control those attribute values after the defaults are assigned to an item.
The status attributes are:
| 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. |
Inter-dependencies 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 Attribute Control determines whether you have centralized (Master level) or decentralized (Organization level) control of item attributes. Both status attributes and item status can be controlled at the item level or organization levels.
You can choose the status setting level of each status attribute in the Item Attribute Controls window. The status setting level determines whether you can update the value of each status attribute within an item status.
Sets Value: The status that you assign to the item loads a non updatable value into the status attribute. You can update the status attribute by changing the status that you assigned to your item.
Defaults Value: The status that you assign to the item loads a default value into the status attribute. You can update the status attribute as you define your item.
Not Used: The status that you assign to the item does not determine the value of the status attribute. You can enable or disable the status attribute as you define your item.
Status Setting Level Consideration: You have the flexibility to change individual status attribute settings. Using meaningful status codes gives you control over item usage.
Source for below Content:
In master item form, these attributes are segregated into following 14 tabs,
1. Main
2. Inventory
3. Order Entry
4. Bills of Material
5. Costing
6. Purchasing
7. Receiving
8. Physical Attributes
9. General Planning
10. MPS/MRP Planning
11. Lead Times
12. Work in Process
13. Invoicing
14. Service
Out of 14 tabs, we have discussed only about the main and order entry related attributes here.
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.
Ø his 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.
Comments
Post a Comment