主题:How to Change the First Accounting Open Period
文档 ID:注释:157642.1 类型:HOWTO
上次修订日期:30-OCT-2007 状态:PUBLISHED
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
Whereset_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
Whereset_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
Whereset_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.
经过不懈的奋斗，终于让我找到更好的解决方法了！
第一步：
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'
第三步：
进入系统重新打开第一期期间即可！
OH，YEAH
经过不懈的奋斗，终于让我找到更好的解决方法了！
第一步：
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'
第三步：
进入系统重新打开第一期期间即可！
OH，YEAH
经过不懈的奋斗，终于让我找到更好的解决方法了！
第一步：
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'
第三步：
进入系统重新打开第一期期间即可！
OH，YEAH
