11i: Calendar Changes That Can Be Supported In General Ledger (GL) (Doc ID 357269.1)

Last updated on OCTOBER 10, 2022

Applies to:

Purpose

This Bulletin describes how to find the cause of General Ledger's 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 11i although similar issues exist in R12 are addressed in  <Document 1061798.1> R12 Calendar Changes That Can be supported in General Ledger 

Scope

This is limited to the supported options in calendar changes 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 11i 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 its 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 customizations to use data from the calendar tables as this is known as the central point for calendar-related data.

Details