My Oracle Support Banner

OBIA 11.1.1.8.1 Out Of The Box Mappings W_DAY_D, W_MCAL_DAY_D, W_ENT_WEEK_D, W_MCAL_WEEK_D for the “Time” Dimension Are Truncated Every Run (Doc ID 2057864.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

The Data for the tables W_DAY_D, W_MCAL_DAY_D, W_ENT_WEEK_D, W_MCAL_WEEK_D for the “Time” Dimension are getting removed due to ODI Data Load failures at various Steps in the BI Load Plan running daily. The ODI Mappings that are failing are Out of the box ODI mapping populated with the Load Plan Run like EXEC_TABLE_MAINT_PROC.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.