Archive for May, 2011

Oracle EBS-Inventory

May 18, 2011

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

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

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

Advertisements

Purchase Order Types in Oracle EBS.

May 17, 2011

Purchase Order Types
Oracle Purchasing provides the following purchase order types: Standard Purchase Order, Planned Purchase Order, Blanket Purchase Agreement and Contract Purchase Agreement. You can use the Document Name field in the Document Types window to change the names of these documents. For example, if you enter Regular Purchase Order in the Document Name field for the Standard Purchase Order type, your choices in the Type field in the Purchase Orders window will be Regular Purchase Order, Planned Purchase Order, Blanket Purchase Agreement and Contract Purchase Agreement

Standard Purchase Orders
You generally create standard purchase orders for one–time purchase of various items. You create standard purchase orders when you know the details of the goods or services you require, estimated costs, quantities, delivery schedules, and accounting distributions. If you use encumbrance accounting, the purchase order may be encumbered since the required information is known

Blanket Purchase Agreements (BPA)
You create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period, but you do not yet know the detail of your delivery schedules. You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them. BPA are widely used in product manufacturing companies.

You can issue a blanket release against a blanket purchase agreement to place the actual order (as long as the release is within the blanket agreement effectivety dates). If you use encumbrance accounting, you can encumber each release

Contract Purchase Agreements
You create contract purchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You can later issue standard purchase orders referencing your contracts, and you can encumber these purchase orders if you use encumbrance accounting

Planned Purchase Order
You create a planned purchase order when you want to establish a long term agreement with a single source supplier with a commitment to buy goods or services. Planned purchase orders include tentative delivery schedules and accounting distributions. You then create scheduled releases against the planned purchase order to actually order the goods or services.

A planned purchase order is a type of purchase order you issue before you order actual delivery of goods and services for specific dates and locations. A scheduled release is issued against a planned purchase order to place the actual order. You can also change the accounting distributions on each release and the system will reverse the encumbrance for the planned purchase order and create a new encumbrance for the release

Purchase Order Types Summary

  Standard Purchase Order Planned Purchase Order Blanket Purchase Agreement Contract Purchase Agreement
Terms and Conditions Known Yes Yes Yes Yes
Goods or Services Known Yes Yes Yes No
Pricing Known Yes Yes Maybe No
Quantity Known Yes Yes No No
Account Distributions Known Yes Yes No No
Delivery Schedule Known Yes Maybe No No
Can Be Encumbered Yes Yes No No
Can Encumber Releases N/A Yes Yes N/A