============================================================================= 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 . .
oracle完整移库,移库碰到的问题,紧急
最新推荐文章于 2024-04-22 15:14:52 发布