日历会计的结束时间设置出错，怎么修改呀

rongren

我们的应用是Oracle erp 11.5
我们这里出现一个这样的问题，我们在增加日历会计时结束时间少了一天，并且在这个月的1号已经发生了分录，如果我们单纯从底层去修改gl_period gl_period_status里的结束时间，不知道 会不会有什么影响

rongren

1. Change the dates for the period using SQL*Plus.

-- Update the END_DATE in GL_PERIODS for the
affected calendar (period_set_name).

update gl_periods
set end_date = '2012-02-29'
where end_date = '2012-02-28'
and period_name = '02-12'
and period_set_name = '总帐日历';

This should update 1 row.

-- Update the END_DATE in GL_PERIOD_STATUSES for
all applications and sets of books that use this calendar.
Example:

update gl_period_statuses
set end_date = '2012-02-29'
where end_date = '2012-02-28'
and period_name = '02-12'
and set_of_books_id in ('1','2','3','4','5');


2. Truncate the GL_DATE_PERIOD_MAP table as follows:
-- After logging into sql, execute the statement

sql> TRUNCATE TABLE GL.GL_DATE_PERIOD_MAP;


3. Run the script $GL_TOP/admin/sql/GLUABCAL.sql as follows:

a) At the Unix prompt enter: cd $GL_TOP/admin/sql

b) At the next prompt enter: SQL*plus

c) Log into SQL*Plus as apps user
Enter username = apps
Enter password = apps
(or your own user defined apps account)

d) At the sql prompt enter:
sql> @gluabcal.sql

Note: Gluabcal.sql will be adding rows to gl_date_period_map
for all calendars even if they are not used so do not be surprised
to find extra rows e.g. JEBE_MONTH_VAT is seeded for Belgium localisations
so there will be many extra rows for that with a period of 'NOT ASSIGNED'.
This is harmless and can be deleted or ignored.

zhenghf

rongren 发表于 2012/2/2 18:11
1. Change the dates for the period using SQL*Plus.

-- Update the END_DATE in GL_PERIODS for the
...

这是解决方法呗？

rongren

这是上次我咨询Oracle工程师给我的解决方案