Oracle EBS: CST_INVALID_WIP error

錯誤訊息:

CST_INVALID_WIP error The wip entity is either not defined or does not have a period balance entry

狀況:
1.transaction停在pending, 無法產生分錄
2.transaction_source_id是個很大的負值 (後來才注意到)

解法:
1.請user提供交易當時所處理的工單
2.對應出wip_entity_id, 並更改transaction_source_id
3.重新處理未產生分錄的交易


後記:

原先以為是曾發生過的WIP_PERIOD_BALANCES無資料, 後來比對才發現transaction_source_id有問題, 目前還不知道原因.


參考資料都找了, 還是列一下.

補入資料:
INSERT INTO WIP_PERIOD_BALANCES
 (ACCT_PERIOD_ID, WIP_ENTITY_ID,
  REPETITIVE_SCHEDULE_ID, LAST_UPDATE_DATE,
  LAST_UPDATED_BY, CREATION_DATE,
  CREATED_BY, LAST_UPDATE_LOGIN,
  ORGANIZATION_ID, CLASS_TYPE,
  TL_RESOURCE_IN, TL_OVERHEAD_IN,
  TL_OUTSIDE_PROCESSING_IN, PL_MATERIAL_IN,
  PL_MATERIAL_OVERHEAD_IN, PL_RESOURCE_IN,
  PL_OVERHEAD_IN, PL_OUTSIDE_PROCESSING_IN,
  TL_MATERIAL_OUT, TL_MATERIAL_OVERHEAD_OUT, TL_RESOURCE_OUT,
  TL_OVERHEAD_OUT, TL_OUTSIDE_PROCESSING_OUT,
  PL_MATERIAL_OUT, PL_MATERIAL_OVERHEAD_OUT,
  PL_RESOURCE_OUT, PL_OVERHEAD_OUT,
  PL_OUTSIDE_PROCESSING_OUT,
  PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
  PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
  PL_OVERHEAD_VAR, TL_MATERIAL_VAR, TL_MATERIAL_OVERHEAD_VAR,
  TL_RESOURCE_VAR, TL_OUTSIDE_PROCESSING_VAR,
  TL_OVERHEAD_VAR)
VALUES
  (xxxx, yyyy, NULL, SYSDATE, 0, SYSDATE, 0, 0,
  zzzz, ct, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

其中:
  xxxx : Acct_period_id
  yyyy : wip_entity_id
  zzzz : organization_id
  ct   : class_type


Ref:
1.Oracle ERP R12. CST_INVALID_WIP (The wip entity is either not defined or does not have a period balance entry.) - Discrete Job
http://doggww.blogspot.com/2013/02/oracle-erp-r12-cstinvalidwip-wip-entity.html

2.CST_INVALID_WIP error The wip entity is either not defined or does not have a period balance entry (Doc ID 1531200.1)