Oracle Order Management Interview Questions

1)      How many types of Sales Order are there?

Ø  Standard Sales Orders.

Ø  RMA sales Order.

Ø  Back to Back Sales Orders.

Ø  Drop Ship.

2)      What happens when you enter an Order?

After you enter an order, the items on the order are validated in Oracle Inventory; a price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved; the items are then pick released and shipped to the customer

3)      Explain about Processing Constraints

Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.

Examples:

You cannot change the Order Type in the order header once the order is Booked.

You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

4)      What are Defaulting Rules?

Defaulting Rules enable you to speed up data entry by passing values in the window based on some key values you have entered.

Examples:

In the order header, Ship-To Address and Bill-To Address values default in the window once you enter the customer name or number.

If you enter an item number, the Unit of Measure and Item Description automatically default on the order line.

5)      When will you create a Drop Ship Order?

Drop shipments are used due to the following reasons:

·         Customer requires an item that is not normally stocked

·         Customer requires a large quantity of the item which is not available with you

·         It is more economical when the supplier ships directly to the customer

6)      What are Modifiers and Qualifiers?

Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.

A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

7)      At which stage the item is moved from ware house to staging inventory?

During Pick Confirm

8)      What happens during Ship Confirm?

Ship Confirm indicate that the items are loaded onto the carrier from staging location.

9)      What is Auto invoice?

Auto Invoice is a concurrent program in Oracle Receivables that performs invoice processing at both the order and line levels. Once an order or line or set of lines is eligible for invoicing, the Invoice Interface workflow activity interfaces the data to Receivables. Oracle Order Management inserts records into the following interface tables: RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS. 

10)  If the order or lines are On Hold, what happens during Invoice Interface?

The Invoice Interface workflow activity will complete with a status of On Hold and the order details will not be interfaced to Receivables.

11)  What are the Inventory Set ups required for Back to Back Order Processing?

Order Management Tab: Customer Orderable, Assemble to Order (ATO), Purchasing Tab: Purchasable, WIP Tab: Build in WIP, General Planning Tab: Buy

12)  What is a Pick Release?

Pick Release finds and releases eligible delivery lines that meet the release criteria, and creates move orders. You can pick release by order, trip, stop, container, delivery, warehouse, and customer, scheduled or requested dates, shipment priority, or combinations of the above criteria.

13)  What is a Pick Slip?

The Pick Slip Report prints all picking line details in a picking batch. This report is used by warehouse personnel to collect all items included in shipments.

14)  What is Ship Confirming?

Ship Confirming the item removes the existing reservations and performs the sales order issue transaction

15)  What is a trip?

A trip is an instance of a specific freight carrier departing from a particular location containing deliveries. A trip is a carrier specific and contains at least two stops, such as a stop to pick up goods and another stop to drop off goods and may include intermediate stops

16)  What is Bill of Lading?

The Bill of Lading prints all sales orders that have been confirmed from a selected delivery. This document lists the ship date, carrier, bill of lading number, delivery name, shipper, ship-to address, carrier name, waybill number, quantity and description of unpacked items, quantity and total of items packed in containers, total quantity of items, and weight/volume information defined in shipping. Any hipping notes you may have created are also printed.

17)  What are the possible reasons for Interface trip stop to complete with Error?

Few reasons may be Order is on Hold, Tax is not applied properly, On-Hand qty is not available in the Inventory, Inventory Period is not open,  Make sure Schedule Ship Date or Requested Date is within the range of order Date.

18)  Explain Internal Sales Order

Internal Sales Orders are used to transfer material from one inventory organization to other inventory or warehouse organization with the same company.

Flow of Internal Sales Order

Internal requisition in PO/INV à Requisition Approval à Run Create Internal Sales Order Concurrent Program à Run Order Import Concurrent Program in OM à Pick Item in INV thru OM à Ship Confirm à Receive Internal Order in INV / PO

Select Order Source as Internal while importing Orders. Shipping Network (Intransit or Direct) to be defined between two organizations (Source and Destination). Destination (requesting) Organization should be defined as Internal Customer with a Ship to address in Order Management. An Internal Sales Order does not generate Accounts Receivable Invoice

19)  When scheduling, the line got error "ATP Error Scheduling failed". How will you resolve?

This error may be due to Item setup in Inventory & Order Transaction Type Setup Order management. Ensure the Below Setups

Ø  Inventory à Items à Organization Items à Order Management à Check ATP should be none.

Ø  Order Management à Setup à Transaction Types à Define. In 'Shipping' sub-tab uncheck 'Auto Schedule' check box.

Ø  Profile Option 'OM: Auto Schedule' should be 'No'.

20)  What is ASN?

ASN stands for Advanced Shipment Notice. ASN is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number, packing slip data, freight information, and item detail including cumulative received quantities, purchase order number, and returnable container information.