【正文】 題的程式：（Cause of Issue:）1. MiTAC HUB(昆達(dá))Inbound Main Process: 2. Mitac Hub Issue Inventory Process: 3. HWA HUB 856 Update 862amp。OR STATUS_CODE!=39。l 檢查語句 Script：SELECT * FROM MIC_HUB_ISSUE_DETAILSWHERE EDI862_UPDATE_STATUS like 39。關(guān)注的table有：MIC_HUB_ISSUE_DETAILS，MIC_HUB_RECEIVING_DETAILS，MIC_HUB_TRANSACTION_DETAILS等EDI異常之table。21 / 21月結(jié)SOP月結(jié)之總體Scope and Frame?INV 月結(jié)—交易過帳l Check 所有transaction是否異常,press all TXN均過帳l 保證庫存的正確性和真實(shí)性:並Extract INV/WIP QTY for 重算成本?財(cái)務(wù)月結(jié)—算出原料成本v重算成本(通過加權(quán)平均算出每個(gè)item原料的成本pending cost)v找成本差異,更正有誤的成本 ?Cost 月結(jié)形成財(cái)務(wù)報(bào)表v會(huì)計(jì)分錄,拋GLv形成生產(chǎn)成本價(jià)格，記錄歷史成本vUpdate item cost(Frozen standard cost)v Submit standard cost adjustment Report目前對(duì)於財(cái)務(wù)月結(jié)和INV月結(jié)本質(zhì)上沒有影響,除了驗(yàn)收會(huì)對(duì)財(cái)務(wù)計(jì)算材料成本有影響以外.INV月結(jié):(會(huì)計(jì)區(qū)間內(nèi)),準(zhǔn)確性.(這也是為什麼要check負(fù)庫存和帳查的原因),以便抽出本期期末(下期期初),為計(jì)算材料成本和Cost .Step 1. All records in HUB interface must be cleared.原則上是要Check EDI 856所有的Interface 中的異常數(shù)據(jù)，這些是本月的交易但是卻不能正常產(chǎn)生交易異動(dòng)檔。所以必須讓這些數(shù)據(jù)正常insert到mtl_materail_transactions中。1. check 發(fā)料的EDI interface。ERR%39。OK86239。Allocated Records:4. PKG: mkl_wip_auto_jj_for_02. auto_post_jjl 處理辦法：Error status code: 182。. OKBP、ERRISS(6) JJ單利用EK調(diào)撥，不足量以AA採購，但EK與AA回的時(shí)間不同，過帳組未加以確認(rèn)數(shù)量即過帳，造成第二筆單據(jù)無法過帳，形成HUB DATA Error ，進(jìn)而造成INV負(fù)庫存。2. check txn（如：EK，DD，F(xiàn)F）的interfacel 檢查語句 Script：SELECT * FROM MIC_HUB_TRANSACTION_DETAILSWHERE STATUS_CODE!=39。l Cause of Issue:u MiTAC HUB(昆達(dá))Inbound Main Process: ]u EDI from HUB: l 處理辦法：請(qǐng)查看程式3. check 驗(yàn)收或者Approval的interface l 檢查語句 Scriptselect * from MIC_HUB_RECEIVING_DETAILS Hwhere LIKE 39。l Cause of Issue:MiTAC HUB Receiving Process：l 處理辦法：UPDATE mic_hub_receiving_details h SET = 39。, batch_id = 39。 然後：通過BU_Code來判斷是GTK還是MKL,然後:如果是transaction_type=39。要在對(duì)應(yīng)的mitac hub supervisor gui 運(yùn)行mitac hub status change report如果是transaction_type=39。要在對(duì)應(yīng)的mitac hub supervisor gui運(yùn)行mitac hub receiving process注意此程式是PO Module中的程式需要by Step 2. All records in MTL TXN interfaces must be postedOracle ERP的過賬是通過MTL_TRANSACTIONS_INTERFACE和MTL_MATERIAL_TRANSACTIONS_TEMP及RCV_transactions_interface與用戶或者客戶化作為接口來處理的。因爲(wèi)oralce程式會(huì)自己判斷，如果數(shù)據(jù)不符合其規(guī)則或者異常，將會(huì)一直卡在interface中，不能正常產(chǎn)生交易。setup224。Interface Manager裏面的Material transaction，如果其status為Active，則説明其是處在工作狀態(tài)。To investigate why the Transactions are Failing, run the following SQL Script: SQL select transaction_source_id , inventory_item_id, process_flag, error_code, error_explanation, transaction_source_type_id, organization_id from mtl_material_transactions_tempHow to resubmit the Transactions use this script: SQL update mtl_material_transactions_temp set process_flag = 39。, lock_flag = 39。, transaction_mode= 3, error_code = NULL, error_explaination = NULL where process_flag = 39。 方法2：進(jìn)入Oracle ERP系統(tǒng)察看並處理此種情況：Navigate：INV Supper User GUI224。Pending Transactions處理MTL_TRANSACTIONS_INTERFACE方法1：SQL：select ,mti.* from mtl_transactions_interface mti,，Process_flag:1: ready 2, not ready,Lock_flag:1: Locked, 2 or null: not locked處理完提示的錯(cuò)誤后，update process_flag=1,如果Lock_flag為1,請(qǐng)update為2或者null.方法2:同樣進(jìn)入Oracle ERP系統(tǒng)察看並處理此種情況：Navigate：INV Supper User GUI224。Transaction Open Interface.處理：RCV_transactions_interfaceCheck err msg, then run the receive transaction report by batch idStep 3. Find negative balance 負(fù)庫存負(fù)庫存是系統(tǒng)不夠嚴(yán)謹(jǐn)?shù)淖蠲黠@的表現(xiàn),從根本上消滅負(fù)庫存是系統(tǒng)的目標(biāo),也是INV Module ,請(qǐng)及時(shí)處理,You’d Better Deal with it By Week even by Day查看負(fù)庫存可以Run:WH data entry 213。 run report 213。但對(duì)於下面兩點(diǎn)的有效性保留自己的意見，待深入研究，在此不作評(píng)價(jià)。01MAR2000 00:00:0039。DDMONYYYY H24:MI:SS39。Step5. Check acct_period_id SQLSELECT * FROM ORG_ACCT_PERIODS ORDER BY ACCT_PERIOD_ID descselect distinct , from MTL_MATERIAL_TRANSACTIONS MMT,ORG_ACCT_PERIODS OAPwhere TRANSACTION_ID 17604430 and TRANSACTION_TYPE_ID!=24AND =TRANSACTION_ID為上月MAX_TX_IDStep6. Run Repor