DIM_DATES Table is not Populated During Time Dimension Population Process (Doc ID 1957297.1)

Last updated on DECEMBER 26, 2014

Applies to:

Oracle Financial Services Data Foundation - Version 7.4.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 7.4.1 version, Metadata Issues

When trying to populate DIM_DATES using Time Dimension Population Process, the process seems successful but DIM_DATES is not populated.

Steps:
1. Passed the start_date and end_date as parameters in Batch definition for FN_DIM_DATES like below.

SET SERVEROUTPUT ON;
execute proc_dim_dates_population('01-JAN-2014','01-JAN-2014');

2. Batch seems successful but DIM_DATES is not populated.

3. No Error in DT logs nor in FSI_MESSAGE_LOG.

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