My Oracle Support Banner

ASM When Trying to Create A Secondary Ledger Get 'There is a gap in your (&Name) Calendar' (Doc ID 436643.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLXCLVAL - Other - Calendar Validation Report
GLXSTCAL - Calandar

Symptoms

When trying to create a Secondary ledger for Primary ledger, hit 'Apply' and the following error occurs:

ERROR
-------
There is a gap in your (&Name) calendar. Not all dates between 2020-02-28 and 2020-03-01 are assigned to a period.
Please fix the calendar or pick another one.


Unable to find any gaps in the calendar.
Have run the calendar scripts from Note 76503.1 and there are no gaps.
Have run the Calendar Validation Report and it does not show any gaps in the calendar.
When try to follow the solution in internal Note 168134.1 Calendar Validation Report Shows a Non Existent Gap, when run script gluabcal.sql received the error:

ERROR

--------
For SQL glips.sql
Showing:
An error was encountered performing the requested operation:
ORA-00923: FROM keyword not found where expected
00923 00000 - "FROM keyword not found where expected"
*Cause:
*Action:
Error at Line: 13 Column: 60

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
 Still Have Questions?
References

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