错误信息2:mtl_transactions_interface,|物料挑库发放和挑库确认流程完成时出现错误 原因:接口表子库存与搬运单行的子库存不一致。 搬运单的子库存和库位需要一致。 v_misc_trans_tbl mtl_transactions_interface%ROWTYPE; v_misc_lot_tbl mtl_transaction_lots_interface%ROWTYPE; v_misc_trans_tbl.transaction_inter...
错误信息4:mtl_transactions_interface,|物料挑库发放和挑库确认流程完成时出现错误 无法为已结销售订单创建保留。 原因:-- -- v_misc_trans_tbl mtl_transactions_interface%ROWTYPE; v_misc_lot_tbl mtl_transaction_lots_interface%ROWTYPE; v_misc_trans_tbl.transaction_interface_id := v_trx_interface_id;...
3.查询出现有量导入接口表mtl_transactions_interface Insert into mtl_transactions_interface( transaction_uom, transaction_date, source_code, source_line_id, source_header_id, process_flag , transaction_mode , lock_flag , locator_id , last_update_date , last_updated_by , creation_date , created_...
l_iface_rec inv.mtl_transactions_interface%ROWTYPE;l_iface_lot_rec inv.mtl_transaction_lots_interface%ROWTYPE;BEGIN XV_STATUS:='S';BEGIN SELECT GP.SCHEDULE_CLOSE_DATE,GP.ACCT_PERIOD_ID INTO lv_transaction_date,ln_period_id FROM org_acct_periods GP WHERE GP.PERIOD_NAME=P_PERIOD_NAME AND ...
下载并发程序设置： Cd$CUX_TOP Cdinstall Cddownload ../CUX_CDL.shapppass'并发程序名' 上载并发程序设置： Cd$FND_TOP cdpatch cd115 cdimport FNDLOADapps/apppassOYUPLOAD$FND_TOP/patch/115/import/afcpprog.lct并发请求名.ldt 对于标准接收，接收失败，相应记录留在接口表RCV_TRANSACTION_INTERFACE，要...
Missing Intransit Receipt transaction in MTL_MATERIAL_TRANSACTIONS. There was an ORA error due to tablespace issue; Intransit Receipt Transaction wasn't generated. The receiving data has been updated correctly, and shows the "FULLY RECEIVED", but, there is no material transaction in Inventory....
Oracle Warehouse Management - Version 11.5.8 and later: Sample WMS Open Interface Insert Scripts -- How To Insert Into Transaction Open Interface MTL_TRANSACTIONS_IN
16、ANSACTIONSINTERFACEMTLMATERIALTRANSACTIONSRCVTRANSACTIONSINTERFACE.INVTRANSACTIONIDWIPSCRAPVALUESMTLMATERIALTRANSACTIONSWIPSCRAPVALUES.TRANSACTIONIDWMS_DISPATCHED_TASKS_HISTORYMTL_MATERIAL_TRANSACTIONSWMS_DISPATCHED_TASKS_HISTORY.TRANSACTION_IDMTL_MATERIAL_TRANSACTIONSstoresarecordofeverymaterialtra 17、nsactionorcostupda...
下载并发程序设置： Cd$CUX_TOP Cdinstall Cddownload ../CUX_CDL.shapppass'并发程序名' 上载并发程序设置： Cd$FND_TOP cdpatch cd115 cdimport FNDLOADapps/apppassOYUPLOAD$FND_TOP/patch/115/import/afcpprog.lct并发请求名.ldt 对于标准接收，接收失败，相应记录留在接口表RCV_TRANSACTION_INTERFACE，要...
MTL_MATERIAL_TRANSACTIONS Primary Key: MTL_MATERIAL_TRANSACTIONS_PK 1.TRANSACTION_ID Foreign Keys GL_CODE_COMBINATIONS MTL_ITEM_REVISIONS_B MTL_CYCLE_COUNT_ENTRIES MTL_PHYSICAL_ADJUSTMENTS MTL_TRANSACTION_TYPES MTL_SYSTEM_ITEMS_B CST_COST_GROUPS WIP_DISCRETE_JOBS WIP_REPETITIVE_ITEMS MTL_ITEM_LOCA ...