datafix for reopening or work arround

[ata_rehman70]

We need datafix for reopening
of close period please help in this respect as
my following modules ( AR, Purchas, Inventory,OPM FINANCIAL) Mar-12 are open and i have to create accounting for these modules.
The period in GL was closed mistakenly and please help in this respect.

My Question is why system allowed to Closed Permenent GL Period when others modules period are still open.

Ata ur Rehman

[admin]

Recommended way will be to create CSR with Oracle. tks

[ata_rehman70]

SR Ans from Oracle Support

"It is clearly documented that once a period is permanently closed it cannot be reopened.Nothing much can be done. "

Ata

[admin]

Pl try the following on TEST or VISION and verify one you are satisfied then only move to LIVE,

update gl_period_statuses set closing_status = 'O' where application_id = 101 and set_of_books_id = 1 and closing_status = 'P'
and PERIOD_NAME = 'Adj-99';

update gl_period_statuses set closing_status = 'P' where application_id = 101
and set_of_books_id = 1 and closing_status = 'O'
and PERIOD_NAME = 'Adj-99';

WARNING: ERPstuff will not be responsible for any loss as this is just a tip to be tested and we are not claiming it is a tested and verified way to do so.