Home » Applications » Oracle Fusion Apps & E-Business Suite » Wip Assembly Completion For A Job Through MTL_TRANSACTIONS_INTERFACE Not Update Job Completed Qty (oracle 12.0.6 -- costing method is Average Costing -- lot control )
Wip Assembly Completion For A Job Through MTL_TRANSACTIONS_INTERFACE Not Update Job Completed Qty [message #482225] Wed, 10 November 2010 07:51 Go to next message
elvis_698
Messages: 1
Registered: November 2010
Location: china
Junior Member
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
);

Re: Wip Assembly Completion For A Job Through MTL_TRANSACTIONS_INTERFACE Not Update Job Completed Qty [message #668700 is a reply to message #482225] Sat, 10 March 2018 02:32 Go to previous message
Kaisar
Messages: 1
Registered: March 2018
Junior Member
If there are multiple operation sequences against your wip job then, Insert multiple records in CST_COMP_SNAP_INTERFACE against each operation,
one record for each OPERATION_SEQ_NUM in WIP_OPERATIONS for the appropriate WIP_ENTITY_ID (with the same transaction_interface_id).
Previous Topic: Search and Select Customer view UI Oracle Cloud
Next Topic: I Expense Errors
Goto Forum:
  


Current Time: Mon Mar 18 23:04:00 CDT 2024