=============================================================================
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 theyare trying to do subinventory transfer. . [ Extraction form conncurrent log file ]=== From here ===RVCTP moduleRVTII-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 notworking and when we tried to run it, it ended withwarnings.We found out that some items in mtl_material_transactions doesn't havethe 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 a20col org_id format 99990col ct_id format 99990col a format 990col b format 990col item_cst format 9999990col 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_cstfrom cst_item_costs cic,mtl_parameters mp,mtl_system_items_b msib,mtl_parameters mpcwhere cic.inventory_item_id=msib.inventory_item_idand msib.inventory_item_id in (9151, 7446) . [ The result ]ORG ORG_ID COG ITEM_SEGS
I CCT_IDAB ITEM_CST MT_CST--- ------ --- -------------------- - - ------ ---- ---- -------- --------PED2 PED 00000001046
Y Y112PED2 PED G0025505002
Y Y112P013 P01 G0025505002
Y Y112 . .
|