OM: Shipping Confirm 后没有扣库存？？

imzh

最初由 yanyan7038 发布
[B]我遇到过这种问题，得从后台表wsh_delivery_details的数据库中改OE_INTERFACED_FLAG(N改为Y)和INV_INTERFACED_FLAG(N改为P)两个接口标记，.然后再跑接口请求，订单便可以interfaced。 [/B]

特别感谢yanyan7038 ,我们系统clone后就按照你的办法处理的，已经OK.

同时也谢谢 pollyma的帮助和解释。

谢谢IT-PUB  .呵呵！~~~~~~~~

lflyingfox

承教

OE_INTERFACED_FLAG(N改为Y   我的系统中怎么有许多'N'呢,也有'Y',yanyan7038能给解释一下吗.

yanyan7038

非常开心能够帮助 imzh，大家共同进步!
承教不敢，OE_INTERFACED_FLAG只是销售模块的一个接口标记，未发运的订单行这个标记应该都是N，而interfaced的订单行应该都是Y，你可以分别查一下状态为Y和N的订单行的状态各是什么，可能就明白了

Beyond518

up

lveamy

学习一把

hailen

谢谢高手们

imai

DATAFIX: TRIP STOP FAILS WITH ERRORS: UNABLE TO GET ACCOUNT (31 ORDERS)
--------------------------------------------------------------------------------


  *** 06/28/05 11:49 am *** Tar Number: SR:4382772.996 . PROBLEM STATEMENT: ------------------ On 11.5.9 in Production: Find 35 sales order issues that will not interface to inventory. The inventory trip stop completes with error #1 for 31 orders and error #2 for 4 orders. . ERROR #1 ---------------- Unable to get account for delivery detail id 606981 . ERROR #2 ---------------- Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified acti vity for item 'OEOL/1061386'. in Package OE_Delayed_Requests_PVT Procedure Proce ss_Request_Pvt Process Order failed for order header_id 547175 Failed to interface header  547175  to Order Management because API interface_header_to_OM failed . BUSINESS IMPACT ----------------------- Due to this issue, users cannot close the period for June 2005. . Verified the log files: . LOG FILES ------------ Filename = Trip_Stop_ORA-20002.txt  WSHINTERFACES module: Interface Trip Stop - SRS Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified acti vity for item 'OEOL/1061386'. in Package OE_Delayed_Requests_PVT Procedure Proce ss_Request_Pvt Process Order failed for order header_id 547175 Failed to interface header  547175  to Order Management because API interface_header_to_OM failed 4 . Filename = Shipping_exceptions_account_problems.html WSHINTERFACES module: Interface Trip Stop - SRS Unable to get account for delivery detail id 606981 31

sjh_empire

我也是这个问题，但是OE_INTERFACED_FLAG 是Y和INV_INTERFACED_FLAG是P，pening 在inventory open interface  ,  resubmit时，显示记录己被锁定，不知道如何处理了