工單closed無法正常關閉，查看步驟小結

在工單制令closed出現錯誤時，導致工單處于status_type=15 時，確認下列操作即可

1.工單搬站talbe

SELECT WIP_ENTITY_ID
Z+ee a:?u k|0                         FROM WIP_MOVE_TXN_INTERFACE    ITPUB个人空间'f ?Ax/b9\
                Where wip_entity_id=881707

使用下列語句Update

update WIP_MOVE_TXN_INTERFACE
H9V3BR'r*C PHc0       set group_id = NULL,
v i&NU&\a*d6o$M&o,P0           transaction_id = NULL,
&cY_V J,@d0           process_status = 1,ITPUB个人空间0p7?"FE@2v_+i
           OVERCOMPLETION_TRANSACTION_QTY= NULL,
6?O:G
o;lF$B0           OVERCOMPLETION_PRIMARY_QTY= NULL

Where and TRANSACTION_ID=4255;
t4uaJ)Ua6wN7U+`(`W02.工單計算公費table
k Mb4jjSD0t0              SELECT WIP_ENTITY_ID
O7}noi0                         FROM WIP_COST_TXN_INTERFACEITPUB个人空间 OmJkl%{9f|
                Where wip_entity_id=881707

  開工單工費的數據,需要check cost manager是否開啟,

使用下列語句Update

update WIP_COST_TXN_INTERFACE
S:hH$v4^n0       set group_id = NULL,
sqrt K,Y0           transaction_id = NULL,ITPUB个人空间A'Wd.]TI)Yh
           PROCESS_STATUS = 1 

Where and TRANSACTION_ID=4255;

3.領退料入庫等交易table

              SELECT TRANSACTION_SOURCE_ID
g^Z2NB0                         FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
0_R.S-dn)Y`6sf$r0                Where mmtt.transaction_source_id=881707ITPUB个人空间/ba-^[1n~{ ~m0H5I
                     AND TRANSACTION_SOURCE_TYPE_ID = 5 

運用下列語句Update

   update MTL_MATERIAL_TRANSACTIONS_TEMPITPUB个人空间2J2J9gtC
       set process_flag = 'Y',ITPUB个人空间;fR&zk VG"uE
           lock_flag = 'N',ITPUB个人空间ELTG4Ra&f\
           transaction_mode = 3,
{\6?u6t)AB?0           error_code = NULL,
$~*g5n#~8r0P)@)G)xWz0           error_explanation = NULLITPUB个人空间msV(xVh6O7g
where PROCESS_FLAG in ('Y','E')
g,D'N URu04.領退料入庫等交易切分錄table
,[9uZ0A_DK0                  SELECT TRANSACTION_SOURCE_ID
.a*k}#Mf IC0                         FROM MTL_MATERIAL_TRANSACTIONS
2vfz1H+}3L~0                         WHERE COSTED_FLAG IN ('N','E')

                  AND   TRANSACTION_SOURCE_TYPE_ID = 5 ITPUB个人空间aU7\U(x]
K
                And  transaction_source_id=881707
8cSM3b`0XV+]0           'N'為暫時還未切分錄,需要check cost manager是否開啟,開啟完畢

           'E'為切錯誤,用下列語句Update后等待cost manager處理

   update MTL_MATERIAL_TRANSACTIONS  mmt
+V;M
pvt0        set mmt.COSTED_FLAG = 'N', ITPUB个人空间%m
S2l'Yh$~~
           mmt.TRANSACTION_GROUP_ID = NULL,ITPUB个人空间#f p@qUFp3V,A X
           mmt.PRIOR_COST = null,
$t2HI9`3\HMH0           mmt.NEW_COST = null,
tM-Nfpk0           mmt.ACTUAL_COST = null
AN6gyxgrx)I0where mmt.COSTED_FLAG ='E'
a%c`$LZ-U!seb f0 5.工單關閉需用用到的temp table ITPUB个人空间%x5}(rf
QmY
         Select  * From   WIP_DJ_CLOSE_TEMP       

  有數據可直接delete