How to Re-open a Final Closed OPM Inventory Period in 11i?

Note:

1. You can use these scripts when rest of the Process like Final Cost Update, Final Sub-ledger Update, Transfer and Post to GL is not done.
2. It is always a best practice to first test in your test instance.

The following script will reverse the final closed OPM Inventory period to Preliminary close status.

update ic_cldr_dtl
set closed_period_ind = 2
where orgn_code = upper('&&orgn_code')
and fiscal_year = &&fiscal_year
and period = &&period

Provide the following parameters,

Orgn_code -- provide the Operating Unit (Ex: abs)
Fiscal_year -- give the fiscal year (Ex: 2012)
Period -- the period for which the status is to be changed (Ex: 8)

Confirm that only 1 row gets updated.

update ic_whse_sts
set close_whse_ind = 2
where fiscal_year = &&fiscal_year
and period = &&period
and whse_code in ('XXX','YYY','ZZZ')

Parameters:

Fiscal_year -- give the same fiscal year
Period -- give the same period
Whse_code -- give all the warehouses of the Operating unit

“N” number of rows will get updated – depending upon the No. of warehouses in the corresponding Operating Unit.

Click Commit button.

If we change the value of “set closed_period_ind = 2” in the 1st query & “set close_whse_ind = 2” in the 2nd query to “1” and execute the queries in the same order, the final closed OPM Inventory period will be reversed to Open status.