Search from 700 + Posts

Feb 18, 2010

Order line Bill only

In this post I will discuss little about the workflow process "Bill only with Inventory interface".

Suppose we have requirement to Bill customer for good that we sold him , but their is no Shipping Involves.
Example I step inWalmart and bought some stuff , paid for that and then carry it along with ourself in Car.

Now to handel these types og flow we have 2 flow exits in Order Management
1.Bill Only
2.Bill Only with the Inventory Interface.

But let's say if we use "Bill Only " then we will not be able to do Reservation , but In case we need to do Reservation , we should use "Bill Only with the Inventory Interface".

In this flow when user Book the sales order,  Header workflow proceed to booking atctivity and then Start theh line flow . In line flow there is activity Inventory interface , this activity validate the line data and if Reservation Quantity > 0 , It call the INV APIs and populate the MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTIONS_INTERFACE
Workflow then proceed to the fulfill and Invoicing activity.But fulfill and Invoiving will not Release the Inventory .To release the reservation we need to run the interface manager  and on sucessful execution it will release the reservation.

Reason for writing this post is , Recently one of my Customer implemented this flow and they end up with lots of orde lines stuck with  Reservation not released , and on the other hand order line is already close and workflow also closed..
So whenever you Implement this flow make sure you run the interface manager.

Thanks

6 comments:

  1. To release the reservation we need to run the interface manager and on sucessful execution it will release the reservation.

    Reason for writing this post is , Recently one of my Customer implemented this flow and they end up with lots of orde lines stuck with Reservation not released , and on the other hand order line is already close and workflow also closed..
    So whenever you Implement this flow make sure you run the interface manager.



    thank you for this helpful post. how do we run the interface manager because we are getting stuck lines in the reservations interface?

    ReplyDelete
  2. So whenever you Implement this flow make sure you run the interface manager.

    how do we run this manager?

    ReplyDelete
  3. When I say run the interface manager , I mean for the Order line with the workflow "Bill Only with the Inventory Interface."

    Interface Manager means "Inventory Interface"

    Navigation > Shipping > Interface > Run
    and then select "Inventory Interface".

    ReplyDelete
  4. Navigation > Shipping > Interface > Run
    and then select "Inventory Interface".


    when i try do do this i get two options:
    Inventory Interface SRS
    when i select this i am prompted to enter a "Trip Stop" which is blank so i cannot run this interface. What do you suggest? thanks :)

    ReplyDelete
  5. Navigation > Shipping > Interface > Run
    and then select "Inventory Interface".


    when i try do do this i get two options:
    Inventory Interface SRS
    when i select this i am prompted to enter a "Trip Stop" which is blank so i cannot run this interface. what do you suggest? thanks :)

    ReplyDelete
  6. If There is no value for Trip that means there is No pending trip.

    Can you please check the value for INV_INTERFACED_FLG in wsh_delivery_details table , if that is N that means you need to run Inventory Interface , But if it is Y thean means some other problem or data corruption .

    NOTE - just want to confirm that we are talking "Bill Only with Inventory Intarface", flow Only.

    If Inventory reservation still not released either open a SR with Oracle , Or browse metalink, I guess there are few notes that explains how to release reservation.

    ReplyDelete