Explore topic-wise InterviewSolutions in .

So that we can have an item MAINTAINED at master LEVEL with COMMON attributes and then we can use the same item across MULTIPLE organizations INSTEAD of defining it again and again.

So that we can have an item maintained at master level with common attributes and then we can use the same item across multiple organizations instead of defining it again and again.

We can define different STATUS for an item combination these ATTRIBUTES as PER the business NEED.

We can define different status for an item combination these attributes as per the business need.

We can define DIFFERENT STATUS for an item COMBINATION these attributes as per the business need.

Following are the attributes:

• BOM Enabled
• BUILD in WIP
• Customer order enabled
• Internal Order enabled
• Inviolable
• Purchasable
• Stackable
• Transactable

We can define different status for an item combination these attributes as per the business need.

Following are the attributes:

This wills determine whether to CONSIDER the onhand of the SUB INVENTORY as available for planning tasks.

This wills determine whether to consider the onhand of the sub inventory as available for planning tasks.

MO GENERALLY is the request of movement of ITEMS in one organization. It may be of from 3 sources, MO requisition, REPLENISH MO, Pick WAVE MO. MO can be MO Issue which will issue the item from the location and MO transfer which ll transfer the item to ANOTHER location.

MO generally is the request of movement of items in one organization. It may be of from 3 sources, MO requisition, Replenish MO, Pick Wave MO. MO can be MO Issue which will issue the item from the location and MO transfer which ll transfer the item to another location.

MOVE ORDERS generated as PART of Pick Wave are the ONES from Sales order.

Move orders generated as part of Pick Wave are the ones from Sales order.

• Lot control is to control a whole batch of items. for example in DRUG industry we have batch number which can be controlled using lot where we can track the complete batch using specific data.
• SERIAL control is to MONITOR and track every single QTY of an item like electronic DEVICES where we track by serial number.

• DEPENDING on the requirement, we can trigger CYCLE count.
• We can define REGULAR cycle count of HIGH values items.
• If back ordered or PICK denied, we can trigger cycle count for those items.

• Picking Rule is USED to determine the list of items for sales order/ SHIPPING based on the revision, Lot, SUB inventory and LOCATOR.
• Assign the required Picking Rule to the item in Order MANAGEMENT tab.

• MO Issue will move out the STOCK from inventory against an ACCOUNT.
• MO TRANSFER will move the stock from ONE sub inventory to other.

• CREATE a cycle COUNT header with REQUIRED data
• Assign the ITEMS to be counted
• Then run the required cycle count report
• Using the report do the cycle counts
• Then go and APPROVE the cycle count

• BC ANALYSIS is an Inventory CATEGORIZATION method to categorize items into 3 different classes A being the most VALUABLE and C being the least valuable ones.
• Using this Analysis, it will be easy to monitor and keep on track of the valuable items like frequently doing cycle COUNTS on A class items, etc.

• Material: An asset ACCOUNT that tracks material cost. For average costing, this account holds your inventory and in transit 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:

• 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.
• 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.
• 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.
• 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.
• ENCUMBRANCE: An expense account used to recognize the reservation of funds when a purchase order is approved.
• Average Cost Variance: Under average costing with negative quantity balances, this account represents the inventory valuation error caused by issuing your inventory before your receipts.

Other Accounts:

• Purchasable is a status attribute flag, so based on this flag, certain transactions can be controlled for an item.
• Purchased flag decides whether to purchase and receive this item.
• Purchasable flag decides whether to order this item in a purchase order.
• If purchasable is ENABLED, item can be ordered in a purchase order, if not, new purchase ORDERS can’t be created and approved for the items.
• If purchased is enabled, item can be RECEIVED if already PRESENT in an approved purchase order.

• Location
• Calendar
• ORGANIZATION
• Parameter
• Cost GROUP
• Sub inventory
• STOCK Locator
• Receiving Options
• SHIPPING Networks
• Intercompany TRANSACTION flows
• Cost Sub elements

• This can be modified USING Flexfield>Key> Segments.
• QUERY the System Items, then you can modify the existing structure, or you can add a new ONE.

• This is used during MATERIAL transaction when SOURCE is Sales ORDER.
• Segments are Sales order Number. Sales Order TYPE. Sales Order Source.

Seven KFF are there in Inventory: 

• Account Alias
• ITEM
• Item Category
• Item Catalogues
• Stock LOCATORS
• SALES Order
• Service Items

Seven KFF are there in Inventory: 

• Should not be INVENTORY ITEM
• No Stackable
• No Transactable
• No COSTING, INV ASSET

MIN MAX planning report under planning menu in Inventory RESPONSIBILITY

Min Max planning report under planning menu in Inventory responsibility

Setup the item in master ORG and assign the item to the org for which Min-Max planning is used

• Attributes, INV Planning method: Min-Max
• Min-Max QTY should have been defined
• Safety Stock method should be non MRP Planned
• Determine what should be the status of the Requisitions created for the planning
• Do this with profile OPTION INV: Minmax Reorder Approval
• IF Use ASL has been enabled, then Requisition will populate the supplier data from the ASL setup which is assigned to the item
• Sourcing rules can be defined for this
• Then need to assign sourcing rule to the item
• In Inventory responsibility, under Planning run the Min Max planning report with required parameter

Setup the item in master org and assign the item to the org for which Min-Max planning is used

There are 5 different PLANNING methods in oracle INVENTORY:

1. Subinv Replenishment Planning
2. MIN Max Planning
3. Re-order POINT planning
4. Kanban Planning
5. Periodic Automatic Replenishment

There are 5 different planning methods in oracle Inventory: