Skip to main content

Interface Trip Stop


In the processing of the sales order after Shipping Execution ships the delivery, Shipping module needs to interface the information back to Oracle Order Management and Oracle Inventory Management Modules also. This is done via the Interface Trips Stop Concurrent Program.   OM Interface occurs first,  then Inventory Interface

You can also run Interfaces Individually for Order Management and Inventory.  However, the system will not allow you to run Inventory Interface until Order Management has completed successfully.

The Delivery Detail status becomes Staged/Picked after Pick Release is successful.
Thereafter when you ship confirm the delivery to which this Delivery Detail  belongs,  there are the following cases that could happen:

Case 1:
======

If you ship confirm the delivery and do not run the interface (you Checked the Defer Interface Flag in the Confirm Delivery window before ship confirm), the delivery detail status would become "Shipped". This signifies that the shipment has left the Warehouse and therefore the Delivery Detail status become "Shipped".  However, the data is still not interfaced to OM and Inventory;  which means that information such has quantity shipped is not reflected in inventory on-hand and transactable quantities for the item in question.  If delivery details exist in this status,  shipping transactions have not completed (there are unprocessed shipping transactions),  and you will not be able to close the current month inventory period until the interfacing is performed.

Case 2:
=======

If you ship confirm the delivery and RUN the interface (you did NOT Check the Defer Interface Flag in the confirm delivery window), the delivery detail status would become "Interfaced". This signifies that not only has the shipment has left the Warehouse,  but also the data related to the delivery has been interfaced to Order Management and Inventory.

Note:
Please note that the Delivery Detail status will remain "Shipped" till both Order Management Interface and Inventory Interface have completed successfully. Even with Order Management Interface completed successfully and Inventory Interface Pending, the Delivery Detail status will remain as "Shipped"
The significance of the new RELEASE_STATUS is that it lets the users know whether the delivery details has been interfaced to Order Management and Inventory or not .





What is the ship confirm process of move a sales order issue to inventory?

For a SO Issue, the trip stop program (WSHINTERFACE) inserts the record into the open interface with a transaction mode of 3- Background but the trip stop remembers the transaction id and continues to process it through to completion using an online transaction process routine unless you use the profile option WSH: Defer Inventory Process Online as noted below.  The flow is something like this:

STEP 1: Create book and pick an order
STEP 2: Run the Ship Confirm.
STEP 3: within the ship confirm process, order management runs the trip stop program.
STEP 4: The trip stop program inserts into the transaction open interface
STEP 5: The trip stop processes the transaction and runs the inventory transaction manager.

Here are some more details about routines being called while these steps are executed:
STEP 1: Create book and pick an order
STEP 2: Run the Ship Confirm.
STEP 3: within the ship confirm process, order management runs the trip stop program.
Trip Stop (WSH_SHIP_CONFIRM_ACTIONS.interface_all)
om_Interface_Trip_Stop
Inv_Interface_Trip_Stop
Interface_Delivery_to_Inv
interface_detail_to_inv
wsh_trx_handler.insert_row
STEP 4: The trip stop program inserts into the transaction open interface
insert into mtl_transactions_interface
STEP 5: The trip stop processes the transaction and runs the inventory transaction manager.
Inv_Interface_Trip_Stop (We were already here from step 2c. Now we continue.)
process_inv_online
mtl_online_transaction_pub.process_online
Locks the interface transaction
inv_txn_manager_pub.process_Transactions -- This routine does all the validation.



You can set up and run Interface Trip Stop - SRS by the following navigation path:
1.OM Super User Responsibility-->Shipping-->Interfaces-->Run-->
2.Select Interface Trip Stop - SRS from the Name field
3.Set the Mode to All and keep all parameter as defaulted value is recommended.
4.Click OK
5. If you want to run it periodically, click on the Schedule button.
On the Schedule window you can set this job to be run:
 a) As soon as Possible
  b) Once
  c) Periodically
  d) On specific days

Issue:Failure to regularly gather schema statistics will place unwanted additional
processing loads on application jobs and concurrent programs
. Frequent house-keeping and refreshing of schema
statistics will ensure all meta-data for application process is current and
timely.

Solution

1. As "Sys Administrator" responsibility
2. Run Reports
3. Select "Gather Schema Statistics"
4. Enter required parameters, including WSH and INV schema names.



ISSUE:The Interface Trip Stop process does not launch automatically when pick confirming sales orders through a custom concurrent program.

How do I get the Interface Trip Stop to run automatically when Ship Confirming ?

Solution:

This behavior is controlled by the - Defer Interface - Attribute in the Shipping parameters or Global Parameters setup in Shipping.

To check the Ship Confirm Rule setup:

Navigate to Shipping --> Setup --> Ship Confirm Rules.
NB - you need to confirm that you are in the correct shipping organization when doing the following
Search for the Ship Confirm Rule that you are using then view the following attributes:

Set Delivery In-Transit
Close Trip
Defer Interface --- this should be deselected

To check the Global Parameters setup:

Navigate to Shipping --> Setup --> Global Parameters

View the - Defer Interface - attribute --- this should be deselected.








Labels:

Comments

  1. UnknownMay 20, 2014 at 1:14 AM

    I had made a sales order for a particular item, in inventory the quantity was 50pcs. When i made the sales order for that item with the quantity of 70 with more 20pcs extra as per my available stock and the sales order was completed and also i had made of that same sales order with same 70 quantity, that return sales order was also completed, so as per my oracle inventory item it's showing 20 extra pcs but in the store it has 50 pcs.

    So advice what i have to do now

    ReplyDelete
  2. HG MEDIANovember 26, 2015 at 3:02 AM

    Thank You

    ReplyDelete

Post a Comment

Popular posts from this blog

Difference Between MTS, ATO, MTO ,PTO ,CTO and ETO.

 Make-to-stock (MTS) In MTS environments, products are created before receipt of a customer order. Customer orders are then filled from existing stock, and then those stocks are replenished through production orders. MTS environments have the advantage of decoupling manufacturing processes from customer orders. Theoretically, this enables customer orders to be filled immediately from readily available stock. It also allows the manufacturer to organize production in ways that minimize costly changeovers and other disruptions. However, there are risks associated with placing finished goods into inventory without having a firm customer order or an established need. These risks tend to limit MTS environments to simple, low-variety, or commodity products whose demand can be forecasted readily.  Assemble-to-order (ATO) In ATO environments, products are assembled from components after the receipt of a customer order. The key components in the assembly or f...
Post a Comment
Read more

Accounting entries in Oracle Purchasing and Payables

This document gives in detail different accounts used and the accounting impact of various transactions that take place in Oracle Purchasing and Oracle Payables. Both Standard costing and Average costing methods are considered. The accounts are Oracle Applications specific and might differ from the conventional accounting names. Examples are given wherever required for better understanding of the concept. The sources of these accounts are given. PURCHASING:  Receiving – For Accrual Process for perpetual Accruals Receipts for inventory purchases are always accrued upon receipt. And also use perpetual accruals for expense purchases you want to record uninvoiced purchase liabilities immediately upon the receipt of the expense goods. Receiving Account (Receiving Account) To record the current balance of the material in receiving and inspection. Where to define in Apps: Define Organization           ...
Post a Comment
Read more

Scheduling ,Reservations and ATP in Oracle Order management

Before we start understanding scheduling we need to know certain terms and how they are derived in Oracle. Terminology Understanding the following terms will help you understand how scheduling works in OM. Actual Arrival Date - The date the order line arrives at the customer site. Actual Ship Date - The date the order line is shipped. This date is recorded by the ship confirm action. Arrival Set - A set of order lines which arrive at the same time at the destination. Available to Promise (ATP) - The quantity of current on-hand stock, outstanding receipts and planned production not already committed to sales orders or other sources of demand. ATP Date - The date that a requested quantity will be available to promise. Delivery Lead Time - Time (in days) for items to reach the customer once they are shipped. There are two ways to help system calculate this date. 1) Create a location for the Ship-to address and assign it as the internal location and then define...
1 comment
Read more