Why does the Global Calendar LOV not Show all Periods on Current Reporting Set Up. (Doc ID 602872.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Project Planning and Control - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Project Planning and Control - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 05-Jun-2013***


Goal

When trying to set the current reporting period cannot select the period
that is wanted for the Global Calender. The period does not appear in the drop down list.

The result of the query to determine the periods that will be available for global calendar does return all periods :

SELECT period_name
FROM gl_periods glp,
(SELECT pji_utils.get_period_set_name period_set_name,
pji_utils.get_period_type period_type
FROM dual) glb
WHERE 1 = 1
AND glb.period_set_name = glp.period_set_name
AND glb.period_type = glp.period_type;

Why do not all periods show on the LOV ?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms