Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]

Scripts to Check the Setup of the General Ledger Calendar [ID 76503.1]
		Modified 18-MAR-2011 Type TROUBLESHOOTING Status PUBLISHED

Applies to:

Oracle General Ledger - Version: 10.7.16.1 to 12.1 - Release: 10.7 to 12.1
Information in this document applies to any platform.
Checked for relevance on 15-Jul-2010
Executable:GLOOAP - Open Period
Form:GLXSTCAL.FMB - Calendar

Purpose

When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar Setup and Usage at Note:130539.1 .

There is also a GL Calendar Diagnostic now available, per Note 1225833.1.

Last Review Date

July 15, 2010

Instructions for the Reader

A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.

Troubleshooting Details

Follow these steps to check the Calendar definitions and period statuses for Oracle Financial Applications that use the Calender defined by General Ledger.
This script will return the Calendar definitions, and the statuses of the periods for the different Oracle Financial Applications installed, for a specific Set of Books/Ledger.

1. Log into SQL*Plus as apps user:-
sql> /

2. At the SQL prompt type:

SQL> spool

Assuming you would like to save the output to the directory C:\TEMP and name the output file as
"calendar", type :

SQL> spool C:\TEMP\calendar.txt

3. Run the following queries to check the calendar:
(You can copy and paste the following query to Notepad, save it, then log into SQL*Plus from your
desktop by going to Start/Programs/Oracle for Windows/SQL Plus and log into your database and type
the following:

@\