Update Time Dimension (FII_TIME_C / FII_TIME_INIT_C) Completes In Warning / ORA-24344 (Doc ID 1378626.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle E-Business Intelligence - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 27-Jul-2013***

Symptoms

Running request set to refresh DBI dashboards, program 'Update Time Dimension' FII_TIME_INIT_C fails with ORA-24344.

Error
------
Exception in load_reporting_calendar ORA-24344: success with compilation error
Error
Error in load_dbi_cal_into_bsc User-Defined Exception 10/20/2011 10:18:52
Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc User-Defined Exception


Steps
------
Implement DBI for first time,
Ran request set to load data and request for'Update Time Dimension' program completed with warning.
the log file for FII_TIME_C / FII_TIME_INIT_C returns the above error.

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