Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, August 11, 2011

Oracle Item Attributes

Main Attributes



You can define and control items that you stock in inventory. Once defined, you assign items to organizations.
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. If you set the value to secondary, the system reprices the orders line at ship confirmation. Secondary specify the Secondary unit of measure.
Item types and item status are discussed previously.

Inventory Attributes


Inventory Item indicates whether to stock and transact this item in Oracle Inventory. Stockable indicates whether to stock this item in Inventory. You can set this attribute only when you turn on the Inventory Item option. Turning this option on enables you to set the Transactable item attribute. Transactable allows Inventory transactions. Revision Control decides whether to track inventory balances by revision. Reservable indicate whether you can create material reservations. If the Reservable attribute is checked, Oracle Order Management allows reservation of the item during order entry. If material hasn’t been reserved prior to pick release, pick release creates reservations for material when the pick wave move order is allocated. Check Material Shortages indicate whether the system will check this item for material shortages. Turn this option on to trigger a material shortage alert and shortage notification during transactions of this item. Lot Expiration control governs how long items in a given lot remain available. Shelf life days Specify a number of days for all lots of an item, beginning on the day you create the lot by receiving the item. You receive a warning message that the lot expires after the specified number of days.If Lot Control is Full control then oracle track inventory balances by lot number. You must specify a lot number for issues and receipts.Enter a starting prefix and starting number for lot numbers you define for this item.Cycle Count Enabled allows automatic cycle counting and creates adjustments automatically if the count is within error tolerance. Serial generation at inventory receipt create and assign serial numbers when you receive the item. At sales order issue option create and assign serial numbers when you ship the item against a sales order. Predefined option assign predefined serial numbers when you receive the item. Locator Control :
Dynamic entry - Define locators when you use them, either as
you receive or ship items.
No control - Locator control not established.
Prespecified - Define locators before you use them.
Restrict Subinventories indicate whether to restrict transactions of this item to or from a subinventory specified in a list you define with the Item/Subinventory Information window
Restrict Locators indicate whether to restrict transaction of this item to or from a locator specified in the list you define with the Item/Subinventory Information window.

BOM Attributes


BOM Allowed allows you to define a bill of material for an item, or to assign the item as a component on a bill.BOM Item Type :
Model - This item’s bill of material lists option classes and options available when you place an order for the model item.
Option Class - This item’s bill of material contains a list of related options. Option classes group like options together. Oracle Order Management does not allow ordering of classes outside a model.
Planning - This item’s bill of material contains a list of items and planning percentages. A planning item can represent a product family or demand
channel. Its bill of material facilitates master scheduling and/or material planning. The total component planning percentages on a planning bill can exceed 100%. Oracle Order Management does not allow ordering of
Planning bills.
Product Family - This item can be used as a product family for planning at an aggregate level.
Standard - include purchased items, subassemblies, or finished products.

Purchasing Attributes


Purchased indicate whether to purchase and receive an item. Purchasable indicate whether to order an item on a purchase order. Use Approved Supplier indicate whether to use only approved suppliers. If you turn this option on, Oracle Purchasing prevents you from approving a purchase order for an item if you do not use an approved supplier.Allow Description Update indicate whether to allow updates to the item description on a purchasing document line for an item. RFQ Required indicate whether to require an item quotation when requesting an item. Outside Processing Item indicate whether you can add the item to an outside processing purchase order line. Outside Processing Unit Type can be Assembly or Resource Taxable indicate whether the supplier charges a tax. Oracle Purchasing uses the taxable status together with the tax code you associate with a location to determine whether a purchase order shipment is taxable, and what the tax code that applies to this shipment is.Tax Code - Select the appropriate tax code for the item. The tax code shows the tax authorities
and rates that are available to use for this item. Receipt Required (Three-Way Invoice Matching) - Indicate whether you must receive an item before you can pay the invoice. Inspection Required (Four-Way Invoice Matching)- Indicate whether to inspect an item upon receipt from the supplier, before paying the corresponding invoice. Default Buyer - Enter the buyer assigned to purchase an item. Oracle Purchasing displays the buyer you enter here as the suggested buyer for a requisition.
Unit of Issue - Enter the unit of measure you typically use to issue the item from inventory. UN Numbers - Enter the United Nations identification number to identify specific materials (hazardous materials, for example) for international trade purposes. Hazard Class - Oracle Purchasing uses hazard classes to identify categories of hazardous materials for international trade purposes. List Price - Enter the value that Oracle Purchasing uses as the default price on a purchase order, requisition, RFQ, or quotation.Market Price - Enter the market value for an item. Oracle Purchasing copies the market price to the purchase order lines you create.Enter the price tolerance percent, the maximum price percentage over the normal price range for an item. For example, if the tolerance percent is 5, the maximum acceptable price on a purchase order is 5% over the requisition price. Any purchase order price 5% above the requisition price is unacceptable, and you cannot approve the purchase order. Rounding Factor -Enter a number between 0 and 1. This factor determines how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item unit of issue.
Encumbrance Account - Enter the default encumbrance account Oracle Purchasing uses when receiving an item. You encumber, or reserve against funds, when the purchase requisition or purchase order is approved. When you deliver into a subinventory you reverse the encumbrance. The total receipts plus encumbrances equals your total funds spent.
Expense Account - Enter the default inventory account for expense items. Asset Category - Enter the asset category for the item. Oracle Assets uses this attribute to classify your fixed assets.

Planning Attributes


Enter planning method for the item viz: MRP planning - Choose this option for non-critical items that do not require manual planning control, typically dependent demand items.
MPS planning - You master schedule the item and require manual planning control. Choose this option for items with independent demand, items that are critical to your business, or items that control critical resources.
DRP Planned - Choose this option when you have multiple organizations for which you are exercising Distribution Requirements Planning for the item.
MRP/DRP Planned - Choose this option when you want both MRP and DRP planning for the item.
MPS/DRP Planned - Choose this option when you want both MPS and DRP planning for the item.
Select a Forecast control option to determine the types of demand you place for the item. This guides the key processes of two-level master scheduling: forecast explosion, forecast consumption, planning, production relief, and shipment relief. This is appropriate only for items that are models, option classes, options, or mandatory components of models and option classes.
Planned Inventory Point : Indicates if the item is an Inventory Point item. This means that material can be stored
at the item level without losing materials or quality characteristics. Inventory Points generally point to major stocking phases in the manufacturing cycle. Create Supply indicates if supply can be suggested for this item. Critical Component allows you to plan master scheduled items with respect to only critical component Shrinkage Rate - Enter a factor that represents the average amount of material you expect to lose during manufacturing or in storage. The planning process inflates demand to compensate for this expected loss. Enter acceptable early number of days such that planning process will not reschedule orders if due date <= plan date +early days.
Indicate whether to plan material requirements in repetitive daily rates. The planning process suggests repetitive schedules you can implement using the Planner Workbench. Turn this option off to plan material requirements in discrete quantities.
If Oracle Work in Process and Oracle Purchasing are installed, you get automatic production relief when you create a discrete job, purchase requisition, or purchase order. In this case, you would typically set this attribute to None.

Ordering Attributes


Customer Ordered means whether to allow an item to be ordered by external customers. Customer Orders Enabled indicate whether an item is currently customer orderable. 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.Shippable indicate whether to ship an item to a customer.OE Transactable indicates whether shipment transactions are interfaced to Oracle Inventory. Default Shipping Organization - Enter the Oracle Shipping Execution primary shipping organization. Default SO Source Type - This item attribute determines if an item is to be drop-shipped. If the value is internal, the item will not be drop-shipped. If the value is external, the item will be drop-shipped.
Picking Rule - Enter the picking rule that defines the order in which subinventories, 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.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. 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. 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.

Service Attributes


Service attributes are used in Oracle CRM modules like Tele service, Service entitlement, Install base etc. Attributes like service request enabled, track in Install base, contract item type while enabled, this item would appear in those applications.Web option attribute like web status published enables the item to be visible in iStore.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect