Explore topic-wise InterviewSolutions in .

UNIT of MEASURE classes represent GROUPS of units of measure with similar characteristics. For example, QUANTITY is a unit of measure class and each, dozen, and GROSS are examples of units of measure within the class.

Unit of measure classes represent groups of units of measure with similar characteristics. For example, quantity is a unit of measure class and each, dozen, and gross are examples of units of measure within the class.

Inventory Interface PROGRAM populates the interface TABLES with transactions submitted through Confirm shipment forms. It updates order lines with shipped QUANTITIES and updates inventory.

Inventory Interface Program populates the interface tables with transactions submitted through Confirm shipment forms. It updates order lines with shipped quantities and updates inventory.

Yes, you can do by setting the profile OPTION INV: Transaction DATE validation to Provide WARNING when date in past period or Allow date in any open period. It ALLOWS ENTRY of a past date.

Yes, you can do by setting the profile option INV: Transaction Date validation to Provide warning when date in past period or Allow date in any open period. It allows entry of a past date.

A transaction action is a predefined method of changing the QUANTITY and/or LOCATION and/or cost of an ITEM. It is USED in Transaction TYPE form.

A transaction action is a predefined method of changing the quantity and/or location and/or cost of an item. It is used in Transaction Type form.

No, you can not APPLY it to AVERAGE Costing Organization. HOWEVER you can apply it to STANDARD Costing Organization.

No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization.

ORG ID is a unique ID for the OPERATING Unit. ORGANIZATION Id: The Organization Id is an ID for the INVENTORY Organization which is under an Operating Unit.

Org Id is a unique ID for the Operating Unit. Organization Id: The Organization Id is an ID for the Inventory Organization which is under an Operating Unit.

Depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction VALUE or a discrete amount that Oracle Inventory USES to compute transfer charges.

Depending on the inter–organization transfer charge that applies between the organizations, a percentage of the transaction value or a discrete amount that Oracle Inventory uses to compute transfer charges.

mtl_parameters

mtl_parameters

CATEGORIES and Category Sets can be used to group the items for various reports and PROGRAMS.

A category is a LOGICAL classification of items that have similar characteristics. A category set is a DISTINCT GROUPING scheme and consists of categories.

Categories and Category Sets can be used to group the items for various reports and programs.

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

Prerequisites:

Define an inventory item that is COMMON to both organizations. Define at LEAST two organizations, one of which is VALID to receive material from the other. Set up inter–organization relationships and their corresponding accounts. Like Shipping Network. For direct transfers, if the item to transfer is under SERIAL number control, the item must have the same UNIT of measure in each organization. 

Prerequisites:

Define an inventory item that is common to both organizations. Define at least two organizations, one of which is valid to receive material from the other. Set up inter–organization relationships and their corresponding accounts. Like Shipping Network. For direct transfers, if the item to transfer is under serial number control, the item must have the same unit of measure in each organization. 

MTL_ITEM_SUB_INVENTORIES.

MTL_ITEM_SUB_INVENTORIES.

There are two types of templates:

Predefined and Custom Template.

Predefined templates are PLANNING item, PURCHASED, outside PROCESSING item, LEASE item. So that once you assign any template, to new item then all default characters are assign to new item.

There are two types of templates:

Predefined and Custom Template.

Predefined templates are planning item, purchased, outside processing item, lease item. So that once you assign any template, to new item then all default characters are assign to new item.

• SYSTEM Item
• Item Catalog
• Item CATEGORIES
• STOCK LOCATOR
• ACCOUNT Aliases

There are 4 inventory Planning METHODS as MENTIONED below:

1. Min-max planning
2. Re-order POINT planning
3. Kanban planning 
4. Periodic Automatic Replenishment(PAR)

There are 4 inventory Planning methods as mentioned below:

1. Cycle counting is the PERIODIC counting of individual items throughout the course of the year to ENSURE the accuracy of item. Physical Inv. counts the entire inventory once a year Physical Inv. takes a snapshot of inv.'s on-hand QUANTITY at the beginning of the process. All adjustments are made against snapshot quantity.
2. In cycle counting fewer items are COUNTED each DAY so less disruption to normal production or distribution In PI all items are counted once a year so a lot of disruption.

INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you DEFINING the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INV DOIS)like “easyapps”.

Active, Inactive, Engineer, Obsolete, Phase-Out, Prototype, OPM, Lease, Production, Concept, Design, DEM_Status, PENDING.

INVENTORY_ITEM_STATUS_CODE is the Colum in table MTL_ITEM_STATUS will tell you the different status for item while you defining the item in item master form (INVIDITM). You can have different status as shown in below, also u can define your own custom status in status code form in item setups (INV DOIS)like “easyapps”.

Active, Inactive, Engineer, Obsolete, Phase-Out, Prototype, OPM, Lease, Production, Concept, Design, DEM_Status, Pending.

Yes, you can change it if you have SET the profile OPTION INV: UPDATABLE CUSTOMER Item to Yes and INV: Updatable item to Yes respectively.

Yes, you can change it if you have set the profile option INV: Updatable Customer Item to Yes and INV: Updatable item to Yes respectively.

INVENTORY ORGANIZATION is a FACILITY where you store and transact items. It can be a manufacturing unit, warehouse, DISTRIBUTION centre, item master organization (logical entity), etc.

Inventory Organization is a facility where you store and transact items. It can be a manufacturing unit, warehouse, distribution centre, item master organization (logical entity), etc.

An item MASTER ORGANIZATION is a logical ENTITY that you use to define items. After you define an item in the item master, you can assign it to any number of other organizations. You should also define one item master organization per IMPLEMENTATION. When you define an item, Oracle automatically changes your CURRENT organization to the master organization.

An item master organization is a logical entity that you use to define items. After you define an item in the item master, you can assign it to any number of other organizations. You should also define one item master organization per implementation. When you define an item, Oracle automatically changes your current organization to the master organization.

1. All the 6 key flex fields i.e. Items, Item Catalog, Account Alias, Sales Order, LOCATOR and Item CATEGORY 
2. Organizations
3. Change Organizations
4. Intercompany Relations
5. UNIT of Measure Classes
6. Sub inventories
7. Item Attribute Controls, Categories
8. Default Category set
9. Item Statuses
10. COST types
11. Profile Options
12. Inventory Accounting Periods