Oracle EBS: 重新開啟已關閉之inventory期間

由於疫情問題造成大陸的廠還沒結一月帳, 過完年回來開工, 為了intercompany資料, 要把HQ的一月期間打開.

Forms上的 [Change Status] 按鈕反灰, 不能作, 在Oracle網站找到相關文章.


步驟:

1.備份以下table:
  org_acct_periods
  mtl_period_summary
  mtl_period_cg_summary
  mtl_per_close_dtls
  cst_period_close_summary

2.
  SELECT acct_period_id period, open_flag, period_name name,
  period_start_date, schedule_close_date, period_close_date
  FROM org_acct_periods
  WHERE organization_id = &org_id
  order by 1,2;

3.
  UPDATE org_acct_periods
  SET open_flag = 'Y',
  period_close_date = NULL,
  summarized_flag = 'N'
  WHERE organization_id = &&org_id
  AND acct_period_id >= &&acct_period_id;

  DELETE mtl_period_summary
  WHERE organization_id = &org_id
  AND acct_period_id >= &acct_period_id;

  DELETE mtl_period_cg_summary
  WHERE organization_id = &org_id
  AND acct_period_id >= &acct_period_id;

  DELETE mtl_per_close_dtls
  WHERE organization_id = &org_id
  AND acct_period_id >= &acct_period_id;

  DELETE cst_period_close_summary
  WHERE organization_id = &org_id
  AND acct_period_id >= &acct_period_id;

4. commit

5.從有問題的期間開始, 依序重新執行 'Period Close Reconciliation Report'.


Ref:
1.Re-Open a Closed Inventory Accounting Period (Doc ID 472631.1)

2.HOW TO RE-OPEN A CLOSED INVENTORY ACCOUNTING PERIOD
http://www.oracleerpappsguide.com/2012/01/how-to-re-open-closed-inventory.html