From: CRAIG YEDINAK
Subject: GL: Accounting Calendar Change
Hi, We have a fairly major/urgent issue with our accounting calendar. We are running on 10.7 NCA, and the main modules that we use are OE, AR, GL and Inventory. The Accounting Calendar has been set-up incorrectly for the current year - including this month! The problem is that of course this month and year have already been opened. The documentation that I have looked at so far says that the period MUST never have been opened if you want to change the dates of your calendar. Has anyone else ever has this problem? Any thoughts/ideas on how to solve this would be greatly appreciated. Regards, Divya. Dell Computer Corp.
x-------------x
From: Bill Keenan [mailto:bkeenan@goodegg.com]Sent: Friday, June 11, 1999 3:20 AM
Subject: MODIFYING G/L CALENDAR
Hi All,
We are currently upgrading to 11.02 from 10.7, and have taken this opportunity to change our Accounting calendar in the new 11.02 system. Basically we want to go to a standard 4-4-5 calendar, and to do so we need to add 4 additional days to our year-end period, 12-99 (which will also get us in sync with other aspects of our business). Our fiscal year ends in June, A/P and Purchasing are already keying in data in 12-99, so I am not allowed to update my G/L Accounting Calendar.
I would like to go ahead and change this in the GL_Periods table, just adding the 4 days to the last period (in the old 10.7 system). The 11.02 Calendar has been set up correctly. If I do not change the end date in 12-99, AP and PO will post 4 days to 1-00, where they should be reflected in period 12-99 of the G/L.
If I haven't confused you, my question is can I update the end_date of period 12-99 from 27-JUN-1999 to 01-JUL-1999 in the GL_Periods table without effecting anything else? I know Oracle won't support this, however this is the only way we can think of to keep Paybles and Purchasing data and reports in sync with G/L.
Thank you very much for your help/comments!!!
Bill
Date: Mon, 14 Jun 1999 17:45:01 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
Subject: RE: MODIFYING G/L CALENDAR
Bill
I have recently made changes to future periods in our GL calendar, even
though the form wouldn't let me because of budgets loaded.
In order to get the form to correctly replicate the dates through the
modules I chose to do it by switching off validation and doing it through
the form, rather than directly via SQL. The relevant validation is in the
server side package gl_periods_pkg.
I modified the package to return true even if it found future
transactions/budgets. After making the changes I put it back and then
checked all the calendar related tables. It has worked fine.
Calendar tables for GL/etc are gl_periods, gl_period_statuses and
gl_date_period_map. AR has ar_periods. INV has org_acct_periods.
BOM/MRP/etc has bom_period_start_dates, but this isn't linked. If you want
to look for all period related tables, the following is useful:
select t.owner||'.'||t.table_name||'.'||t.column_name
from all_tab_columns t,
all_objects o
where t.column_name in ('PERIOD_NUM', 'PERIOD_YEAR', 'PERIOD_NAME')
and t.table_name = o.object_name
and o.object_type = 'TABLE'
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
From: Sussman, Evelyne [mailto:Evelyne.Sussman@Dialogic.com]
Sent: Thursday, June 24, 1999 10:58 AM
To: 'NWoollaston@swichtec.co.nz'
Subject: GL Calendar change
Hi Nicholas,
I was searching the Oracle archives and I saw your posting on Wed, 13 Jan
1999, about how your company "created a new set of books with the new
calendar. The journals were copied across and the id's on the SOBs and
calendars were then swapped (so that the subledger interfaces wouldn't have
to be changed). We have ended up with two SOBs, one for each calendar, so
that we can report out of either for the overlapping period."
Our company needs to change our existing calendar to a 4-4-5 calendar. We
have many of the subledgers (AR, AP, Fixed Assets, every MFG module etc... )
We also have budgets loaded for 1999. We know that Oracle does not support
anything other than creating a new set of books. That is not possible for us
right now because we have only one week to change our calendar. The first
change of dates need to occur for July.
You did write that you weren't closely involved, but if you can please
forward this email to the person who was, and ask him for any advice as to
how he did that, it would be GREATLY appreciated.
Thank you so much,
Evelyne Sussman
System Analyst
Dialogic Corporation
1515 Route 10
Parsippany, NJ 07054
Phone (973) 993-3000 ext 6449
Fax (973) 993-3093
mailto:e.sussman@dialogic.com e.sussman@dialogic.com
Date: Thu, 24 Jun 1999 12:37:48 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
To: "'Sussman, Evelyne'" Evelyne.Sussman@Dialogic.com
Subject: RE: GL Calendar change
Evelyne
We have been through this exercise three times recently, due to having
changed hands several times. The first time we changed year end, but left
the period dates the same. The second time we changed year end and also
changed from calendar periods to 445. The third time we changed our period
dates only, moving the period end from Sat to Thur, but leaving the year end
dates the same (we have funny length periods at start and end of year).
Advice from Oracle was that we needed to do the SOBs switch for the year end
changes because we were already part way into the year (our first two
changes). Changing future period dates only (our third change) did not
require new SOBs.
So if you are changing to 445 for future periods only, without changing your
year end, you should be able to do it without new SOBs.
We are using 10.7 on NT with SC 16.1 client.
The GL calendar form won't let you change even the future periods because of
budgets loaded.
In order to get the form to correctly replicate the dates through the
subledgers I chose to do it by switching off validation and making the
changes the form, rather than directly via SQL. The relevant validation is
in the server side package gl_periods_pkg.
I modified the package to return true even if it found future
transactions/budgets. After making the changes I put it back and then
checked all the calendar related tables. It has worked fine. But I have to
emphasise that this was for future periods only, where no transactions
already existed.
Calendar tables for GL/etc are gl_periods, gl_period_statuses and
gl_date_period_map. AR has ar_periods. INV has org_acct_periods.
BOM/MRP/etc has bom_period_start_dates, this isn't linked directly, but you
will probably want to do it anyway (it has to be done separately through BOM
setup calendars - regenerate through the special menu). If you want to look
for all period related tables, the following is useful:
select t.owner||'.'||t.table_name||'.'||t.column_name
from all_tab_columns t,
all_objects o
where t.column_name in ('PERIOD_NUM', 'PERIOD_YEAR', 'PERIOD_NAME')
and t.table_name = o.object_name
and o.object_type = 'TABLE'
Check for already posted transactions in GL_JE_LINES, etc for the periods
you are changing. If there is anything you have to check that the
period_name/effective_date won't come into conflict because of your changes.
If necessary you will have to move things, but that could get rather messy.
Also your budgets may need to get reloaded to match the new period lengths,
but there is standard functionality for this.
select *
from gl_je_lines
where set_of_books_id = ...
and effective_date ...
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
Closing Periods
Date: 31 Mar 99 09:33:53 PST
From: Roger Drolet rdrolet@netscape.net
Subject: Re: [GL: Closing Periods]
Scott,
Except at year-end, I don't know any practical reason for concern. The
periods can remain open and still allow each company to close its books.
Obviously, this means that something could still be posted to the GL.
However, you can restrict access to this function.
Yes, at year-end you will have to co-ordinate the closing process between
companies until each company is ready to close.
Roger Drolet
Managing Associate
Conley, Canitano & Assoc., Inc.
"Tylski, Scott" TylskiS@kochind.com wrote:
Our company is in the process of implementing Oracle 10.7 NCA. We have o
ne
database instance. Our balancing segment in the accounting flexfield is
'company'. We have many company values. We only currently have two sets
of
books - one for the United States and one for Brazil. We will have more
in
the future based on different currencies. All but one of our current
company values are located in the U.S. set of books.
It is our understanding that periods are closed by sets of books. This
requires that each company in our U.S. set of books be able to close on o
ne
particular work day. Due to our wide array of companies, this single clo
se
date is fairly unrealistic.
Are there in options in Oracle to allow for different closes by company
value? We think we could set up more sets of books, but we are not sure
we
want to lose some of the reporting capabilities (we haven't really planne
d
on using the consolidation functionality in Oracle).
Any suggestions would be appreciated.
Scott Tylski
Koch Industries, Inc.
Shared Service Center - Master Data
(316) 828-8189
tylskis@kochind.com
Date: Wed, 31 Mar 1999 15:49:37 -0500
From: Steve Bradley sbradley@sprynet.com
Subject: Re: [GL: Closing Periods]
Actually, the year end process is no different than any other period as far
as closing GL is concerned. You can keep Dec. open indefinitely. Keeping
a period open in GL does have a negative effect though. The default period
for all manual JE's is the "oldest open period"! This can cause major
problems if people are not diligent about changing the default period to
the correct period.
I had a client who had a similar situation with 2 divisions using the same
set of books. One closed in 6 days and the other in 30 (they had
international subsidiaries). We ended up modifying the manual JE screen
for the international people. They could Quickpick any open or closed
period (within 6 prior months) for the JE period. Standard Oracle only
lets you Quickpick Open or Future periods - not closed. We had a posting
program that ran at night look for JE's for closed periods. If found, the
program opened the appropriate period, posted the journals and closed the
period. Since this happened at night it did not affect manual entry during
the day. This may not be an option for you if you do not have a scheduler
running at night.
Respectfully,
Steve Bradley, CPA
OASIS Consulting Group, Inc.
Office 404-352-8387
Fax 404-609-9856
Pager 888-912-2569
GL open/close periods
Date: Mon, 14 Jun 1999 01:53:51 PDT
From: Krishna Bangalore vkkrish@hotmail.com
Subject: reg : GL open/close periods,
Hi,
Hi everybody,
We are working Oracle Applications 11.0.2,Windows NT 4.0 and service pack
3.
We have two set of books(We have implemented MRC). One for functional
currency and the other for reporting set of books used by MRC. We have
applied all the MRC patches as suggested by Oracle Corp.
We see the period(ex May-99) open on the screen, but the period is open
for the primary set of books and closed report set of books in the database.
Has anybody encounterd the same. Can anybody provide us with solution.
Thanks in advance.
Date: Mon, 14 Jun 1999 16:00:25 +0530
From: Deepak Vasanth Mulajkar DeepakMulajkar@inf.com
Subject: RE: reg : GL open/close periods,
Hi Krishna,
This is normal. You need to Open Periods for Primary as well as reporting
SOBs individually. Opening a period in primary SOB does not automatically
open the period in Reporting SOBs. You need to do that manually.
There are a lot of other things which you need to do manually. Please refer
the diagram below.
Regards
Deepak
Date: Mon, 14 Jun 1999 20:47:53 PDT
From: Krishna Bangalore vkkrish@hotmail.com
Subject: reg : GL open/close periods, Response
Hi Murali and Deepak,
Thanks for your response.
We opened the GL period(JUL-99) for primary set of books the period got
opened, we check the same period for the reporting set of books and that too
showed open on the screen.
We executed the following select statement on the database
select set_of_books_id,application_id,closing_status
from gl_period_statuses
where period_name='JUL-99' AND application_id=101
it showed 'O' for the primary set of books and 'N' for reporting set of
books.
We went into open/close of reporting set of books and tried to open
JUL-99, but it was pointing to 'AUG-99' as next open period.
We tried to close, JUL-99 in the reporting set of books , it showed
closed on the screen but,when the same select statement was executed it
still showed 'N'
Hope this explains the situtaion better.
Kindly help to sort out this issued.
Regards
Krishna
vkkrish@hotmail.com
Date: Tue, 15 Jun 1999 06:36:48 -0700 (PDT)
From: Murali Avanamuthu mavanamuthu@yahoo.com
Cc: vkkrish@hotmail.com
Subject: Re: ORAAPPS-L digest 3301
Hi Krishna,
Looks like your setup has a flaw. Please check the
following profile options at the responsibility level.
GL: Set of Books name for primary should point to
primary book and for reporting to reporting book.
(Sounds very obvious). But from your description of
the problem, it seems that you think you were in
reporting, but actually due to this profile you're in
Primary!!.
The next profile is MRC: Reporting set of books. This
would be null for primary responsibility and set to
reporting book for reporting responsibility.
I also assume that you've done the MRC Assign books
screen to its completion. Please re-check all the MRC
related set-up steps. It's better to prevent rather
than to fix problems.
Good luck,
Murali
Changing GL Dates
Date: Tue, 15 Jun 1999 18:10:15 -0400
From: "Debbie Morrill" MorrilDG@obg.com
Subject: GL:Changing GL Dates
Has anyone had experience changing GL start and end dates after they have
been opened?
Thanks in advance for any help.
Date: Tue, 15 Jun 1999 18:23:47 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: GL:Changing GL Dates
I'd like to know the answer to this as well, as I need to change the
end_date of this month (June). Please forward any responses that are sent
directly to you to me.
Thank you,
Bill
Date: Wed, 16 Jun 1999 10:53:11 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
Subject: RE: GL:Changing GL Dates
Bill/Debbie
I have recently made changes to future dates in our GL calendar (10.7SC),
even though the form wouldn't let me because of budgets loaded.
In order to get the form to correctly replicate the dates through the
modules I chose to do it by switching off validation and doing it through
the form, rather than directly via SQL. The relevant validation is in the
server side package gl_periods_pkg.
I modified the package to return true even if it found future
transactions/budgets. After making the changes I put it back and then
checked all the calendar related tables. It has worked fine.
Calendar tables for GL/etc are gl_periods, gl_period_statuses and
gl_date_period_map. AR has ar_periods. INV has org_acct_periods.
BOM/MRP/etc has bom_period_start_dates, but this isn't linked. If you want
to look for all period related tables, the following is useful:
select t.owner||'.'||t.table_name||'.'||t.column_name
from all_tab_columns t,
all_objects o
where t.column_name in ('PERIOD_NUM', 'PERIOD_YEAR', 'PERIOD_NAME')
and t.table_name = o.object_name
and o.object_type = 'TABLE'
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
x-------------x
From: Bill Keenan [SMTP:bkeenan@goodegg.com]Sent: Thursday, June 24, 1999 3:13 AM
Subject: GL calendar update question
Hi All,
Can anyone tell me what the gl_date_period_map table does, or where I can see it on forms side. I recently updated our G/L calendar, advancing period 6-99 an extra four days. I didn't, however, update the gl_date_period_map table, and did not see any effect of this when doing testing (all subledgers closed out correctly, all reports were ok).
Do I need to add these four days to the gl_date_period_map table?
Thank you in advance for your help. Bill
Date: Thu, 24 Jun 1999 12:08:24 +0300
From: Ilya.Gandzeychuk@Kvazar-Micro.com
Subject: RE: GL calendar update question
Hi Bill,
I didn't try to modify periods date range. But if gl_date_period_map wasn't
updated you can try to use procedure maintain_date_period_map from package
gl_date_period_map_pkg.
Table gl_date_period_map is using with daily/average balancing. For example,
see view GL_DAILY_BALANCES_V.
Regards,
Ilya