EBS:OM接口表导入销售订单失败

 

用户通过集成器程序导入销售订单,过程调用了定义程序包(CUX2056_网络销售订单导入)向OM接口表,再调用标准程序将接口转销售订单

用户收到错误信息“价目表价格或销售价格不正确。 请输入值为正的价目表价格和销售价格。” 

从OM的处理信息表查到

最近处理错误信息

SELECT m.* , mt.message_text -- BULK COLLECT
-- INTO lt_err_msg
FROM apps.oe_processing_msgs m, apps.oe_processing_msgs_tl mt
WHERE mt.transaction_id = m.transaction_id
AND m.type = 'ERROR'
and mt.last_update_date >= to_date('2023-04-27 15:30:00','yyyy-mm-dd hh24:mi:ss')
-- AND m.request_id = 156701542 --lc_h.request_id;
-- and m.transaction_id = 946163
and m.ORIGINAL_SYS_DOCUMENT_REF in ('SDO233051879106-120','SDO233064355123-120','SDO23306541005-120')

 

-- 当通过 OM接口导入订单失败,可能接口处理信息表查看错误信息 
select MSI.INVENTORY_ITEM_ID     AS ITEM_ID,
       MSI.SEGMENT1              AS ITEM_NUM,
       MSI.DESCRIPTION           AS ITEM_DESCRIPTION,
       OHI.REQUEST_ID,
       OHI.ORIG_SYS_DOCUMENT_REF,
       OHI.ORDER_TYPE_ID,
       OLI.ORIG_SYS_LINE_REF,
       OLI.UNIT_LIST_PRICE       AS "价目表单价",
       OLI.UNIT_SELLING_PRICE    AS "销售单价",
       OLI.SOLD_TO_ORG_ID,
       OLI.SHIP_FROM_ORG_ID,
       mt.message_text
  FROM apps.oe_processing_msgs    m, --OM处理信息表
       apps.oe_processing_msgs_tl mt, -- OM处理信息语言表
       ont.oe_LINEs_iface_all     OLI,  -- OM接口行表
       ont.oe_headers_iface_all   OhI,  -- OM接口头表
       INV.MTL_SYSTEM_ITEMS_B     MSI  -- 物料表  
 WHERE mt.transaction_id = m.transaction_id
   AND m.type = 'ERROR'
   AND OHI.ORIG_SYS_DOCUMENT_REF = OLI.ORIG_SYS_DOCUMENT_REF
   AND OLI.ORIG_SYS_DOCUMENT_REF = M.ORIGINAL_SYS_DOCUMENT_REF
   AND OLI.ORIG_SYS_LINE_REF = M.ORIGINAL_SYS_DOCUMENT_LINE_REF
   AND OLI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
   AND OLI.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID
   

  

posted @ 2023-04-28 09:12  samrv  阅读(127)  评论(0编辑  收藏  举报