How to Change the First Accounting Open Period

goal: How to Change the First ever Open Accounting Period
fact: Oracle General Ledger
fact: GLXOCPER - Open and Close Periods
fact: If you try to change it you get FRM-40200

fix:
The best solution is to start again so you know exactly what has happened 
to the new set of books but sometimes the setup of subledgers connected to this
set of books wil make alternatives worth considering:
1. Make sure no transactions exist in the Set of Books.
a. Determine the Set of Books ID. 
b. Look for no transactions posted in GL_BALANCES table. 
   Using SQL*Plus with APPS schema user.
   Select count(*)
   From   gl_balances
   Where  set_of _books_id = &Set_of_books_id;
c. Look for transactions in GL_JE_LINES table.
   Using SQL*Plus with APPS schema user.
   Select count(*)
   From   gl_je_lines
   Where  set_of_books_d = &Set_of_books_id;
If records are returned then consider the sense of changing the start period when journals 
already exist. This will not affect the fix but should be looked at.
d. Look for transactions in GL_INTERFACE table.
   Using SQL*Plus with APPS schema user.

   Select count(*)
   From   gl_interface
   Where  set_of_books_d = &Set_of_books_id;
If records are returned it means the subledgers are already opened with the 
existing period and pointing to this set of books. This does not affect the fix but consideration should be 
given as to whether making an earlier first period will affect the subledger 
concerned. Generally it will not but you may not be able to open the earlier 
period in the subledger. 
2. Define a new set of books using the Calendar, Currency and Accounting 
Flexfield structure used in the Set of Books where first period was opened 
incorrectly.
   (N) Setup > Financials > Books > Define
3. Change the Set of Books Name associated with each responsibility by the new
name created in the previous step. This is defined by the profile GL: Set of Books 
Name.
   Responsibility: System Administrator
   (N) Profile -> System
Please ask for support's help if you have subledgers setup and are unable to duplicate the
setup with iSetup. Quote this note number.

below method  waiting for testing and it should not have transaction in new period

第一步：
update gl.gl_sets_of_books t
set t.latest_opened_period_name='', t.latest_encumbrance_year=''
where t.set_of_books_id =:set_of_books_id
第二步：
update gl.gl_period_statuses t
set t.closing_status='N'
where t.application_id=101
and t.set_of_books_id=:set_of_books_id
and t.period_year='2011'
第三步：
进入系统重新打开第一期期间即可！

 

How to open the first accounting open period
http://wenku.baidu.com/view/5aeab32e0066f5335a812136.html