Search from 700 + Posts

Nov 17, 2009

Interface Trip Stop (ITS) in Order Management

Interface Trip Stop - Interface Trip stop plays very critical part in Oracle Order management application.
It is concurrent program that you can triggered from Interface > Submit Request . Interface Trip Stop.
Or you can also trigger this concurrent program at the time of ship confirm by uncheck the ?Defer Interface? checkbox. By Default this check box is uncheck only.

Interface trip stop has 2 parts
1.It process the data related to Order Management.
2.It Process data related to Inventory.(and we have separate CP for this too ?Inventory Interface?).

In First part it make update on oe_order_lines_all table as well as wsh-delivery_details and once this part executed successfully only then SECOND phase of ITS has triggered. If FIRST part error out for some reason then 2nd part will not be triggered, and even if you try to submit ?Inventory Interface?, it will not pick up you data. Reason ? it will validate and check if oe_interfaced_flag in wsh_delivery_details table is Y or not. If it is N or X ?inventory Interface? will not pick that record for processing.

I have observed that in most of time user submit the interface trip stop while doing the ship confirm, but there are considerable cases when customer preferred to run this as a scheduled process without specifying the delivery# or Trip #, because their volume of order processing is very high and they want to run this process during some particular time of the day.

Please make a note that unless this process execute, workflow for Order line is remain at SHIP_LINE Notified and will not progress to Fulfill and finally Invoicing .So while deciding when to trigger this program you have to make sure that when you want to Invoice customer.

One piece of advice that I will give here is, Never try to stop execution of this program, unless you have a very valid reason. Any halt in ITS will result in piling of data in SHIP_LLINE notified workflow status and once you start executing again after a stop it will take a deep dive in terms of your performance.

27 comments:

  1. Hi,
    Can you explain to me the difference between cheking the "Defer Interface" Checkbox at the Quick Ship Process or not.?

    ReplyDelete
  2. Hi! Anonymous

    As I have explained in blog , if you check the "Defer Interface" checkbox system will submit the concurrent program "Interface Trip Stop" automatically for the particular delivery/trip (delivery in Quick Ship Form) after the completion of Ship Confirm process. But If you don't Check it , System will not submit "Interface Trip Stop" for the Delivery /trip.

    Hope that helps.

    ReplyDelete
  3. to get additional info mail me or search "Defere Interface" on my blog .

    ReplyDelete
  4. Hello,

    Can you please explain the reason ...even the ITS is completed successfully we are seeing the WF line satus is SHIP_LINE how can we close this line now?

    Thanks,

    ReplyDelete
  5. I posted answer in my Post

    Even the ITS is completed successfully we are seeing the WF line status is SHIP_LINE how can we close this line now?

    ReplyDelete
  6. hi eoracleapps,

    the oe_interface_flag was Y for the ship lines which on SHIPPED Status.

    is there a means to trigger update of the invetory table. i cannot locate related material transactions for the order lines in the SO which has the problem.

    Thanks.

    Regards,
    Rommel

    ReplyDelete
  7. Run Inventory Interface for the Trip in order to release the reservation.

    ReplyDelete
  8. We use automated carrier manifesting and seeded ship confirm close the deliveries with last_updated_dy as a random application user and Interface trip stop is being submitted by random application user. any help

    ReplyDelete
  9. Hi!

    Your question is not clear , can you please give me some more details and I would try to answer.

    ReplyDelete
  10. defer means to stop or to halt. When we check it,ITS will not fire.

    ReplyDelete
  11. Defer means do not run ITS , so while doing Ship confirm , if you check "Defer Interface" , system will not trigger ITS concurrent program for the Deliveries that you are shipping. So you need to run ITS concurrent program Manually( by passing delivery or Trip name) OR run it as a scheduled job with Trip and delivery parameter as NULL.

    Hope that helps

    ReplyDelete
  12. Hi,

    Please guide me what i need to do?

    Our client has below functionality

    1) sales order are created in Oracle apps
    2) inventory stock is maintianed in legacy system1
    3) he performs shipping in legacey system2

    When legacy sytem do the shipping it will send a message to Ebs so that here we need to create invoices for that sales order

    The problem is, in the work flow we are using standard workflow activity 'Invoice interface line'.

    std activity won't perform invoicing unless we run the 'Interface trip stop' but if we run 'ITS' it will be errored out coz we are not maintaining the stock in oracle inventory.
    so how we deal this? can't we creat the invoices using the std workflow activity 'Invoice interface line'.?

    Please suggest how we can create invoices for sales orders without running the "ITS'

    ReplyDelete
  13. give me a day and will get back to you on this

    ReplyDelete
  14. think of using a different workflow say 'invoice only'

    ReplyDelete
  15. HELLO,
    I had seen that in wsh_delivery_details oe_interfaced_flag is 'Y' and inv_interfaced_flag is 'Y' for ITS completed normally.
    While their is another case occured when i ITS completed with warning and
    oe_interfaced_flag is 'Y' and inv_interfaced_flag is 'P' . what might be the reason for that??

    ReplyDelete
  16. That clearly indicates that their is issue with Inventory Interface , and status "P" indicate that Inventory Interface is not completed and in PENDING status. Look into the log file for ITS for error message.
    In case you are not able to locate the log file for ITS, then run the "Inventory Interface " concurrent program again and if that still ends with warning , check the log file for the error message.

    ReplyDelete
  17. hello,

    As per teh definition it has two parts. In first it updates the OE data ie., it updates the shipped,shippable quantity and in second part it updates the Inv data. Can u pls let me know what exactly it does in Inventory? Is it updating the information related to quantity or what columns is it going to affect in Inventory. Pls let me know about it.

    Thanks a lot in advance.
    Vijay

    ReplyDelete
  18. In Inventory Interface it will Release the reservation , plus decrement the stock ...I am not very sure about the tables and columns it update , but will try to look (but not sure when).

    Regards
    eo

    ReplyDelete
  19. Hi, We are facing a very strange problem.
    Interface Trip stop is resulting in locking of tables, We have tried to trouble shoot but we are not able to find the reason.

    Can you please guide us, How to trouble shoot.
    Regards,
    Micky

    ReplyDelete
    Replies
    1. can you let me know what table it is locking , and do you have any custom triggers on Oracle Std table or any customization around ITS process..

      Usually if ITS is not able to take lock on Order line table it mark the workflow as DEFERRED.

      Delete
  20. Hye!

    could you tell me ITS program update mtl_material_transaction table

    ReplyDelete
  21. facing the problem while generating the invoice, while doing the ship confirm its showing. Showing as SHIP CONFIRM/ CLOSED TRIP STOP. Kindly give a solution on the same.

    ReplyDelete
  22. I am more than happy to assist you , but I would like to know the following details

    at what activity the workflow is .
    What is the value of oe_interfaced_flag/inv_interfaced_flag
    is Shipped and shipping qty populated in lines.

    Let me know about above

    ReplyDelete
  23. Hi,
    Interface Trip Stop - SRS not completing, It's in running mode since long time.
    any possible causes & solution for it, please?

    Regards,
    Bilal

    ReplyDelete
  24. Hi ,

    I am sorry for starting again this thread, but i have an sales ordre which got shipped and closed but the oe_interfaced_flag in wsh_delivery_details is still as 'N' and shipped_quantity is null, when we are running interface trip stop program it is completed with warning.

    So could you guide me here like is it possible to run the interface trip stop and populate 'Y' in OE_INTERFACED_FLAG or Data fix only will work.

    ReplyDelete
  25. Hi ,

    I am sorry for starting again this thread, but i have an sales ordre which got shipped and closed but the oe_interfaced_flag in wsh_delivery_details is still as 'N' and shipped_quantity is null, when we are running interface trip stop program it is completed with warning.

    So could you guide me here like is it possible to run the interface trip stop and populate 'Y' in OE_INTERFACED_FLAG or Data fix only will work.

    ReplyDelete
  26. Hi Rajesh

    Data fix is an simple and easy options and Oracle usually provide these kind of data fixes ( I hope you don't have line split case here , because if it is line split issue which happens after ITS then i don't think they give you data fix).
    But in case you don;t want to take data-fix route then my suggestions are enable OM and WSH debug and run the ITS and look into the log file , I am sure log fil print why it is errors out with Warning.

    If you make the OE_INTERFACED_FLAG = Y and try to run ITS then ITS will not pick that record , because a value of Y mean ITS has already executed that delivery detail .

    Hope that helps

    ReplyDelete