[求教!]日历设置中的季度设置错了!

rongren

好像metablink就是这样说的
1、修改 gl_periods和gl_period_statuses
2、TRUNCATE TABLE GL.GL_DATE_PERIOD_MAP，然后运行$GL_TOP/ADMIN/SQL/GLUABCAL.sql
但我发现ar_periods也存储记录

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.

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.