Sunday, 10 February 2013

What are the calendar year types used in ORACLE APPS?


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' column are used.

Note:- Carefully consider the type of calendar you need for your organization, since it can be difficult to change your calendar (e.g., from a fiscal year to a calendar year) once you've used it to enter accounting data.


Examples are as follows:

   Your fiscal year runs from April 1998 through March 1999.

   For your 1999 fiscal year, you have defined your calendar as:

      
      Prefix  Year   Period From    Period To       
     -----------------------------------------
      Apr     1999   01-Apr-1998      30-Apr-1998   
      May     1999   01-May-1998    31-May-1998
      Jun     1999   01-Jun-1998     30-Jun-1998
      Jul      1999   01-Jul-1998       31-Jul-1998
      Aug     1999   01-Aug-1998    31-Aug-1998
      Sep     1999   01-Sep-1998     30-Sep-1998
      Oct     1999   01-Oct-1998     31-Oct-1998
      Nov     1999   01-Nov-1998    30-Nov-1998
      Dec     1999   01-Dec-1998    31-Dec-1998
      Jan     1999   01-Jan-1999    31-Jan-1999
      Feb     1999   01-Feb-1999    28-Feb-1999
      Mar     1999   01-Mar-1999    31-Mar-1999

   If your Year Type is FISCAL, these are the Period Names that would be created:
                                                
      Prefix  Year   Period From    Period To     Name
      -------------------------------------------------
      Apr     1999   01-Apr-1998      30-Apr-1998    Apr-99
      May     1999   01-May-1998    31-May-1998   May-99
      Jun     1999   01-Jun-1998     30-Jun-1998    Jun-99
      Jul     1999   01-Jul-1998        31-Jul-1998     Jul-99
      Aug     1999   01-Aug-1998    31-Aug-1998   Aug-99
      Sep     1999   01-Sep-1998     30-Sep-1998   Sep-99
      Oct     1999   01-Oct-1998     31-Oct-1998   Oct-99
      Nov     1999   01-Nov-1998    30-Nov-1998   Nov-99
      Dec     1999   01-Dec-1998    31-Dec-1998   Dec-99
      Jan     1999   01-Jan-1999      31-Jan-1999   Jan-99
      Feb     1999   01-Feb-1999     28-Feb-1999   Feb-99
      Mar     1999   01-Mar-1999     31-Mar-1999   Mar-99

   If your Year Type is CALENDAR, these are the Period Names that would be created:
                                                
      Prefix  Year   Period From    Period To     Name
      -------------------------------------------------
      Apr     1999   01-Apr-1998    30-Apr-1998      Apr-98
      May     1999   01-May-1998    31-May-1998   May-98
      Jun     1999   01-Jun-1998    30-Jun-1998     Jun-98
      Jul     1999   01-Jul-1998    31-Jul-1998        Jul-98
      Aug     1999   01-Aug-1998    31-Aug-1998   Aug-98
      Sep     1999   01-Sep-1998    30-Sep-1998   Sep-98
      Oct     1999   01-Oct-1998    31-Oct-1998   Oct-98
      Nov     1999   01-Nov-1998    30-Nov-1998   Nov-98
      Dec     1999   01-Dec-1998    31-Dec-1998   Dec-98
      Jan     1999   01-Jan-1999    31-Jan-1999   Jan-99
      Feb     1999   01-Feb-1999    28-Feb-1999   Feb-99
      Mar     1999   01-Mar-1999    31-Mar-1999   Mar-99