Oracle SCM Functional Interview Questions : Order Management

Order Management

1.    How can we create a normal order line and a return line in a single order

·         You can have category as MIXED in the order type and can assign one line type and one return line type.

2.    How to change price in sales order line after booking without using any modifier. Is it possible, if Yes how?

·         OM: List Price Override Privilege, this profile option will help to do this requirement

3.    Advanced Pricing

4.    Configurator

5.    What is Item validation org and how it is different from Item Master Org

6.    Is it possible to do any transaction (receiving) transaction in Item master org?

·         Yes if Inv period is open

7.    What steps you will do to check if picking did not happen for an order after pick release?

·         Pick Release rule

·         Onhand

·         Hold on order

8.    What is system parameter and what is its significance?

·         We define a lot default parameters for any OU using System Parameters

9.    What all setups required for an ATO order?

10.  What all setups required for Back to Back order?

11.  In an IR, the price of the item, from where it populates?

·         It populates the Frozen cost of the sourcing org

12.  How can you change the price of the item in an IR?

13.  How invoice get generated for IR?

14.  What is the accounting entry happens for an IR invoice?

15.  What is allocation means in sales order and in which step it happens?

16.  What is the difference between allocation and reservation?

17.  If an item is not allowed to enter in any sales order form, what is the setup behind this?

18.  What is the difference between customer ordered and customer order enabled flag?

19.  What are the drop shipment setups and explain the flow?

20.  What are the tables involved in Drop Shipment

21.  What is the difference between Pick Slip and Pack Slip?

22.  What is Bill Of Lading?

23.  If I want to have single invoice generated for all the lines of a sales order even if the lines were shipped in different delivery, what can I do?

24.  What to do if I want to create a same delivery for all the lines of an order even if they were picked in different pick slip and delivery already created for few lines?

Any major issue you have faced in order management during implementation from standard oracle process, not customization

1. Why we need to create different transaction types

Ans: Business might have different requirement like for some order they want to attach the workflow Ship only, for some, Bill only. So they can have this in diff order types.

2. What are the reasons for Back Order

Ans:
The Pick release process includes 2 stpes

• Pick Selection : This will find all the eligible orders which can be picked as per the release criteria(pick release rule) used. If the order does not satisfy the criteria, the the shipping transaction form will remain in the same status like, Next step as Pick Release. 
• Move Order Allocation: After the selection of orders, this will try to allocate the Move orders created. If selection criteria met but due to any reason, allocation of move order could not happen, the step will be back ordered.

Major reasons for back order are

• Onhand not available
• Any reservation against the available Qty
• At the time of releasing source subinv and locators are Active or not
• Inventory Periods
• Item Status
• Customer Ship To site status
• If Lot controlled, check whether the Lot is Active or not also the expiration date is valid or not
• Move order might be in Pending state

To check this, run the Shipping Exception report

3. What are the setups required for IR process

Ans: As this Internal requisition involves of moving an item from one location to other inside a business

Below setups needs to be done

• Item should be Inventory Item, Stockable, Transactable, Purchased, Purchasable,Internal Ordered, Internal Orders Enabled, OE Transactable, Shippable
• Item should be assigned in both source and destination organization
• Shipping network should have been defined betwwen sourcing and to organization.
• Transfer Type, if it is in transit then in destination reciving should be standard receipt and receipt needs to be done manually. If it is direct then receiving should be done in destination directly.
• Internal Order required should be checked
• Destination organization and Location needs to be created
• As Internal SO will generate, so there should be a customer in the source OU with the destination location in its ship to
• Choose the Order type in the Purchasing Options of the PO responsibility of the destination org. This order type ll be used in the Internal order

4. What is Drop Shipment and the setups

Ans: Drop Ship is business creates a PO to supplier for the standard customer demand order for which supplier will directly ship the goods to the customer and bill to the business company. And Business will logically receive the goods and close the standard SO and bill to the customer.

Setups:

• Line source type should be External, this can be defaulted from Item or order type.
• Sourcing rule to be defined
• Drop Customer ship to site should have an internal location attached
• Drop ship workflow should have been assigned to the line type
• Ship to location should have associated with the purchasing receiving location

5. What is Back To Back order and the setups

Ans: In the case where the business does not want to maintain the stock of the item or currently they dont have stock and they want to get that replenished by supplier also parallely want to track the flow then the best option to go with back to back order flow. Mostly Wholesale business chains follow this flow.

Setups

• Define the item as Customer ordered, customer orderable, purchased, purchase order enabled
• Assemble to order check box should be checked
• Item should be defined as Buy in Make/Buy flag in planning or sourcing rule needs to be defined.

SO Line status should be Supply Eligible, PO Req Requested, PO Req Created, PO created, PO received

6. What is ATP and how it is used

7. What are the Processing Constraints

8. When the header closes in a sales order

9. How to enable the Auto pick confirm

10. What is the difference between the COGS and deferred COGS

11. What are the HOLD sources

1. What is sourcing rule

2. What is release sequence rule

1. How to apply hold as soon as save the order
2. Is it possible to change the price of a line once after all modifier application the field is grayed out
3. If there are 2 modifiers with same precedence which satisfies a qualifier then which modifier will be applied and if different precedence then which modifier will be applied?

Ans: In both the cases, both the modifier will be applied on the SO. If the modifier terms satisfies the order details then irrespective of precedence if it qualifies, all the modifiers will be applied by the pricing rule engine.
4. Can an expense item received in RMA
5. What are the basic item attributes to use it in RMA and receiving
Questions will be Answered soon if not answered already. Meanwhile you can post more questions in the comment also you can answer to above questions in the comment.
Please help here to rectify if any of the answers are not correct.