Oracle ERP R12. CST_INVALID_WIP (The wip entity is either not defined or does not have a period balance entry.) - Discrete Job

Cause :

Records not found in WIP_PERIOD_BALANCES

(該工單於WIP_PERIOD_BALANCES裡，少了該交易期間的資料)

Solution :

I. Normally, when there are records in MTL_MATERIAL_TRANSACTIONS with the　Costed_Flag = 'E' you would resubmit these records by doing the following :

  （一般而言，若MMT裡有發現COSTED_FLAG=E時，正常異常排除的步驟如下）

  a. Backup the rows to be updated.　（將資料備份下來）

  b. Turn off the Cost Manager.　（先暫停Cost Manager，以避免干擾接下來要執行的步驟）

  c. Run the SQL statement:　（執行以下SQL）

     UPDATE MTL_MATERIAL_TRANSACTIONS

        SET costed_flag          = 'N',

            error_code           = NULL,

            error_explanation    = NULL,

            transaction_group_id = NULL

      WHERE organization_id =

        and transaction_source_id =

        and costed_flag IS NOT NULL;

II. When this does not work, it is usually due to one or more of the following three conditions.

    (若異常狀況仍存在，則可以是以下原因造成) 

   * Item costs are not defined for Frozen cost type in CST_ITEM_COSTS.

　　（CST_ITEM_COSTS沒有該品號的Frozen cost）

     ==> 請補建Item Cost 並Copy cost至Forezen cost

     

   * WIP_PERIOD_BALANCES is missing rows for the acct_period_id.

　　 (該工單於WIP_PERIOD_BALANCES缺少該期間的餘額資料)

     ==> 請於WIP_PERIOD_BALANCES補該筆工單該Period的資料

     

    NOTE:  THIS DOES NOT APPLY TO CLOSED DISCRETE JOBS WDJ.STATUS_TYPE = 12

    (注意 : 該動作不適用於Closed的工單)