Define Period Type and Accounting Calendar in Oracle EBS R12

The below steps need to be performed for setting up Period Type in Oracle EBS /Apps R12

Why we need Adjustment Period ?

Adjustment Period is used to make adjustment to manage the accounting entries for the reconciliation of Financial Periods. The Adjustment Period is not visible in General Ledger.

Calendar Types in Oracle EBS R12 

General Ledger uses the year type to assign a year in the accounting period . In Oracle EBS R12 Calendar can be defined in 2 ways

  • Fiscal: year in which an accounting period begins which means the Financial Year is considered as (01-Jul-20 to 30-Jun-21)
  • Calendar : year in which an accounting period ends which means the Financial Year is considered as (01-Jan-20 to 31-Dec-20)
Define Oracle Apps R12 Period Types
  • Navigate to General Ledger > Setup > Financials > Calendars > Types
  • Enter the Period Type (‘OAH Period’)
  • Enter Period Per Year (13) includes 1 Adjustment Period
  • Select Year Type as ‘Fiscal’

Define Accounting Calendar in Oracle EBS R12

Define Oracle Apps R12 Accounting Calendar

Define the 12 Periods from JAN-DEC for the specific accounting period

  • Enter the Calendar Name (‘OAH Calendar’)
  • Enter the Calendar Description
  • Enter the Period Prefix for the Accounting Period like JAN for Month January
  • Enter the Period Type defined in the Period Type Setup (‘OAH Period’)
  • Enter the Period Year in which Accounting Period to be defined (2021)
  • Enter Total Number of Quarters in an Accounting Period
  • Enter From Date ( ’01-JAN-2020′)
  • Enter To Date ( ’31-JAN-2020′)

Define the Adjustment Period as 13 Period for the specific accounting period

  • Enter the Period Prefix for the Accounting Period like ADJ for Adjustment Period
  • Enter the Period Type defined in the Period Type Setup (‘OAH Period’)
  • Enter the Period Year in which Accounting Period to be defined (2021)
  • Enter Total Number of Quarters in an Accounting Period
  • Enter From Date ( ’31-DEC-2020′)
  • Enter To Date ( ’31-DEC-2020′)

Calendar Validation 

Once the defined periods are saved in Calendar, System popups the Calendar Validation option to validate calendar period data. Select Current as the option

Oracle Apps R12 Calendar Validation

The validations are performed to validate the entered Calendar Period data

  • Validates Periods overlap
  • Validates if Periods have date gaps
  • Validates Adjustment period is checked or not
  • Validates if Period numbers are greater than the maximum period number for current period type
  • Validates if Periods are not in sequential order by date
  • Validates if Quarters are missing
  • Validates if Quarters are not in sequential order by period
  • Validates if Period numbers are missing
  • Validates if Period’s start or end dates are more than one year before or after its fiscal year

EBS R12 General Ledger SQL to get GL Code Combinations records

The blog provides the EBS R12 SQL to get GL_CODE_COMBINATIONS records bases on last_run_date update and Char of Accounts Id

SELECT GCC.CODE_COMBINATION_ID
,GCC.ALTERNATE_CODE_COMBINATION_ID
,GCC.CHART_OF_ACCOUNTS_ID
,GCC.DETAIL_POSTING_ALLOWED_FLAG
,GCC.DETAIL_BUDGETING_ALLOWED_FLAG
,GCC.ACCOUNT_TYPE
,GCC.ENABLED_FLAG
,GCC.SUMMARY_FLAG
,GCC.SEGMENT1
,GCC.SEGMENT2
,GCC.SEGMENT3
,GCC.SEGMENT4
,GCC.SEGMENT5
,GCC.SEGMENT6
,GCC.SEGMENT7
,GCC.SEGMENT8
,GCC.SEGMENT9
,GCC.SEGMENT10
,GCC.SEGMENT11
,GCC.SEGMENT12
,GCC.START_DATE_ACTIVE
,GCC.END_DATE_ACTIVE
,GCC.JGZZ_RECON_FLAG
,GCC.PRESERVE_FLAG
,GCC.DESCRIPTION
,GCC.TEMPLATE_ID
,GCC.ALLOCATION_CREATE_FLAG
FROM   GL_CODE_COMBINATIONS GCC
WHERE  GCC.LAST_UPDATE_DATE >
TO_DATE (G_DT_LAST_RUN_DATE, ‘DD-MM-YYYY HH24:MI:SS’)
AND    GCC.ATTRIBUTE1 IS NULL
AND    GCC.CHART_OF_ACCOUNTS_ID =
NVL (G_NUM_CHART_OF_ACCOUNTS_ID, GCC.CHART_OF_ACCOUNTS_ID)