Sunday, March 22, 2015

Difference Between R12 General Ledger Calendar Definition And Fusion General Ledger Calendar Definition

Difference Between R12 and Fusion General Ledger Calendar Definition

Oracle Fusion General Ledger is a product of Oracle Fusion Applications.This document details out the difference between Oracle EBusiness Suite R12 and Oracle Fusion General Ledger Calendar Setup helping you to better understand the differences.

Calendar Setup Steps in R12 E-Business Suite

Calendar setup is a two step process in E-Business Suite



1) Define Period Types




















2) Define Accounting Calendar using the Period Type defined in the earlier step

















Once you define your calendar and navigate out of the Accounting Calendar setup screen the Calendar Validation Report will be submitted with an option to validate the current calendar or all the defined calendars.



Calendar Setup Steps in Oracle Fusion General Ledger

Calendar setup in Oracle Fusion General Ledger is a much more simplified process which combines both the steps of Accounting Calendar definition in a single setup flow.



Below screen shots would give an overview of the setup process of Accounting Calendar. Accounting Calendar is available under Define Calendars Task list as Manage Accounting Calendars Task




Click on the Manage Accounting Calendars Task which will take you to the Accounting Calendar setup screen.



This is a simplified screen where you define the details of your Accounting Calendar and default options are provided for making it easy to define calendars based on frequently used period frequency and adjusting period frequency. In case more flexibility is required period and adjusting frequency can be chosen as Other.




Once you fill up the other details then click Next to go on to the screen where you define the period details for your calendar.




After defining the required periods for your calendar you can save the changes. This will fire the calendar validation for the period ranges defined for any overlap of period date ranges and gaps in the period date range definition.

The tables affected while defining calendar in E-Business Suite and Oracle Fusion General Ledger are the same: GL_PERIOD_TYPES for the calendar type definition, GL_PERIOD_SETS for the calendar name details and GL_PERIODS for the individual period details in the calendar.GL_DATE_PERIOD_MAP stores the correlation between dates and non-adjusting periods for each accounting calendar and period type combination.


Details which are entered in the first screen in Fusion Calendar definition like the frequency,adjustment periods etc are stored in GL_CALENDARS a major table addition in Fusion.Also addition of an ENTERPRISE_ID column in Oracle Fusion General Ledger for GL_PERIODS table which provides the Business group details available.


The significant difference between the Accounting Calendar definitions in E-Business Suite and Oracle Fusion General Ledger is that, in Fusion, the definition is greatly simplified.  Fusion General Ledger provides the flexibility of default calendar templates for period frequency (ie Monthly) and online calendar validation while saving the calendar details



For further table related details in Fusion Applications can refer to Fusion Applications OER

No comments:

Post a Comment