Oracle Inventory Interview Questions and Answers-4

Oracle Inventory:

What is a category and category set?
A category is a logical classification of items that
have similar characteristics. A category set is a distinct grouping scheme and consists of categories.

How many structures can an item category flexfield have?
You can define multiple segment structures for the Item Categories Flexfield. Each segment structure may have its own display prompts and fields.

Category Set:

What are the two-category flexfield structures by default
When you install or upgrade Oracle Inventory or Oracle Purchasing?
Oracle provides two category flexfield structures by default: Item Categories and PO Item Category.

A category can belong to multiple category sets. You can assign a category to a category set either at the time you define a category set or at the time you assign an item to the category.

Attention: The categories assigned to a category set must have the same flexfield structure as the set itself. This is true even if you choose not to validate the category list.

Category sets: You can use categories and category sets to group items for various reports and programs.

Note: The category set Inventory is seeded when you install Oracle Inventory. The category set Purchasing is seeded when you install Oracle Purchasing.

Why do we need default category set?
Default category sets are required so that each functional
area has at least one category set that contains all items in that functional area.

If a functional area’s item defining attribute is controlled at the Organization level, then that functional area may only have an Organization level default category set.

What is the prerequisite for assigning item to categories?
You must define default category sets for your functional areas.

What is the need of item cataloging?
You can use item cataloging to add descriptive information to items and to partition your Item Master into groups of items that share common characteristics.

When you assign an item to a catalog group, you choose descriptive elements that apply to the item, and assign values to the descriptive elements.

What is concatenated (connected) Item Descriptions?
If you choose Update Description, Oracle Inventory concatenates(connects) the item catalog group information and overwrites the item description with this new information.

How can we import the items?
We can import items using the Open Item Interface and  
the Customer Item Interface.

How do you define an item by copying attribute information from an existing item?
 From the Master Item window choose Copy From on the Tools
menu to open the Copy From window.

NOTE: The following are not copied: 
Category relationships, organization assignments,
Catalog group information, and costs are not copied.

Note: Use the Organization Items window to update Organization level item attributes for your current organization. To update Master level attributes use the Master Items window.

Oracle Inventory Item Attributes
Item Attributes Listed by Group Name

Main: 
•Primary Unit of Measure
•User Item Type
•Item Status
•Conversions.
Inventory: 
•Inventory Item
•Stockable
•Transactable
•Revision Control
•Reservable

Bills of Material
•BOM Allowed
•BOM Item Type
•Base Model
•Engineering Item (Oracle Engineering only)

Costing: 
•Costing Enabled
•Inventory Asset Value
•Include in Rollup
•Cost of Goods Sold Account

Purchasing: 
•Purchased
•Purchasable
•Use Approved Supplier
•Allow Description Update
•RFQ Required

Receiving: 
•Receipt Date Action
•Receipt Days Early
•Receipt Days Late
•Allow Substitute Receipts
•Allow Unordered Receipts
•Allow Express Transactions

Physical Attributes: 
•Weight Unit of Measure
•Unit Weight
•Volume Unit of Measure
•Unit Volume
•Container
Maximum Load Weight
•Minimum Fill Percentage

General Planning: 
•Inventory Planning Method
•Planner
•Make or Buy
•Min–Max Minimum Quantity
•Min–Max Maximum Quantity
•Minimum Order Quantity
•Maximum Order Quantity

MPS/MRP Planning
•Planning Method
•Forecast Control
•Exception Set
•Pegging

Lead Times: 
•Preprocessing
•Processing
•Postprocessing
•Fixed
•Variable

Work in Process: 
•Build in WIP
•Supply Type
•Supply Sub inventory
•Supply Locator

Order Management: 
•Customer Ordered
•Customer Orders Enabled
•Shippable
•Internal Ordered
•Internal Orders Enabled

Invoicing: 
•Invoiceable Item
•Invoice Enable
•Accounting Rule
•Invoicing Rule



Service: 
•Support Service
•Warranty
•Coverage
•Service Duration
•Billing Type

Primary Unit of Measure
This is the stocking and selling unit of measure. Any necessary
conversions are based on this unit of measure. This attribute is not updatable.

The primary unit of measure is the default for invoices and credit memos entered in Oracle Receivables.

User Item Type
Oracle provides several types by default at installation. These types correspond to the item templates also provided.

ATO model
•Finished good
•Freight
•Inventory Type

Revision Control
Indicate whether to track inventory balances by revision. If you turn this option on you must specify an existing revision number for issues and receipts]

Attention: You cannot change revision control when an item has
quantity on hand. If Revision Control is controlled at the Master Item level, the check for on–hand quantity is against the sum of on–hand quantities in all child organizations.

Note: Reservation control for a subinventory overrides reservation control for an item. In other words, if an item is reservable but a subinventory is not, the item quantity in that subinventory is not reservable.