DBI Load Fails With Errors in get_445_cal_start_date, init_mem_values & load_dbi_cal_into_bsc (Doc ID 455820.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle E-Business Intelligence - Version 7.0 to 7.3 [Release 7]
Oracle Balanced Scorecard - Version 5.0 to 5.3 [Release 5]
Oracle Financials Intelligence - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Procurement Intelligence - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Information in this document applies to any platform.
E-Business Intelligence - Version: 7.0 to 7.3
Oracle Financials Intelligence - Version: 11.5.10.2Oracle General Ledger - Version: 11.5.10.2Oracle Procurement Intelligence - Version: 11.5.10.2This problem can occur on any platform.
Checked for relevance on 19-MAR-2013

Symptoms

On 11.5.10.2 in Production:
When attempting to execute the Initial Load of Daily Business Intelligence for Procurement,
the following errors occur:

Error in get_445_cal_start_date 07/23/2007 14:40:57
Error in init_mem_values User-Defined Exception 07/23/2007 14:40:57
Error in load_dbi_cal_into_bsc_full User-Defined Exception 07/23/2007 14:40:57
Error in load_dbi_cal_into_bsc User-Defined Exception 07/23/2007 14:40:57
Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc User-Defined Exception

 
The issue can be reproduced at will with the following steps:
1. Log into Ebusiness.
2. Select the DBI Administrator responsibility.
3. Navigate to Data Summarization: Request Sets => Run Request Sets => Single Request.
4. At Request Name, select Daily Business Intelligence for Procurement (Initial).
5. Run the request set with the default start and end dates.
6. Click Submit. The job completes with status Warning.
7. Click View Log. The above error messages are displayed.

The log shows that the request set fails when it calls the program Update Time Dimension.

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