訂單出貨錯誤

智者

小弟在出貨時，產生警告錯誤，日誌檔如下：
+---------------------------------------------------------------------------+
Shipping Execution: Version : 11.5.0 - Development

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

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

Current system time is 16-JAN-2007 08:01:27

+---------------------------------------------------------------------------+

**Starts**16-JAN-2007 08:01:27
**Ends**16-JAN-2007 08:02:07
Interface trip stop is  completed with warning
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting WSH Debugger ==> 01/16/2007 08:02:40 AM,Session ID=3634982
Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_ALL_WRP (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:40 AM)
  P_MODE ==> ALL
  P_STOP_ID ==> is NULL
  P_DELIVERY_ID ==> is NULL
  P_LOG_LEVEL ==> 1
  p_organization_id ==> 120
  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) (01/16/2007 08:02:40 AM)
    P_MODE ==> ALL
    P_STOP_ID ==> is NULL
    P_DELIVERY_ID ==> is NULL
    P_LOG_LEVEL ==> 1
    p_organization_id ==> 120
    p_stops_per_batch ==> 1
InterfaceTripStop: processing all eligible stops 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 ==> is NULL
    setting savepoint before_flag_change ==>
    locking row for 546773 ==>
    updating pending_interface_flag to P for batch ==> 26555
    ========================================================================
    Entering WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:40 AM)
      p_batch_id ==> 26555
      OM INTERFACING BATCH 26555
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_STOP_TO_OM (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:40 AM)
        p_batch_id ==> 26555
        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 (01/16/2007 08:02:41 AM,  .95 seconds)
      Interface_Stop_To_OM l_return_status ==> S
      Calling TRANSFER_SERIAL_NUMBERS FOR 26555
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
        p_batch_id ==> 26555
        p_interfacing ==> OM
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
          p_transfer_param ==> MSNT
          p_batch_id ==> 26555
          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 (01/16/2007 08:02:41 AM,  .24 seconds)
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
          p_transfer_param ==> WDD
          p_batch_id ==> 26555
          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 (01/16/2007 08:02:41 AM,  .18 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (01/16/2007 08:02:41 AM,  .43 seconds)
      x_completion_status ==> INTERFACED
    Exiting WSH_SHIP_CONFIRM_ACTIONS.OE_INTERFACE_TRIP_STOP (01/16/2007 08:02:41 AM,  1.38 seconds)
    INTERFACETRIPSTOP: RESULT OF OM INTERFACING BATCH_ID 26555 = INTERFACED
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
      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 (01/16/2007 08:02:41 AM,  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) (01/16/2007 08:02:41 AM)
      P_TRIP_STOP_ID ==> 546773
      PROCESSING DSNO IN TRIP STOP 546773
      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 (01/16/2007 08:02:41 AM,  .06 seconds)
    INTERFACETRIPSTOP: RESULT OF DSNO SUBMISSION FOR STOP_ID 546773 = NORMAL
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
      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 (01/16/2007 08:02:41 AM,  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) (01/16/2007 08:02:41 AM)
      p_batch_id ==> 26555
      Entering WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
        p_batch_id ==> 26555
        flag ==> TRUE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.OM_INTERFACED (01/16/2007 08:02:41 AM,  0 seconds)
      Calling TRANSFER_SERIAL_NUMBERS FOR BATCH 26555
      Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
        p_batch_id ==> 26555
        p_interfacing ==> INV
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:41 AM)
          p_transfer_param ==> MSNT
          p_batch_id ==> 26555
          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 (01/16/2007 08:02:41 AM,  .18 seconds)
        Entering WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS_PVT (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:42 AM)
          p_transfer_param ==> WDD
          p_batch_id ==> 26555
          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 (01/16/2007 08:02:42 AM,  .17 seconds)
      Exiting WSH_SHIP_CONFIRM_ACTIONS.TRANSFER_SERIAL_NUMBERS (01/16/2007 08:02:42 AM,  .37 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:42 AM)
        p_batch_id ==> 26555
        NUMBER OF ROWS UPDATED AS INTERFACED TO INVENTORY = 0
      Exiting WSH_SHIP_CONFIRM_ACTIONS.UPDATE_INTERFACED_DETAILS (01/16/2007 08:02:42 AM,  .04 seconds)
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:42 AM)
        p_batch_id ==> 26555
         flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (01/16/2007 08:02:42 AM,  0 seconds)
      NEW TRANSACTION_HEADER : 1809249
      Number of records fetched by l_get_picking_ln_id_csr is  ==> 2
      No. existing record updated in MTI ==> 0
      Entering WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:42 AM)
        batch_id ==> 26555
        P_TRANSACTION_HEADER_ID ==> 1809249
        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 (01/16/2007 08:02:43 AM,  .36 seconds)
      Interface_Detail_To_Inv l_inv_inter_status ==> S
      Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 115.120.11510.6) (01/16/2007 08:02:43 AM)
        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 (01/16/2007 08:02:43 AM,  0 seconds)
      l_completion_status ==> NORMAL
    Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (01/16/2007 08:02:43 AM,  1.27 seconds)
    INTERFACETRIPSTOP: RESULT OF INVENTORY INTERFACING BATCH_ID 26555 = WARNING
    Entering WSH_SHIP_CONFIRM_ACTIONS.UPDATE_COMPLETION_STATUS (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:43 AM)
      p_num_stops ==> is NULL
      p_batch_id ==> 26555
      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 (01/16/2007 08:02:43 AM,  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) (01/16/2007 08:02:43 AM)
      p_batch_id ==> 26555
      Entering WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (WSHDDSHB.pls 115.310.11510.3) (01/16/2007 08:02:43 AM)
        p_batch_id ==> 26555
         flag ==> FALSE
      Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACED (01/16/2007 08:02:43 AM,  0 seconds)
      Return False ==>
    Exiting WSH_SHIP_CONFIRM_ACTIONS.ALL_INTERFACED (01/16/2007 08:02:43 AM,  0 seconds)
    setting savepoint before_flag_change ==>
    locking row for 547773 ==>
    updating pending_interface_flag to P for batch ==> 26556
    ========================================================================
請各路大俠幫忙指點，是哪裏出的錯，我怎麽找不到問題出錯的原因在那裏阿？？？？先謝謝各位了！！！

zhaoyin

楼主,你贴这么一大片,自己不知道有没有看过 哈哈

智者

看過知道是由於在Transaction Open Interface界面中有錯誤，可現在不知該如何下手解決此問題，請版主提供合適的方法。

orapeasant

试试在transaction open interface 界面里面查具体的error code

sunjinhai

好象是出了未來日期要出的貨了

智者

哦，不知道孫哥的意思是出貨時不可以提前將未來日期的貨先出。如果先出就會有錯誤嗎？

智者

界面中的錯誤提示是Oracle error。再沒有別的提示阿！不知是那裏的問題？

常志强

那from中有报什么错误码？除了日记中的错误之外

简单些

我也面对这个问题 ！ http://space.itpub.net/7695891/viewspace-66928 ， 你可以去看看