My Oracle Support Banner

R12: Calendar Changes that can be Supported in General Ledger (GL) (Doc ID 1061798.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Form:GLCALSC.FMB - GL Calendars
Form:GLXSTCAL.FMB - Calendar
Older note 1049792.6 is covered in this note. It has been Archived




This Bulletin describes how to find the cause of general ledgers calendar form preventing updates to a calendar. It uses similar sql to the application to highlight the cause of 'APP-SQLGL-08044: You can only modify periods which have never been used'. Where there is nothing we can do to allow changes to be made it gives the reasons that support is unable to release fixes for many calendar changes and discusses the limitations of the calendar change solutions that are available.
This note addresses issue in R12 although similar issues exist in 11i these are addressed in <Note.357269.1> 11i Calendar Changes That Can be supported in General Ledger (GL).


This is limited to the supported options in calendar change that can be supported by Oracle Development and Oracle support. This does not cover offerings from Oracle Consultancy who can offer their own support. You may get consultancy to make changes for you but each solution would have to be tailored to fit the setup of an instance and thorough testing undertaken. Oracle support does not have the capacity for this activity. Consultancy can also offer support for your changes when made by them.

In R12 as in 11i before it the General Ledger calendar tables are used by other Oracle Applications as the basis for their own calendar information. In some cases the calendar is copied to other tables in it's entirety for use by other ledgers. Transactions posted in GL and elsewhere may record both the date and the period it relates to based on the GL calendar tables. Also it is possible for customisations to use data from the calendar tables as this is known as the central point for calendar related data.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.