Search 800 + Posts

Jun 24, 2009

Key Features of Interface Trip Stop Process (ITS) in Order Management

In Oracle Order Management, Interface Trip Stop (ITS) will be trigger at the time of Shipping if check box “Defer Interface” is not check.
ITS can also be executed from concurrent request.

ITS has to main components.
Update the Order Management Data (oe_order_lines_all) .
Trigger the Inventory Interface (to Update the Inventory tables).


Inventory Interface will be trigger only if the first part, that means related to OM has successfully completed and flag OE_INTERFACED_FLAG = ‘Y’ on WSH_DELIVERY_DETAILS.If value of this flag is N/P then Inventory Interface will never be triggered. And even if you try to submit the Inventory Interface from SRS, delivery detail with oe_interfaced_flag =’N’ will never be picked up.

ITS update the following fields on oe_order_lines_all table
1.Shipped_quantity
2.shipping_quantity,
3.Actual_shipment_date.

Above is just simple input about basic process for ITS , apart from it other feature of OTS are
1.Line spliting .
2.Progress the Order line to FULFILL Deferr Status (depend on your workflow).

Please Note that if you are sharing trip/delivery across the Orders then ITS will progress all the orders that belongs to Trip/Delilvery.

For Common errors that occure during ITS , refere my blogs
http://eoracleapps.blogspot.com/2009/10/3133-activity-instance-fulfillline-is.html

And

http://eoracleapps.blogspot.com/2009/10/its-error-wf-completeactivity-error-ora.html

you can leave your comments , if you have question.

9 comments:

  1. Very detailed explanation. Thank you for sharing this information. It was helpful for me when i was preparing for my interview.

    Thanks
    IK

    ReplyDelete
  2. Hi,

    i wanted to know how to perform following process.
    I have one sales order whose lines status in shipping transaction is shipped and next step is Run Interface.
    When i am running the interface the program is generating warning and the shipping status remain same as of previous. No change,

    Than i checked the table and found out that OE_INTERFACED_FLAG = ‘N'.

    So how to proceed in this case.

    Do needful

    ReplyDelete
  3. With OE_INTERFACED_FLAG = ‘N' and no Changes in Order line workflow or quantity that means ITS is not executed successfully. Look into the Log file of ITS concurrent Program and see if there is any error that results in ITS completed with warning.

    ReplyDelete
  4. Hi,

    There is any error table for interface trip stop.because same problem i am facing. OE_INTERFACED_FLAG = ‘N' after completion the program.

    Please do needful.

    Thanks
    Vishal

    ReplyDelete
  5. Hey Vishal

    No we don't have any Error table for ITS , all the errors can be captured in the Log file if required ( by enabling the debug level = 5).


    ReplyDelete
  6. This is not related to question ask by Vishal , but thought of adding it .

    All the Exception that we can see in the Shipping transaction form are stored in wsh_exceptions database table.

    To see an open exception we can execute
    SELECT distinct exception_name
    FROM wsh_exceptions
    WHERE status <> 'CLOSED'

    ReplyDelete
  7. Hey, What's up, I'm Shivani. I'm an application developer living in Noida, INDIA. I am a fan of technology. I'm also interested in programming and web development. You can download my app with a click on the link.
    Best astrology app
    Astro guru tips
    Astro guru tips
    Free horoscope
    Best astrology app for android
    Hindi astrology app
    Best kundli app
    Astrology app in hindi
    Kundli app

    ReplyDelete
  8. Thanks for this info, I was not sure about Augmented Reality App development, but now I am clear about it. I have a best team of AR game developers and share it with my connection. I am not too keen on making money and develop ar software. I am enjoying just writing. Thanks once again.

    ReplyDelete
  9. Astogurutips is the top best Online Astrology website in India with more than 500+ astrologer on the portal. He gives a Best Astrology solutions from the Best Astrologers . You can connect with our astrologer through call or chat and ask you any question about your carrier, health, future, love partner etc. Free astrology service on phone

    ReplyDelete