OM 模块销售的时候发运数量大于请求数量，OM被卡在库存借口怎么处理

sse_zero

上面是销售的情况。下一步的状况是'运行接口'
下面是运行连接停靠站的情况

下面是日志
剩下的我就不知道怎么弄了
**Starts**16-11-2010 14:21:22
**Ends**16-11-2010 14:21:23
Interface trip stop is  completed with warning
+---------------------------------------------------------------------------+
FND_FILE 中日志消息开始
+---------------------------------------------------------------------------+
Starting WSH Debugger ==> 11/16/2010 02:21:01 PM,Session ID=13306675
Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
  P_MODE ==> ALL
  P_STOP_ID ==> 1551553
  P_DELIVERY_ID ==> 1783633
  P_LOG_LEVEL ==> 1
  p_organization_id ==> 235
  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) (11/16/2010 02:21:01 PM)
    P_MODE ==> ALL
    P_STOP_ID ==> 1551553
    P_DELIVERY_ID ==> 1783633
    P_LOG_LEVEL ==> 1
    p_organization_id ==> 235
    p_stops_per_batch ==> 1
    INTERFACETRIPSTOP: FINDING STOP FOR DELIVERY_ID 1783633
    l_stop_id ==> 1551553
InterfaceTripStop: processing stop_id 1551553 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 ==> 1551553
    setting savepoint before_flag_change ==>
    locking row for 1551553 ==>
    updating pending_interface_flag to P for batch ==> 614304
    ========================================================================
    Entering WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
      p_batch_id ==> 614304
      OM INTERFACING BATCH 614304
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
        l_check_bulk ==> X
        All lines are NOT bulk enable
        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 (11/16/2010 02:21:01 PM,  .01 seconds)
      Interface_Stop_To_OM l_return_status ==> S
      Calling TRANSFER_SERIAL_NUMBERS FOR 614304
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
        p_interfacing ==> OM
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
          p_transfer_param ==> MSNT
          p_batch_id ==> 614304
          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 (11/16/2010 02:21:01 PM,  0 seconds)
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
          p_transfer_param ==> WDD
          p_batch_id ==> 614304
          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 (11/16/2010 02:21:01 PM,  0 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (11/16/2010 02:21:01 PM,  0 seconds)
      x_completion_status ==> INTERFACED
    Exiting WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (11/16/2010 02:21:01 PM,  .01 seconds)
    INTERFACETRIPSTOP: RESULT OF OM INTERFACING BATCH_ID 614304 = INTERFACED
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 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 (11/16/2010 02:21:01 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.11510.2) (11/16/2010 02:21:01 PM)
      P_TRIP_STOP_ID ==> 1551553
      PROCESSING DSNO IN TRIP STOP 1551553
      CHECKING EDI INSTALLATION STATUS
      EDI INSTALLED: YES
      DSNO PROFILE: DISABLED
      TERMINATING PROGRAM
    Exiting WSH_DSNO.SUBMIT_TRIP_STOP (11/16/2010 02:21:01 PM,  .03 seconds)
    INTERFACETRIPSTOP: RESULT OF DSNO SUBMISSION FOR STOP_ID 1551553 = NORMAL
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 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 (11/16/2010 02:21:01 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) (11/16/2010 02:21:01 PM)
      p_batch_id ==> 614304
      Entering WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
        flag ==> TRUE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (11/16/2010 02:21:01 PM,  0 seconds)
      Calling TRANSFER_SERIAL_NUMBERS FOR BATCH 614304
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
        p_interfacing ==> INV
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
          p_transfer_param ==> MSNT
          p_batch_id ==> 614304
          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 (11/16/2010 02:21:01 PM,  0 seconds)
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
          p_transfer_param ==> WDD
          p_batch_id ==> 614304
          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 (11/16/2010 02:21:01 PM,  0 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (11/16/2010 02:21:01 PM,  0 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
        NUMBER OF ROWS UPDATED AS INTERFACED TO INVENTORY = 0
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (11/16/2010 02:21:01 PM,  0 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
         flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (11/16/2010 02:21:01 PM,  0 seconds)
      NEW TRANSACTION_HEADER : 7588016
      Number of records fetched by l_get_picking_ln_id_csr is  ==> 1
      No. existing record updated in MTI ==> 0
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        batch_id ==> 614304
        P_TRANSACTION_HEADER_ID ==> 7588016
        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 (11/16/2010 02:21:01 PM,  0 seconds)
      Interface_Detail_To_Inv l_inv_inter_status ==> S
      Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 115.120.11510.6) (11/16/2010 02:21:01 PM)
        P_MESSAGE_TYPE ==> W
        P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP
        msg_buffer ==> 由于批中的某些行处于错误状态，因此库存接口无法处理这些行。请使用库存接口 UI 查询这些行，以更正错误。
        W:由于批中的某些行处于错误状态，因此库存接口无法处理这些行。请使用库存接口 UI 查询这些行，以更正错误。
      Exiting WSH_UTIL_CORE.ADD_MESSAGE (11/16/2010 02:21:01 PM,  .04 seconds)
      l_completion_status ==> NORMAL
    Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (11/16/2010 02:21:01 PM,  .05 seconds)
    INTERFACETRIPSTOP: RESULT OF INVENTORY INTERFACING BATCH_ID 614304 = WARNING
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
      p_num_stops ==> is NULL
      p_batch_id ==> 614304
      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 (11/16/2010 02:21:01 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) (11/16/2010 02:21:01 PM)
      p_batch_id ==> 614304
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (11/16/2010 02:21:01 PM)
        p_batch_id ==> 614304
         flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (11/16/2010 02:21:01 PM,  0 seconds)
      Return False ==>
    Exiting WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED (11/16/2010 02:21:01 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 (11/16/2010 02:21:01 PM,  .12 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 (11/16/2010 02:21:01 PM,  .16 seconds)
************Summary of Shipping API Calls************
WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP : 1 calls : .16 seconds
WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL : 1 calls : .12 seconds
WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP : 1 calls : .01 seconds
WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM : 1 calls : .01 seconds
WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS : 2 calls : 0 seconds
WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT : 4 calls : 0 seconds
WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS : 3 calls : 0 seconds
WSH_DSNO.SUBMIT_TRIP_STOP : 1 calls : .03 seconds
WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP : 1 calls : .05 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 : 0 seconds
WSH_UTIL_CORE.ADD_MESSAGE : 1 calls : .04 seconds
WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED : 1 calls : 0 seconds
*****************************************************
+---------------------------------------------------------------------------+
FND_FILE 中日志消息结束
+---------------------------------------------------------------------------+

feet112

不知道你的这个形成交货号没有，
到库存的是事物处理开放接口或待定里查一下看能不能找到相关记录。
还有就是系统组织参数，订单发运或者库存的设置有错误，查查设置文档，有什么遗漏没有。
修改设置参数，就不会发生这个问题了。

feet112

不知道你的这个形成交货号没有，
到库存的是事物处理开放接口或待定里查一下看能不能找到相关记录。
还有就是系统组织参数，订单发运或者库存的设置有错误，查查设置文档，有什么遗漏没有。
修改设置参数，就不会发生这个问题了。

feet112

看下的配置参数是否正确

sse_zero

回复 feet112 的帖子

谢谢了啊。这么详细的帮我看，问题已经解决了。主要问题是在库存接口表里面，就是你第一次回复的那个里面。解决办法也不是很通用。在这就不跟大家分享了。

wiorange

哇塞  这个乱码 还真是复杂啊

feet112

一般情况下是不会出现这个情况的。
比较好奇，我想问一下，导致出现问题的设置参数是哪个，找到了吗？

sse_zero

回复 feet112 的帖子

跟设置没有问题。就是发运的时候时候数量选择多了。

菜鸟他爸

发运数量一般应和调库数量相等啊，即或最后发运确认时还可延交，有问题我有时用例外解决。