General Ledger Calendar FAQ [ID 134362.1]
Applies to:
Oracle General Ledger - Version: 11.5Oracle General Ledger - Version: 11.5 and later [Release: 11.5.0 and later]
Purpose
When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar Setup and Usage at Note:130539.1Questions and Answers
1. You can change a period's specifications, except for the period type, as long as the period has not been used in a set of books.
You cannot change a calendar period that is open, closed, future enterable, or permanently closed in any set of books, or is included in an open budget or encumbrance year.If it is difficult to use the periods as is, the best solution is to create a new set of books that uses a new calendar with the correct period dates. You can run Consolidation to move the General Ledger
balances from the old set of books to the new set of books. For step by step instructions on the Consolidation process, refer to the Oracle General Ledger User's Guides.
This may also mean that you need to re-install your subledgers so they will use the new set of books. To avoid this see Note:157642.1 How to Change the First Accounting Open Period
References: Note:76503.1 - Scripts to check calendar setup
2. Can I add an adjusting period to my calendar?
You can only define the number of periods that is specified by the Period Type you are using for your set of books. For example, if, for your set of books, you are using a Period Type of Month, and Month is defined to have 12 periods per year, you can only define 12 periods of Period Type Month for any one year, on theCalendar form.
3. You defined a Period Type and now have decided that you want to change the periods per year that are associated with the Period Type. How can you do this?
Once you define a Period Type and save it, you cannot change it. If you need to change the number of periods then you have to define a new Period Type and a new Set of Books to use that new Period Type.4. What are the year types 'Fiscal' and 'Calendar' used for ?
The Year Type (Fiscal or Calendar), is used only to determine which two digits to append to the system generated period name.Regardless of which Year Type is used, the 'Year' entered on the Calendar form must be the same for all periods in your fiscal year - whether it is a calendar year or a fiscal year.
If Year Type = Calendar:
The last 2 digits of the 'From' date for the period are used.
If Year Type = Fiscal:
The last 2 digits of the value in the 'Year' are used.
References: Note.1013624.102 What are the year types 'Fiscal' and 'Calendar' used for?:
5. You are setting up a new set of books and calendar and not sure how much of the first year you need to define in the calendar. Do you need to define an entire year for the first year if you are only going to open the last period.
No, you do not have to define the entire year. You only define the periods you need, but of course without gaps between periods. Remember to define one prior period if you will be translating.Example: You want to start entering transactions for January 2001, but you will be doing translations for January 2001 also, then you will need to define and open a period before that. In this example, December 2000. But it would be recommended to define all the periods so that the calender validation will not show any missing periods.
References: General Ledger User's Guide Note:1062487.6
6. Your calendar year is changing from fiscal year to calendar year and you already have a set of books that is using the fiscal year calendar. How can you change your calendar in GL?
There are 2 possible solutions. See Note 102460.1 for a full explanation.Example:
- Your current fiscal year runs from April 1 through March 31.
- Your new year will run from January 1 through December 31.
- You will transition to the new year beginning on January 1 of the next year,
so you will have a short year from April 1 through December 31.
1) Create a new calendar and set of books
Create a new calendar, with the correct periods, and define a new set of books that uses that calendar. Run Consolidation to move your balances from the existing set of books to the new set of books.
You may also need to re-install your subledgers so they will use the new set of books.
OR
2) Update the existing calendar
a) Define the periods for your short year (April through December).
You must define the number of periods that are expected for the Period Type you are using. In this example, it is 12. So you will need to define 9 regular periods, and 3 adjusting periods. The Year
must be defined as the next sequential year.
b) Define the periods for the next year. This is the first year that runs from January through December. The Year must be defined as the next sequential year.
Note: This method depends on the subledgers taking their periods from General ledger so the periods must not already be defined. In the case of Fixed Assets, it would require major consultancy to change the year end period or YTD figures will always be inaccurate.
References: Note:102460.1 How to change GL Calendar from a Fiscal to a Calendar year?
7. You opened a period by mistake and want to set the status back to Future Enterable. How can you do this?
This is NOT supported. You can not set a period status back to future enterable after it has already been opened. If you do, it will cause corruption in the gl_balances table.8. The year was specified incorrectly on your calendar periods. How can you fix this?
You cannot make changes to calendar periods in the form if the period is in an open budget year, open encumbrance year, or the status is Open, Future Enterable or Closed.The solution is to create a new set of books that uses a new calendar with the correct period dates. You can run Consolidation to move the General Ledger data from the old set of books to the new set of books. For step by step instructions on the Consolidation process, refer to the Oracle General Ledger User's Guides.
This may also mean that you need to re-install your subledgers so they will use the new set of books.
9. The Year Type in your Period Types Form is not what you want. You used Fiscal instead of Calendar or visa versa.
The Year Type (Fiscal or Calendar), is used only to determine which two digits to append to the system generated period name.References: Note:1013624.102 What are the year types 'Fiscal' and 'Calendar' used for?
10. Can you change a period name after the calendar is defined?
If the Calendar form lets you make the change, you can do it.Otherwise, it means the period is in use, and you can not make the change.
11. What is the function of GL_DATE_PERIOD_MAP table and how is it populated?
The GL_DATE_PERIOD_MAP table stores the correlation between dates and non-adjusting periods for each accounting calendar and period type combination.There is always a one-to-one correspondence between dates and non-adjusting periods since your accounting calendar must not have any gap or overlap between non-adjusting periods.
References
NOTE:1013624.102 - What are the year types 'Fiscal' and 'Calendar' used for?NOTE:102460.1 - How to change GL Calendar from a Fiscal to a Calendar year?
NOTE:1062487.6 - Do you need to define entire calendar year if you will only use the last period?
NOTE:130539.1 - General Ledger Calendar Setup and Usage
NOTE:157642.1 - How to Change the First Accounting Open Period
NOTE:76503.1 - Scripts to Check the Setup of the General Ledger Calendar
No comments:
Post a Comment