用户通过集成器程序导入销售订单，过程调用了定义程序包（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