Update Time Dimension fails with Error in get_ent_cal_start_date

(Doc ID 1283308.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Financials Intelligence - Version 11.5 and later
Oracle General Ledger - Version 11.5 and later
Information in this document applies to any platform.

Symptoms

Program ends up with an warning message while running the Update Time Dimension (Initial) and due to this all the Time Dimension tables are not getting populated

FII_TIME_INIT_C module: Update Time Dimension (Initial) logfile shows following error

select to_date(start_month||'/'||start_day||'/'||current_year,'MM/DD/YYYY') from bsc_sys_calendars_b where edw_calendar_type_id=1 and edw_calendar_id=1001

Check mem data from fii_time_day

g_ent_start_date=, l_start_date=

g_ent_start_date=

g_ent_start_date NULL. fatal...

Error in get_ent_cal_start_date 01/17/2011 14:15:41

Error in init_mem_values User-Defined Exception 01/17/2011 14:15:41

Error in load_dbi_cal_into_bsc_full User-Defined Exception 01/17/2011 14:15:41

Error in load_dbi_cal_into_bsc User-Defined Exception 01/17/2011 14:15:41
Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc User-Defined Exception

Steps to reproduce
-----------------------
Login to Daily Business Administrator Responsibility.
Select View->Request->Single Request.
Run the concurrent program Update Time Dimension (Initial) and passed the following parameters.
from 01-JAN-2009 to 30-OCT-2010

Cause

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