LIKE METALINK " Wip Assembly Completion For A Job Through MTL_TRANSACTIONS_INTERFACE Is Not Updating Job Completed Quantity [ID 745112.1] "
I had this problem now .
my Product, version, OS:
oracle 12.0.6 -- costing method is Average Costing -- lot control -- cost manager is running normaly
My problem is :
when i use " mtl_transactions_interface / mtl_transaction_lots_interface / CST_COMP_SNAP_INTERFACE " table to perform WIP Assembly Completion transaction.the transaction is getting processed successfully , but the completedquantity is not getting updated in the Discrete job also quantity still remaining in To Move of last operation.
and data in cst_comp_snap_interface table is never been processed,and never have error message too.(it looks like the cost manager have not deal with it ,but my cost manager is running normally)
Is there any thing that i lost to do ? or to set a special profile or parameter setup ?
--------------------------------------
SQL AS BELOW：
insert into mtl_transactions_interface
( source_code,
source_line_id,
source_header_id,
process_flag,
validation_required,
transaction_mode,
lock_flag,
last_update_date,
last_updated_by,
creation_date,
created_by,
inventory_item_id,
organization_id,
transaction_quantity,
primary_quantity,
transaction_uom,
transaction_date,
subinventory_code,
locator_id,
transaction_source_id,
transaction_source_type_id,
transaction_action_id,
transaction_type_id,
transaction_reference,
wip_entity_type,
operation_seq_num,
bom_revision_date,
routing_revision_date,
scheduled_flag,
final_completion_flag,
Flow_schedule,
--revision,
transaction_interface_id
)
values
(
1, --source code
1, -- source line id
-1, -- source header id
1, -- process flag
1, -- validation required
3, -- transaction mode
2, -- lock flag
sysdate, -- last update date
5334, -- last updated by
sysdate, -- creation date
5334, -- created by
3558566, -- inventory item id --
104, -- org id
3, -- transaction quantity
3, -- primary quantity
'PCS', -- transaction uom
sysdate, -- transaction date
'C0', -- subinventory code
52541, --locator_id
2903453, -- transaction source id
5, -- transaction source type id
31, -- transaction action id
44, -- transaction type id
'test', -- transaction reference
1, -- wip entity type
-1, -- operation seq num
sysdate, -- bom revision date
sysdate, -- routing revision date
2, -- scheduled flag
'N', --final_completion_flag
'N', -- flow schedule
--'0' , -- Revision
15375515 --interface_id
);
---------------------------------------------------------------------------------
/*2. Data inserting into mtl_transaction_lots_interface */
---------------------------------------------------------------------------------
insert into mtl_transaction_lots_interface
(TRANSACTION_INTERFACE_ID,
SOURCE_CODE,
SOURCE_LINE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LOT_NUMBER,
TRANSACTION_QUANTITY,
ERROR_CODE,
PROCESS_FLAG)
values(
15375515,--interface_id,
1, -- Source Code
1, -- Source Line id
sysdate, -- Last update date
1318, -- Last updated by
sysdate, -- Creation Date
5334, -- Created By
'101027001', -- Lot number Needs input
3, -- Transaction Quantity
NULL,
1 -- Process Flag
);
---------------------------------------------------------------------------------
--3. Data inserting cst_comp_snap_interface
---------------------------------------------------------------------------------
insert into CST_COMP_SNAP_INTERFACE
(TRANSACTION_INTERFACE_ID,
WIP_ENTITY_ID,
OPERATION_SEQ_NUM,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
QUANTITY_COMPLETED,
PRIMARY_QUANTITY
)
VALUES
(
15375515,--INTERFACE_ID,
2903453, --Job id
70,--Operatoin Seq No
SYSDATE, --Last update date
5334, --Last updated by
SYSDATE, --Creation date
5334,--Created by
3, --Quantity Completed
3 --Priamry Quantity
);
|
] 
Blog
Search
Help
Members
Register
Login
Home
