Oracle eBS經驗分享

Error log:

Error Message

msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are locked by another process.
W:Inventory Interface could not process some of the lines in the batch as they are locked by another process.

Solution

確認是否有相同的Transaction Data 存在MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_TRANSACTIONS_INTERFACE，理論上同一筆Material Transaction 資料不會同時出現兩個Tables，如果有的話就有問題，Oracle建議刪除MTL_TRANSACTIONS_INTERFACE的資料。

所以我的作法是

1. 先備份Table

CREATE TABLE xxdii_mti_aug10 AS
SELECT mti.*
  FROM MTL_TRANSACTIONS_INTERFACE mti
     , mtl_parameters mp
WHERE  mp.organization_id = mti.organization_id AND mp.attribute6 = 'Y' AND mti.organization_id =93 AND mti.shipment_number='2155222'

/* Formatted on 2010/08/31 18:06 (Formatter Plus v4.8.8) */
CREATE TABLE xxdii_mtli_aug10 AS
SELECT mtli.*
  FROM mtl_transaction_lots_interface mtli
WHERE EXISTS (
          SELECT mti.*
            FROM mtl_transactions_interface mti
               , mtl_parameters mp
           WHERE mp.organization_id = mti.organization_id
             AND mp.attribute6 = 'Y'
             AND mti.organization_id = 93
             AND mti.shipment_number = '2155222'
             AND transaction_interface_id = mtli.transaction_interface_id)

2.從Open interface 畫面刪除資料

3. 重新submit “Interface Trip Stop - SRS”.

PS.刪除前，一定要先備份