Calendar Missing Date - Gap Datafix
(Doc ID 95447.1)
Last updated on JUNE 13, 2024
Applies to:
Oracle General Ledger - Version 11.5.10.2 and laterOracle Purchasing - Version 11.5.10.2 to 12.2.7 [Release 11.5 to 12.2]
Information in this document applies to any platform.
GLXSTCAL - Calendar
Symptoms
A data range or a day is missing in the Calendar definition, i.e. there is a GAP in the calendar.
For example :
- March is defined as March 1 to March 1 instead of March 31.
- In a leap year the 29th February is missing (the end date was defined as 28-Feb).
When you try to to update the information via the form you get an error because the calendar is already in use:
- APP-SQLGL-08044 or APP-08044: You can only modify periods that have never been used
Note that the calendar gap can be caused by incorrect end date, but also by incorrect start date.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| A) Checking Conditions |
| B) Datafix |
| C) Useful R12 Queries |
| References |