2 Replies Latest reply on Apr 27, 2013 6:09 PM by Hussein Sawwan-Oracle

    Interface trip stop is  completed with warning

    762518
      Dear All,

      ITS completed with warning status. below is log file for that ITS(debug). Need your support to solve this issue

      Regards,

      Shahed Hasan.

      ---------------------------------------------------------------------------
      Shipping Execution: Version : 11.5.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      WSHINTERFACES module: Interface Trip Stop - SRS
      ---------------------------------------------------------------------------

      Current system time is 27-APR-2013 16:10:54

      ---------------------------------------------------------------------------

      **Starts**27-APR-2013 16:10:54
      **Ends**27-APR-2013 16:10:55
      Interface trip stop is completed with warning
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      Starting WSH Debugger ==> 04/27/2013 04:10:54 PM,Session ID=62435058
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      P_MODE ==> ALL
      P_STOP_ID ==> 3101179
      P_DELIVERY_ID ==> is NULL
      P_LOG_LEVEL ==> 1
      p_organization_id ==> is NULL
      p_num_requests ==> 1
      p_stops_per_batch ==> 1
      l_req_data ==>
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      P_MODE ==> ALL
      P_STOP_ID ==> 3101179
      P_DELIVERY_ID ==> is NULL
      P_LOG_LEVEL ==> 1
      p_organization_id ==> is NULL
      p_stops_per_batch ==> 1
      InterfaceTripStop: processing stop_id 3101179 for INV OM DSNO
      l_inv_interface ==> 1
      l_om_interface ==> 1
      l_dsno_interface ==> 1
      l_interface_mode ==> INV OM DSNO
      l_stop_id ==> 3101179
      setting savepoint before_flag_change ==>
      locking row for 3101179 ==>
      updating pending_interface_flag to P for batch ==> 2284503
      ========================================================================
      Entering WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      OM INTERFACING BATCH 2284503
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      l_check_bulk ==>
      All lines are bulk enabled
      Rows insert into l_bulk_ship_line ==> 0
      l_non_bulk_ship_line.line_id.count ==> 0
      l_non_bulk_req_line.line_id.count ==> 0
      l_bulk_ship_line.line_id.count ==> 0
      l_bulk_req_line.line_id.count ==> 0
      l_num_om_api_call ==> 0
      l_num_om_errors ==> 0
      l_num_om_warnings ==> 0
      l_non_bulk_count ==> 0
      l_num_errors ==> 0
      l_num_warnings ==> 0
      x_return_status ==> S
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM (04/27/2013 04:10:55 PM, .1 seconds)
      Interface_Stop_To_OM l_return_status ==> S
      Calling TRANSFER_SERIAL_NUMBERS FOR 2284503
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      p_interfacing ==> OM
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_transfer_param ==> MSNT
      p_batch_id ==> 2284503
      p_interfacing ==> OM
      Numbers of rows inserted into wsh_serial_numbers: 0, Number of rows deleted from mtl_serial_numbers_temp: 0, Number of rows updated in wsh_delivery_details: 0 ==>
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (04/27/2013 04:10:55 PM, 0 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_transfer_param ==> WDD
      p_batch_id ==> 2284503
      p_interfacing ==> OM
      Numbers of rows inserted into wsh_serial_numbers: 0, Number of rows deleted from mtl_serial_numbers_temp: 0, Number of rows updated in wsh_delivery_details: 0 ==>
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (04/27/2013 04:10:55 PM, .01 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (04/27/2013 04:10:55 PM, .01 seconds)
      x_completion_status ==> INTERFACED
      Exiting WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (04/27/2013 04:10:55 PM, .11 seconds)
      INTERFACETRIPSTOP: RESULT OF OM INTERFACING BATCH_ID 2284503 = INTERFACED
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_num_stops ==> 1
      p_batch_id ==> is NULL
      X_MASTER_STATUS ==> NORMAL
      P_API_STATUS ==> INTERFACED
      X_NORMAL_COUNT ==> 0
      X_WARNING_COUNT ==> 0
      X_INTERFACED_COUNT ==> 0
      X_MASTER_STATUS ==> NORMAL
      P_API_STATUS ==> INTERFACED
      X_NORMAL_COUNT ==> 0
      X_WARNING_COUNT ==> 0
      X_INTERFACED_COUNT ==> 1
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (04/27/2013 04:10:55 PM, 0 seconds)
      l_api_completion_status ==> INTERFACED
      l_previous_interface ==> TRUE
      l_dsno_stop_tab.COUNT ==> 1
      ------------------------------------------------------------------------
      Calling program unit WSH_DSNO.SUBMIT_TRIP_STOP
      Entering WSH_DSNO.SUBMIT_TRIP_STOP (WSHDSNOB.pls 115.30) (04/27/2013 04:10:55 PM)
      P_TRIP_STOP_ID ==> 3101179
      PROCESSING DSNO IN TRIP STOP 3101179
      RLM INSTALLED: YES
      Calling program unit RLM_TPA_SV.UPDATECUMKEY
      CHECKING EDI INSTALLATION STATUS
      EDI INSTALLED: YES
      DSNO PROFILE: DISABLED
      TERMINATING PROGRAM
      Exiting WSH_DSNO.SUBMIT_TRIP_STOP (04/27/2013 04:10:55 PM, .08 seconds)
      INTERFACETRIPSTOP: RESULT OF DSNO SUBMISSION FOR STOP_ID 3101179 = NORMAL
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_num_stops ==> 1
      p_batch_id ==> is NULL
      X_MASTER_STATUS ==> NORMAL
      P_API_STATUS ==> NORMAL
      X_NORMAL_COUNT ==> 0
      X_WARNING_COUNT ==> 0
      X_INTERFACED_COUNT ==> 0
      X_MASTER_STATUS ==> NORMAL
      P_API_STATUS ==> NORMAL
      X_NORMAL_COUNT ==> 1
      X_WARNING_COUNT ==> 0
      X_INTERFACED_COUNT ==> 0
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (04/27/2013 04:10:55 PM, 0 seconds)
      l_api_completion_status ==> INTERFACED
      l_previous_interface ==> TRUE
      ------------------------------------------------------------------------
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      Entering WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      flag ==> TRUE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (04/27/2013 04:10:55 PM, 0 seconds)
      Calling TRANSFER_SERIAL_NUMBERS FOR BATCH 2284503
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      p_interfacing ==> INV
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_transfer_param ==> MSNT
      p_batch_id ==> 2284503
      p_interfacing ==> INV
      Numbers of rows inserted into wsh_serial_numbers: 0, Number of rows deleted from mtl_serial_numbers_temp: 0, Number of rows updated in wsh_delivery_details: 0 ==>
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (04/27/2013 04:10:55 PM, .01 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_transfer_param ==> WDD
      p_batch_id ==> 2284503
      p_interfacing ==> INV
      Numbers of rows inserted into wsh_serial_numbers: 0, Number of rows deleted from mtl_serial_numbers_temp: 0, Number of rows updated in wsh_delivery_details: 0 ==>
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (04/27/2013 04:10:55 PM, 0 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (04/27/2013 04:10:55 PM, .01 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      NUMBER OF ROWS UPDATED AS INTERFACED TO INVENTORY = 0
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (04/27/2013 04:10:55 PM, 0 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (04/27/2013 04:10:55 PM, 0 seconds)
      NEW TRANSACTION_HEADER : 53228513
      Number of records fetched by l_get_picking_ln_id_csr is ==> 5
      No. existing record updated in MTI ==> 0
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      batch_id ==> 2284503
      P_TRANSACTION_HEADER_ID ==> 53228513
      No of record fetch ==> 0
      l_bulk_batch_size ==> is NULL
      l_def_inv_online ==>
      No Delivery Detail Found
      No Delivery Detail Found ==> is NULL
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (04/27/2013 04:10:55 PM, .01 seconds)
      Interface_Detail_To_Inv l_inv_inter_status ==> S
      Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 115.120.11510.12) (04/27/2013 04:10:55 PM)
      P_MESSAGE_TYPE ==> W
      P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP
      msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
      W:Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
      Exiting WSH_UTIL_CORE.ADD_MESSAGE (04/27/2013 04:10:55 PM, .03 seconds)
      l_completion_status ==> NORMAL
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (04/27/2013 04:10:55 PM, .09 seconds)
      INTERFACETRIPSTOP: RESULT OF INVENTORY INTERFACING BATCH_ID 2284503 = WARNING
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_num_stops ==> is NULL
      p_batch_id ==> 2284503
      X_MASTER_STATUS ==> NORMAL
      P_API_STATUS ==> WARNING
      X_NORMAL_COUNT ==> 0
      X_WARNING_COUNT ==> 0
      X_INTERFACED_COUNT ==> 0
      l_stops_in_batch ==> 1
      X_MASTER_STATUS ==> WARNING
      P_API_STATUS ==> WARNING
      X_NORMAL_COUNT ==> 0
      X_WARNING_COUNT ==> 1
      X_INTERFACED_COUNT ==> 0
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (04/27/2013 04:10:55 PM, 0 seconds)
      re-lock stop to set pending_interface_flag to Y or NULL ==>
      Entering WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (04/27/2013 04:10:55 PM)
      p_batch_id ==> 2284503
      flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (04/27/2013 04:10:55 PM, 0 seconds)
      Return False ==>
      Exiting WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED (04/27/2013 04:10:55 PM, 0 seconds)
      ========================================================================
      l_stops_count ==> 1
      InterfaceTripStop: total stops processed: 1
      Stops processed for ORDER MANAGEMENT with status NORMAL: 0
      Stops processed for ORDER MANAGEMENT with status WARNING: 0
      Stops interfaced for ORDER MANAGEMENT: 1
      Stops processed for ORDER MANAGEMENT with status NORMAL: 0 ==>
      Stops processed for ORDER MANAGEMENT with status WARNING: 0 ==>
      Stops interfaced for ORDER MANAGEMENT: 1 ==>
      Stops processed for DSNO with status NORMAL: 1
      Stops processed for DSNO with status WARNING: 0
      Stops interfaced for DSNO: 0
      Stops processed for DSNO with status NORMAL: 1 ==>
      Stops processed for DSNO with status WARNING: 0 ==>
      Stops interfaced for DSNO: 0 ==>
      Stops processed for INVENTORY with status NORMAL: 0
      Stops processed for INVENTORY with status WARNING: 1
      Stops interfaced for INVENTORY: 0
      Stops processed for INVENTORY with status NORMAL: 0 ==>
      Stops processed for INVENTORY with status WARNING: 1 ==>
      Stops interfaced for INVENTORY: 0 ==>
      errbuf ==> Interface trip stop is completed with warning
      retcode ==> 1
      l_completion_status ==> WARNING
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL (04/27/2013 04:10:55 PM, .33 seconds)
      Automatic clean up ==>
      l_recs = 0 ==>
      errbuf ==> Interface trip stop is completed with warning
      retcode ==> 1
      l_completion_status ==> NORMAL
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP (04/27/2013 04:10:55 PM, .63 seconds)
      ************Summary of Shipping API Calls************
      WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP : 1 calls : .63 seconds
      WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL : 1 calls : .33 seconds
      WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP : 1 calls : .11 seconds
      WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM : 1 calls : .1 seconds
      WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS : 2 calls : .02 seconds
      WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT : 4 calls : .02 seconds
      WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS : 3 calls : 0 seconds
      WSH_DSNO.SUBMIT_TRIP_STOP : 1 calls : .08 seconds
      WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP : 1 calls : .09 seconds
      WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED : 1 calls : 0 seconds
      WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS : 1 calls : 0 seconds
      WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED : 2 calls : 0 seconds
      WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV : 1 calls : .01 seconds
      WSH_UTIL_CORE.ADD_MESSAGE : 1 calls : .03 seconds
      WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED : 1 calls : 0 seconds
      *****************************************************
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 27-APR-2013 16:10:55

      ---------------------------------------------------------------------------

      Edited by: shahed hasan on Apr 27, 2013 3:30 AM
        • 1. Re: Interface trip stop is  completed with warning
          Srini Chavali-Oracle
          >
          msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
          W:Inventory Interface could not process some of the lines in the batch as they are in error status. Please query the lines using the Inventory Interface UI to correct the errors.
          >

          Have you looked at the proposed solution in this MOS Doc ?

          Interface Trip Stop Fails With Inventory Interface Could not Process Some of the Lines in the Batch as they are in Error Status [ID 1300170.1]

          If this doc does not help, pl log an SR with SUpport

          HTH
          Srini
          • 2. Re: Interface trip stop is  completed with warning
            Hussein Sawwan-Oracle
            Please see if the following docs help.

            FAQ: Troubleshooting Stuck Pick Release and Shipping Transactions [ID 863761.1]
            ITS Completing In Warning "For this Transaction Row the Serial Records are Missing" when using API for processing Pick Release, Allocation and Pick Confirm [ID 1539623.1]
            Deliveries Are Not Getting Interfaced with Negative Balances not Allowed Error [ID 1292669.1]
            Interface Trip Stop Fails Due to Restricted Subinventories [ID 1081367.1]

            Thanks,
            Hussein