QUOTE:
原帖由
ludongan 于 2008-6-25 10:41 发表
搭著順風車問下，如果所有異動沒有發生，並且還沒有打開過會計期，是否可以修改
这种情况下，oracle有类似的更改Calendar的方法，原文如下：
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.
----------------------
没有测试过，楼主试试看，给大家一个答案
