November 2, 2012


Defining Inventory Organization

Navigate to the Inventory Super User responsibility.
Setup à Organizations à Organizations
Define the following organizations as per the requirement of business
·         Business Group
·         Legal entity
·         Operating Unit
·         Organization

External organizations (for example, tax offices, insurance carriers, disability organizations, benefit carriers, or recruitment agencies)
Internal organizations (for example, departments, sections or cost centers)

Select New

Creating an Organization


1.       Enter a name for your organization in the Name field. A check is performed to see if organizations with the same name already exist.
All Oracle applications you install share the information entered in the Organization window. Therefore organization names must be unique within a business group, and business group names must be unique across your applications network.
2.       Optionally, select an organization type in the Type field.
Organization types do not classify your organization; you use them for reporting purposes only. The type may identify the function an organization performs, such as Administration or Service, or the level of each organization in your enterprise, such as Division, Department or Cost Center.
3.       Enter a start date in the From field. This should be early enough to include any historical information you need to enter.
4.       Enter a location, if one exists. You can also enter an internal address to add more details such as floor or office number.
5.       Enter internal or external in the Internal or External field. You cannot assign people to an external organization.
Examples of external organizations that may require entry are disability organizations, benefits carriers, insurance carriers, organizations that employees name as beneficiaries of certain employee benefits, and organizations that are recipients of third party payments from employees' pay.
6.       Then save your work.

Organization Classification

As we are defining an Inventory Organization, we will choose the classification name as Inventory Organization.
Then mark the enabled checkbox and then save your work.  

Then go to Others

Select Accounting Information
Here, we need to attach the Ledger, Legal Entity and Operating Unit.

Enter the details and select Ok, again in next window Ok.
This will ask for a confirmation, select Yes.
Then again from the Others button, select Inventory Information.
This will pop up the Organization Parameters window.

Organization Parameters

You can define and update default inventory and costing parameters for your current organization in the following areas:
  1. Inventory Parameters
  2. Costing Information
  3. Other Account Parameters
  4. Revision, Lot, Serial, LPN Parameters
  5. ATP, Pick, Item–Sourcing Parameters
  6. Defining Inter–Organization Information
  7. Defining Warehouse Parameters

Inventory Parameters



1. Enter an organization code for which you want to set up the organization parameter.
2. Select an Item Master organization. Oracle Inventory only defines items in the Item Master organization of the organization from which you enter the Items window.
3. Select a workday calendar. This is required when Oracle Master Scheduling/MRP and Oracle Supply Chain Planning is installed.
4. Optionally, select a demand class. Demand classes segregate scheduled demand and production into groups, allowing you to track and consume those groups independently. Oracle Master Scheduling/MRP and Oracle Supply Chain Planning uses this demand class during forecast consumption, and shipment and production relief.
5. In the Move Order Timeout Period field, enter the number of days a move order requisition can wait for approval.
The workflow approval process sends a notification to the item planner when a move order requisition requires approval. After the first timeout period, if the recipient has not approved or rejected the order, a reminder notice is sent. After the second timeout period, the order is automatically approved or rejected, depending on whether you select Approve automatically or Reject automatically in the Move Order Timeout Action field. If you want to bypass the move order approval process and automatically approve move order requisitions, enter 0 days in the Move Order Timeout Period field and select Approve automatically in the Move Order Timeout Action field.
6. Select a move order timeout action
Approve automatically: After the second timeout period, move order requisitions are automatically approved. Select this option and set the Move Order Timeout Period to 0 if you want to bypass the move order approval process and automatically approve move order requisitions.
Reject automatically: After the second timeout period, move order requisitions are automatically rejected.
7. Select a locator control option:
None: Inventory transactions within this organization do not require locator information.
Prespecified only: Inventory transactions within this organization require a valid, predefined locator for each item.
Dynamic entry allowed: Inventory transactions within this organization require a locator for each item. You can choose a valid, predefined locator, or define a locator dynamically at the time of transaction.
Determined at subinventory level: Inventory transactions use locator control information that you define at the subinventory level.
  • Indicate whether to allow negative balances. Determines whether inventory transactions can drive the inventory balance of an item negative.
    Attention: If insufficient quantity on hand exists in a supply subinventory to satisfy backflush demand, Oracle Work in Process forces the supply subinventory balance negative, ignoring this option setting.
  • Auto delete allocation at Move Order cancellation
  • Indicate whether this organization is an Oracle Warehouse Management enabled organization. You can use WMS features such as LPNs, task management, warehouse execution rules and cost
    groups in this organization. Locator control must be enabled in order to enable WMS. Once this has been enabled and transactions have been entered in this organization, this box cannot be unchecked.
  • Indicate whether this organization is enabled for Quality inspection.
  • Indicate whether this organization is an Oracle Enterprise Asset Management enabled Organization.
  • Enter a total load weight and unit of measure for this organization.
  • Enter a total volume and unit of measure for this organization.  
8. Select a Default On-hand Material Status tracking option. This step is optional.
9. Indicate whether locator aliases must be unique across the organization

Costing Information


1. Costing Organization

2. Costing Method


3. Transfer to GL
Indicate whether all transactions are posted in detail to the general ledger.
Caution: Transferring detail transaction distributions to the general ledger increases general ledger posting times due to the number of records created.
4. Reverse Encumbrance Indicate whether to reverse encumbrance entry upon receipt in inventory.
You normally select this option if you use encumbrances with Oracle Purchasing.
5. Optionally, enter a Cost Cutoff Date
If you leave this field blank, all available transactions will be costed,as usual. If you enter a date, all transactions prior to this date will be costed. All transactions on or later than this date will not be costed.
For inter–organization transfers, a standard costing, receiving organization will not cost a receipt if the sending organization did not already cost the transaction.
The default time is the first instant of the date. You can optionally choose another time.
The standard cost update process can be performed on the cost cutoff date. You can restart cost processing by changing the cutoff date to blank, or a future date.

6. Default Material Sub element
For standard costing, select a material sub–element that this organization uses as a default when you define item costs. For average costing, the default material sub–element you select can be used for cost collection when Project Cost Collection Enabled is set.
7. Material Over head Sub element
Optionally, select a Default Material Overhead Sub–Element from the list of values. During the Supply Chain Rollup process, when costs are merged from another organization, markup and shipping costs will use this value.
The supply chain cost rollup will complete successfully, regardless of whether this field is populated. If the Cost Rollup identifies an organization with a default material overhead sub–element not set up, a corresponding warning message will be printed in the log file.
8. Default Cost Group
Indicate the default cost group for the organization. This will default into the Default Cost Group field for each subinventory. If the WMS cost group rules engine fails to find a cost group, this cost group will be used.
9. Valuation Accounts
You choose a default valuation account when you define organization parameters. Under standard costing, these accounts are defaulted when you define subinventories and can be overridden. Under average costing, these accounts (except for Expense) are used for subinventory transactions and cannot be updated. For a detailed discussion of cost
elements.
Material An asset account that tracks material cost. For average costing, this account holds your inventory
and intransit values. Once you perform transactions, you cannot change this account.
Material Overhead An asset account that tracks material overhead cost.
Resource An asset account that tracks resource cost.
Overhead An asset account that tracks resource and outside processing overheads.
Outside processing An asset account that tracks outside processing cost.
Expense The expense account used when tracking a non–asset item.

Other Accounts


Purchase Price Variance : The variance account used to record differences between purchase order price and standard cost. This account is not used with the average cost method.
Invoice Price Variance : The variance account used to record differences between purchase order price and invoice price. This account is used by Accounts Payable to record invoice price variance.
Inventory A/P Accrual : The liability account that represents all inventory purchase order receipts not matched in Accounts Payable, such as the uninvoiced receipts account.
Encumbrance: An expense account used to recognize the reservation of funds when a purchase order is approved.
Sales: The profit and loss (income statement) account that tracks the default revenue account.
Cost of Goods Sold: The profit and loss (income statement) account that tracks the default cost of goods sold account.
Project Clearance Account: When performing miscellaneous issues to capital projects, the project clearance account is used to post the distributions.
Deferred COGS Account: This account is used by the Sales Order Issue transaction type to deferred COGS until AR recognizes revenue.
Cost Variance Account:  Under average costing with negative quantity balances, this account represents the inventory valuation error caused by issuing your inventory before your receipts.
Landed Cost Management (LCM) variance account: This account is used by the new Landed Cost Management module.
Note: For standard costing, only the Purchase Price Variance, Inventory A/P Accrual, Invoice Price Variance, Expense, Sales and Cost of Goods Sold accounts are required. The other accounts are used as defaults to speed your set up.
Note: For average costing, only the Material, Average Cost Variance, Inventory A/P Accrual, Invoice Price Variance, Expense, Sales and Cost of Goods Sold accounts are required. The other accounts are used as defaults or are not required.

Revision, Lot, Serial, LPN Parameters


Enter a starting revision to be the default for each new item.
Lot Number
1. Select an option for lot number uniqueness.
Across items: Enforce unique lot numbers for items across all organizations.
None: Unique lot numbers are not required.
2. Select an option for lot number generation.
User–defined: Enter user–defined lot numbers when you receive items.
At organization level: Define the starting prefix and lot number information for items using the values you enter in the Prefix, Zero Pad Suffix, and Total Length fields. When you receive items, this information is used to automatically generate lot numbers for your items.
At item level: Define the starting lot number prefix and the starting lot number when you define the item. This information is used to generate a lot number for the item when it is received.
3. Indicate whether to add zeroes to right–justify the numeric portion of lot numbers (Zero Pad Suffix).
4. Optionally, select an alphanumeric lot number prefix to use for system–generated lot numbers when generation is at the organization level.
5. Optionally, define the maximum length for lot numbers. If you use Oracle Work in Process and you set the WIP parameter to default the lot number based on inventory rules, then WIP validates the length of the lot number against the length you define in this field.
Serial Number
1. Select an option for serial number uniqueness.
Within inventory items: Enforce unique serial numbers for inventory items.
Within organization: Enforce unique serial numbers within the current organization.
Across organizations: Enforce unique serial numbers throughout all organizations.
2. Select an option for serial number generation.
At organization level: Define the starting prefix and serial number information for items using the information you enter in the following fields of this window.
At item level: Define the starting serial number prefix and the starting serial number when you define the item.
3. Optionally, select an alphanumeric serial number prefix to use for system–generated serial numbers when generation is at the organization level.
4. Optionally, enter a starting serial number to use for system–generated serial numbers.
If serial number generation is at the organization level you must enter a starting serial number.
5. Indicate whether the system will suggest serial numbers as part of the move order line allocating process. If you do not select this option, you must manually enter the serial numbers in order to transact the move order.

ATP, Pick, Item–Sourcing Parameters


Select a default ATP rule.
ATP rules define the options used to calculate the available to promise quantity of an item. If you are using Oracle Order
Management, the default is the ATP rule for the Master organization.
Picking Defaults
Select a default picking rule.
Picking rules define the priority that order management functions use to pick items.
Notes: This rule will not be employed in a WMS enabled organization. The WMS picking rules will be used.
Enter a default subinventory picking order.
This value indicates the priority with which you pick items from a subinventory, relative to another subinventory, in which a given item resides. The value you enter here displays as the default when you define a subinventory.
Enter a default locator picking order.
This value indicates the priority with which you pick items from a locator, relative to another locator, where a given item resides. The value you enter here displays as the default when you define a locator.
Check the Pick Confirmation Required box if you want your pickers to manually pick confirm. If you do not check the box, pick confirmation will occur automatically.
Item-Sourcing Default
Select a source type for item replenishment.
Inventory: Replenish items internally from another subinventory in the same organization or another organization.
Supplier: Replenish items externally, from a supplier you specify in Oracle Purchasing.
None: No default source for item replenishment.
Select the organization used to replenish items.
You must enter a value in this field if you selected Inventory in the Type field.
Select the subinventory used to replenish items.
You must enter a value in this field if you selected your current organization in the Organization field. You cannot enter a value in this field if you selected Supplier in the Type field.

Inter–Organization Information


Select an Inter–Organization Transfer Charge option.
None: Do not add transfer charges to a material transfer between organizations.
Predefined percent: Automatically add a predefined percent of the transaction value when you perform the inter–organization transfer.
Requested value: Enter the discrete value to add when you perform the inter–organization transfer.
Requested percent: Enter the discrete percentage of the transfer value to add when you perform the inter–organization transfer.
Inter–organization cost accounts
Enter default inter–organization cost accounts. These accounts are defaulted when you set up shipping information in the
Inter–Organization Shipping Networks window



Read More

Item Attributes

There are scope of 270 different Item attributes in 17 different attibute groups.
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:
Attribute
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.


Read More
Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here