oracle完整移库,移库碰到的问题,紧急

=============================================================================                               PROBLEM DESCRIPTION  =============================================================================  ** DETAILED DESCRIPTION OF PROBLEM, INCLUDING ALL ERRORS:  .  Customer is getting the message "RVTPTCONTRL FAILED" message when they are   trying to recieving PO's transaction.   Also, they are getting "INV-NO ITMCOST DEFINED"  message when they  are trying to do subinventory transfer. . [ Extraction form conncurrent log file ]  === From here ===  RVCTP module  RVTII-060: Subroutine inltpu() returned error   Cause:    Subroutine inltpu() returned an internal error.    Action:    Note this error number and the actions you are trying to perform.             Contact your system administrator for assistan  === END ===   .  The concurrent program(=RVCTP: RECEIVING TRANSACTION PROCESSOR) was not  working and when we tried to run it, it ended with  warnings.  We found out that some items in mtl_material_transactions doesn't have  the port data of CST_ITEM_COSTS table. .  For example,   ITEM "00000001046" (mtl_system_items_b.inventory_item_id is '9151')  for Inventory Organization "P01" doesn't have CST_ITEM_COSTS table data.   [ SQL scripts ]  col item_segs format a20  col org_id format 99990  col ct_id format 99990  col a format 990  col b format 990  col item_cst format 9999990  col mt_cst   format 9999990 .  ,substrb(msib.segment1,1,20) item_segs  ,msib.inventory_asset_flag i  ,msib.costing_enabled_flag c  ,cic.cost_type_id ct_id  ,cic.inventory_asset_flag a  ,cic.based_on_rollup_flag b  ,cic.item_cost item_cst  ,cic.material_cost mt_cst  from cst_item_costs cic  ,mtl_parameters mp  ,mtl_system_items_b msib  ,mtl_parameters mpc  where cic.inventory_item_id=msib.inventory_item_id  and msib.inventory_item_id in (9151, 7446) . [ The result ]  ORG ORG_ID COG ITEM_SEGS            I C  CT_ID    A    B ITEM_CST   MT_CST  --- ------ --- -------------------- - - ------ ---- ---- -------- --------  PED      2 PED 00000001046          Y Y      1    1    2  PED      2 PED G0025505002          Y Y      1    1    2  P01      3 P01 G0025505002          Y Y      1    1    2 . .

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值