Oracle EBS-Inventory

1.What is item status? Name the related table.

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 (INVSDOIS)like “easyapps”

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

2.Define steps of assigning items to an organization.

Create an item in Item master from and select the template to assign the corresponding item attributes from tools menu. Now save the item. After saving the item select the organizational assignment option from tools menu for that item and organizational assignment item form popups. Now u can select the organizations from the list by ticking in check box.save the work.

3.In which table subinventory related information for item is stored?

MTL_ITEM_SUB_INVENTORIES

4.What are the prerequisite set ups for interorganization transaction?

Prerequisites
Define an inventory item that is common to both organizations. See:Defining Items and Assigning Items to Organizations.Define at least two organizations, one of which is valid to receive material from the other. See: Creating an Organization, Oracle Human Resource Management Systems User’s Guide and Defining Organization Parameters.Set up inter–organization relationships and their corresponding accounts. See: Defining Inter–Organization Shipping Networks. 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. See: Defining Items.

5.Where to define interorganization transaction charges and what are the different options?

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.

6.What are stock locators and how to define them?

Stock locators are an optional entity that may be used to represent physical locations within a subinventory. You may choose to use stock locators for selected subinventories or selected items within selected subinventories. If locators are used, subinventory and locator track on-hand balances. Therefore, if locators are defined to represent a shelf within a stockroom, on-hand balances on the system would show the item and quantity down to the physical location within the facility.U can derfine them in stocklocator from (INVSAFDH) in inventory setups. MTL_ITEM_LOCATIONS is the main base table for this locators.

7.Name the tables where the stock locator information is stored. At least two.

Refer above Q.One more table is MTL_ITEM_LOC_DEFAULTS

8.What is unit of measure classes? Give atleast two examples. Name the underlying table.

9.What is the prerequisite for difining unit of measure?

10.In which tables the transaction details stored? Atleast two.

11.What are centralized and decentralized level of control of item attributes?

12.Name all status attributes.

13.Differentiate between intra & inter uom class conversion with examples.

14.Is uom maintained at master level or organization level or both?

15.Mention the interface tables for item open interface and open transaction interface and also their respective production tables.

16.Name atleast five reports in oracle inventory related to transaction ?

17.What are the prerequsites for costing transactions?

18.Which is the table for storing organization information?

19.How to get the on hand quantity of an item across all organizations? Name the underlying tables.

20.What is the purpose of standard cost update?

21.Mention the navigational steps for abc analysis

——————————————————————————————————————————————-

1. What is an Organization & Location?
2. What are the KeyFlexFields in Oracle Inventory Module?
3. What are the Attributes of Item Category & System Items?
4. What are the KeyFlexFields in Oracle Purchasing & Oracle Payables?
5. What are the KeyFlexFields in Oracle HumanResources & Oracle Payroll?
6. How would you create an Employee (Module Name) Describe?
7. What is a Position Hierarchy? Is there any restriction to create that?
8. To whom we call as a Buyer? What are the Responsibilities?
9. How do you Setup an Employee as a User – Navigation?
10. How many Approval Groups we have? Describe?
11. Describe the Types of Requisition?
12. How many Status’s and Types For RFQ’s & Quotations Describe?
13. How many Types of Purchase Orders We Have?
14. What is a Receipt?
15. What is Catlog Rfq?
16. Give me online about Planned Po?
17. How can the manger view the Approval Documents Information?
18. Whether the manager can forward to Any other person? How?
19. Can u resend the document your subordinate how?
20. What is Po Summary?

Answers
1. It is a Ware House Which you can Store the Items, And You can setup your business Organization Information Like Key Flexfilelds,Currency,Hr Information and starting time and end time. Location’s are like godown place, office place, production point.

2. System items,Item Categories,Account Alias,Sales Order,Item Catalog,Stock Locators

3. The classification of items are Category Like Hard ware and Software, where as the Systems are individual items like Cpu,Key Board.

4. No Flexfields, But the help of Inventory And Human Resources we can use

5. Job Flexfield,Position Flexfield,Grade Flexfiled,Costing,People Group Flexfield,Personal Analysis Flexfield

6. If Human Resource is Installed Hr/Payroll, If Not I can create Employee using with Gl,Ap,Purchasing,Fixed Assets

7. It is a Grouping of Persons for Approving and Forwarding the Documents from one person to another person, there is no restriction.

8. The Employee is nothing a Buyer, who is responsible for Purchase of Goods or services.

9. Security->User->Define, System Administration Module.

10. Document Total,Accounts,Items,Item Categories,Location.

11. Purchase Requistion,Internal Requistion.

12. In Process,Print,Active,Closed for Rfq’s In Process,Active,Closed for Quotation.

13. Standard,Purchase Agreement,Blanket PO,Planned PO.

14. To Register the Purchase orders/PO lines for shipment purpose.

15. It contains Price breaks with different quantity levels.

16. For a Agreement for long period for goods.

17. Notifications Window.

18. Yes, In the Notifications Window under the Forward to Push Button.

19. Yes, In the Notifications Window under the Forward to Push Button.

20. The Purchase Order Summay Information like total lines, and stauts

———————————————————————————————————————————————————

1) Which are required steps in Inventory module set up?
Answer:
a) All the 6 key flexfields i.e Items, Item Catalog, Account Alias, Sales Order, Locator and Item Category
b) Organizations
c) Change Organizations
d) Intercompany Relations
e) Unit of Measure Classes
f)Subunventories
g)Item Attribute Controls, Categories
h)Default Category set
i)Item Statuses
j) Cost types
k)Profile Options
l)Inventory Accounting Periods

2) What do you mean by Required with Defaults Steps?
Answer:
Required Step With Defaults means that the setup functionality comes with pre-seeded, default values in the database; however, you should review those defaults /default values and decide whether to change them to suit your business needs

3)Which are Required with Defaults Steps in Inventory module?
Answer:
There are no such steps in Inventory module

4)There is no stock locator control in your Inventory organization.Do you still need to configure it?
Answer:
You need not to configure the flexfield in a specific way but you must still compile the Stock Locators key Flexfield because all Oracle Inventory transaction and on-hand inquiries and reports require a frozen flexfield definition

5) What is the use of a picking rule?
Answer:
When you pick release a sales order in Order Management module , Order Shipping Execution module ( which is a part of Order Management) submits requests to Oracle Inventory module which uses the information given in picking rule to give priority to pick units of an items and then it generates pick lists for sales orders

6) Can you apply material overheads to Average Costing Organization?
Answer:
No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization

7) What is a Transaction Action?
Answer:
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

8) How many Predefined Transaction Actions are available in Inventory module?
Answer:
You may use one of six predefined transaction actions: –issue from stores, subinventory transfer, direct organization transfer, intransit shipment, cost update and receipt into stores.

9)Can you do Inventory transactions in prior periods?
Answer:
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

10) Can you change customer item name or Item after you save it?
Answer:
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

————————————————————————————————————————————————————-

3)Which are Required with Defaults Steps in Inventory module?
Answer:
There are no such steps in Inventory module

6) Can you apply material overheads to Average Costing Organization?
Answer:
No, you can not apply it to Average Costing Organization. However you can apply it to Standard Costing Organization

7) What is a Transaction Action?
Answer:
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

This entry was posted on May 18, 2011 at 4:59 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Rakeshbutkury’s Blog