OBIA 11g: Load Plan Execution Failure ORA-04138: Value larger than specified precision allowed for this column. Fails at Interface named SIL_TimeDimension_MCalWeek445.W_MCAL_WEEK_D (Doc ID 2026619.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

BIAPPS 11.1.1.9.2

HR and Finance load plan execution failing with error ORA-04138: value larger than specified precision allowed for this column. The issue is in the interface named SIL_TimeDimension_MCalWeek445.W_MCAL_WEEK_D

OBIA version: 11.1.1.9.2

Adaptors: ALL

Issue Description:

The fiscal calendar dimension has a table W_MCAL_CAL_D that stores all the fiscal calendars. Each fiscal calendar is identified by a unique ROW_WID value. The ROW_WID is populated by the sequence called W_MCAL_CAL_D_SEQ. This ROW_WID is special because it is in turn used to populate intelligent ROW_WID for other fiscal calendar tables, such as W_MCAL_PERIOD_D. In those other tables, the data type of their ROW_WID is NUMBER(15,0) with a format of:

AAAAYYYYMMDDXXX

where:



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