Calendar Switch Over

There may be a time to change the calendar from 4-4-5 to monthly, fiscal to calendar, and from one accounting year (eg: April to March may be chaned to Jan to Dec or vice versa) to another.

I have written this paper for one of my client during upgrade from 5.7 to 5.10 version in 11i.


Oracle Solution

The supported solution is to create a new calendar and a new set of books. Run Consolidation to move the General Ledger data from the old set of books to the new set of books. Need to re-install sub ledgers so they will use the new set of books.


Solution One

Upgrade from 5.7 to 5.10 and keep as it is. Create another SOB for glade and perform the rollout based on client structures. In this case two SOB will be there and need to perform consolidation to get consolidated results. It is the standard functionality of oracle to consolidate the multiple SOB to get consolidated results. No need to perform calendar changes. The following tasks need to be performed:

1.Perform upgrade from 5.7 to 5.10 for client and leave as it is
2. Create another SOB for Glade Dale and perform rollout
3. Create one more SOB for consolidation so that it will not affect the existing SOB having data. It is dedicated only for consolidation.
4. Perform consolidation every month to get consolidated data.

Note: Supported solution.

Solution Two

Create a new set of book, calendar and perform consolidation. Identify the new SOB id and replace old SOB id with this new id to all the existing sub ledgers org wise. The following tasks need to be performed:

1.New Calendar
2.New SOB using the new calendar
3.Consolidate the old SOB with new SOB for data transfer
4.Point all sub ledgers to new SOB id org wise. It will avoid re-installation of sub ledgers.
5.Create New fixed assets Depreciation book, calendar, prorate convention, assets category etc., - 6 books must be created for each Org in FA. Oracle Assets uses its own fiscal year and calendar so in terms of year to date figures within Assets the numbers will be based on the Assets calendars not GL.
6.Export the fixed assets data electronically from old fixed assets book to excel
7.Import the data from excel to new fixed assets book after verifying the category combination, fixed assets life, depreciation methods etc.

Note: Not supported solution.

Solution Three

Changes the SOB name through examine option in Book form itself. Ensure that all the periods in GL are in never opened status. If it is otherwise, change into this status through changing the GL-PERIOD_STATUSES. Ensure in the same way for all budget and encumbrance periods. Track all the budgeted data and recurring invoices/journals data for those periods. Make changes in organization forms for new multi org and SOB. The following tasks need to be performed:

1.Change the SOB name in book window
2.Make the changes in GL_PERIOD_STATUSES to keep all the future periods in never opened status.
3.Make necessary changes in the existing calendar window for converting from fiscal year to calendar year
3.Make necessary changes in organization window for new multi org and SOB
4.Track the future periods budgeted data and recurring invoices/journals
5.Make necessary changes in PA_PERIOD_ALL
6.Create New fixed assets Depreciation book, calendar, prorate convention, assets category etc., - 6 books must be created. Oracle Assets uses its own fiscal year and calendar so in terms of year to date figures within Assets the numbers will be based on the Assets calendars not GL.
7.Export the fixed assets data electronically from old fixed assets book to excel
8.Import the data from excel to new fixed assets book after verifying the category combination, fixed assets life, depreciation methods etc.



Solution Four

Create a new set of book, calendar and perform consolidation. In this case, we need to reinstall the sub ledgers (setting up the sub ledgers under multi org concept). We can retain the same responsibilities and user name just by changing the profile options wherever it is necessary. The following tasks need to be performed:

1. Create new calendar
2. Create new SOB using the new calendar
3. Re-install the sub ledgers
4. Perform opening balance conversions