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?

       Ans: 

        1. Item needs to setup as ATO Model

        2. BOM of the ATO Model needs to be defined

        3. Using configurator, select the options

        4. Submit the selection

        5. Order will add the selected component

        6. Pick the individual items and ship those

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?

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

26. What is ATO

27. What is a Kit item

28. What is PTO Model

29. What is difference between Kit and PTO Model

30. How configurator works

31. Explain Configure to Order

32. 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.

33. 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

                34. 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

35. 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

36. 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

        37. What is ATP and how it is used

        38. What are the Processing Constraints

        39. When the header closes in a sales order

        40. How to enable the Auto pick confirm

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

        42. What are the HOLD sources

        43. What is sourcing rule

        44. What is release sequence rule

        45. How to apply hold as soon as save the order
       46. Is it possible to change the price of a line once after all modifier application the field is grayed out
        47. 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.
        48. Can an expense item received in RMA
        49. 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. Read More

 1.        Create an AR transaction type for Advance Invoice with class Deposit 
 2.        Using this transaction type, create a Deposit for the same customer 
 3.        After receiving the amount from customer against this Deposit Invoice, create a Receipt 
 4.        Apply the receipt with the Deposit 
 5.        Now Create the required Sales order for the customer and ship confirm 
 6.        This will create the end customer invoice with full amount 
 7.        Now query the end customer invoice and apply deposit(Action--> Apply Deposit) by querying the deposit which created earlier 
 8.        Save the transaction and then click the refresh button in the Balance Due block, you can now see the difference amount after Deposit deduction 
 9.        Also you can see all adjustments in the Details button

Note: Final Invoice date should fall in between Deposit Invoice effective dates 

Read More

SELECT FPO.PROFILE_OPTION_ID,
      FPO.PROFILE_OPTION_NAME,
      FPOT.USER_PROFILE_OPTION_NAME,
      FPOV.LEVEL_ID,
      DECODE(FPOV.LEVEL_ID,
             '10001',
             'Site',
             '10002',
             'Appllication',
             '10003',
             'Responsibility',
             '10004',
             'User',
             FPOV.LEVEL_ID) LEVEL_TYPE,
      FPOV.LEVEL_VALUE,
      DECODE(FPOV.LEVEL_ID,
             '10001',
             'Site',
             '10002',
             (SELECT APPLICATION_NAME
                FROM APPS.FND_APPLICATION_TL
               WHERE APPLICATION_ID =FPOV.LEVEL_VALUE),
             '10003',
             (SELECT RESPONSIBILITY_NAME
                FROM APPS.FND_RESPONSIBILITY_TL
               WHERE RESPONSIBILITY_ID =FPOV.LEVEL_VALUE),
             10004,
             (SELECT DESCRIPTION
                FROM APPS.FND_USER
               WHERE USER_ID = FPOV.LEVEL_VALUE),
             FPOV.LEVEL_ID) LEVEL_VALUE,
      FPOV.PROFILE_OPTION_VALUE,
      FPOV.LAST_UPDATE_DATE,
      FPO.SQL_VALIDATION,
      TRUNC(FPOV.LAST_UPDATE_DATE),
      (SELECT DESCRIPTION
         FROM APPS.FND_USER
        WHERE USER_ID = FPOV.LAST_UPDATED_BY)UPDATED_BY
 FROM APPS.FND_PROFILE_OPTIONS       FPO,
      APPS.FND_PROFILE_OPTION_VALUES FPOV,
      APPS.FND_PROFILE_OPTIONS_TL    FPOT
WHERE FPOV.PROFILE_OPTION_ID = FPO.PROFILE_OPTION_ID
  AND FPOT.PROFILE_OPTION_NAME =FPO.PROFILE_OPTION_NAME
  AND FPOV.LEVEL_VALUE =
      (SELECT USER_ID FROM FND_USER WHERE USER_NAMEIN ('305030341')) --for user
  /*AND (FPOV.LEVEL_ID = 10003 AND
      FPOV.LEVEL_VALUE IN
      (SELECT RESPONSIBILITY_ID
          FROM FND_RESPONSIBILITY_TL
         WHERE RESPONSIBILITY_NAME LIKE '%%')) --for responsibility*/
  /*AND UPPER(FPOT.USER_PROFILE_OPTION_NAME) LIKE '%WMS%TCP%' -- for profile option*/ 

Read More

Cost Groups in Oracle WMS are assigned by the Cost Group Rules Engine.
In Oracle Inventory, Cost Groups are derived based on the primary cost Method of the organization and the location where the material is being moved. If the costing method is Standard-Costing, then the Cost Group associated with subinventory is assigned to the material. For the other costing methods, the Cost Group associated with the organization is used.
In Oracle Warehouse Management, once a Cost Group is associated with a material, it does not change when the material is moved within the organization. 

In Oracle Inventory, the Cost Group associated with the material changes with the location where it is residing.
So in WMS, once the material moved with in the organization, then cost group update needs to be done if you want to change the cost group assigned to the material.

Lets understand this with below example

Example 1:

In your organization, you are dealing with FMCG products which has multiple variants.

You have edible and non edible products, creme, liquid and solid products and you are storing those across subinventories where multi variant products can be stored in same subinventory but you want to distinguish the costing reporting.

This canot be possible if you are using only Inventory, as the maximum level of cost group assignment will be at subinventory level.

If you are using WMS, this can be achieved by defining cost group assignment rules which can be assigned by considering many attributes like item type, supplier, customer and many more.

Example 2:

WMS Inventory Organization with the Average Costing Method

Transaction 1: Buy 100 units @ 10/unit from Supplier 1 in LOT A
Transaction 2: Buy 100 units @ 20/unit from Supplier 2 in LOT B
Transaction 3: Sell and Ship 100 units @ 30/unit to Customer 1 in LOT A
Transaction 4: Sell and Ship 100 units @ 30/unit to Customer 2 in LOT B

In this organization, LOT A’s 100 units would be received into inventory and averaged together (10/unit) and LOT B’s 100 units would be received into inventory and averaged together (20/unit) . Then when the items are shipped to the customer, LOT A would have an average cost of 10 and a higher margin than LOT B. The units from both projects could be indistinguishable and in the same physical location in the warehouse. But, in the system, they are tracked separately using the cost group.

Read More

If you want to change or customize the fields in the Mobile screen of MSCA for a specific transaction, then you need to follow below steps.

Check for the Form Function

Find out the function name

Check how the parameters are defined

Find the parameter what you are looking for

Check the value assigned for that parameter

As per the requirement change that 

Now in the transaction screen of MSCA, the required changes should display.

Check for the MWA Personalization

Find out the page name which is showing for this transaction

Go to the WMA Personalization function

Open the required page

Check for the field name

Edit and do the change as needed either in responsibility level or in Organization level

Save the changes.

Bounce the MSCA server.

Then see the changes

Read More