主题: General Ledger Open/Close Period FAQ

纵横四海

ORACLE GENERAL LEDGER
---------------------
OPEN/CLOSE PERIOD
----------------
FREQUENTLY ASKED QUESTIONS
--------------------------
August 2002

CONTENTS
--------
1.  If we open the first period of the new year, can we still process
entries for the prior year(s)?
2.  I opened the first period of the new year without closing the prior year.
Will this cause a problem?
3.  The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?
4.  We opened a period by mistake and need to set the status back to future
enterable? Can we do this?
5.  We created new periods after the last period defined was opened. Now we
can not see those new periods on the Open/Close form.
6.  Can I add a 13th period to my calendar?
7.  How do you open a permanently closed period?
8.  Is there a way to automatically open General Ledger periods?
9.  Open Period program is stuck in module gllock
10. Is there a way to get a Closing Journal

QUESTIONS & ANSWERS
-------------------
1.  If we open the first period of the new year, can we still process
entries for the prior year(s)?
Answer
------
Yes. You can still create entries for any period that has a status of Open
or Future Enterable. You can post to any period that has a status of Open.
If you post in a prior fiscal year, the balanced will be rolled foward and
retained earnings will be updated as needed.

2.  I opened the first period of the new year without closing the prior year.
Will this cause a problem?
Answer
------
No. Closing a period in General Ledger does nothing more than close that
period. There is no processing that goes on behind the scenes when you close
a period.

3.  The first period of my new fiscal year was opened and closed. What are
the ramifications to the roll forward process and retained earnings?
Answer
------
None. General Ledger will properly maintain the balances for the new year,
regardless of how many times the periods are opened or closed. Retained
earnings is calculated when the first period of the new year is initially
opened, and thereafter when any posting is done to a revenue or expense
account in a prior year.

4.  We opened a period by mistake and need to set the status back to future
enterable? Can we do this?
Answer
------
No. There is no way within the application to set the period status back
to Future Enterable after the period has been opened. To do so would lead
to data corruptions on a large scale.

5.  We created new periods after the last period defined was opened. Now we
can not see those new periods on the Open/Close form.
Answer
------
When Open Period runs, it sets the status of the next X periods to Future
Enterable. On the Set of Books form, you define the number of Future
Enterable periods. If, when you open a period, there are no subsequent
periods defined, the Future Enterable periods can not be updated. When
you define new periods in the calendar, the status will remain Never
Opened, until you open the next period. At that time, the program will
update the status to Open on the next period, and will update the status
to Future Enterable on the next X periods.

6.  Can I add a 13th period to my calendar?
Answer
------
No. You associate a Period Type with a Set of Books. The Period Type
is defined to have a fixed number of periods. That is the number of periods
you must define for your set of books - no more and no less.

7.  How do you open a permanently closed period?
Answer
------
You cannot open a period that has a status of Permanently Closed within the application.
If this is an important issue and you have not archived this data log a Service Request in
Metalink to see if Oracle can help.

8.  Is there a way to automatically open General Ledger periods?
Answer
------
No. There is no way within General Ledger to do this

9. Open Period program is stuck in module gllock
Answer
------
1. If there is another Open Period program still running for the current set of
books, let it continue to completion.
2. If there is no other Open Period program running for the current set of
books try the sql suggested Note 233150.1 or 134007.1 for cleaning up concurrent requests.
See Bug 2954000 - WHEN OPEN PERIOD IS INTERRUPTED, IT DOESN'T RESTART SUCCESSFULLY
Prevented in GL patchset J onwards.
more details Note 233150.1

10. Is there a way to get a Closing Journal
Answer
------
Closing Journals Income Statement Offset Option (Rel 11.5.2)   (CR 277920  PDF 134 kb)
http://metalink/cgi-bin/cr/getfile.cgi?p_attid=66935.1:277920