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

Last updated on JUNE 03, 2024

Applies to:

Purpose

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).

Scope

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.

Details