OBIA 11g - SILOS_SIL_TIMEDIMENSION_MCALPERIOD Task Failed with Error "ORA-01400: cannot insert NULL into ("W_MCAL_PERIOD_D"."ROW_WID")" (Doc ID 1942082.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

OBIA 11.1.1.8.1 with EBS R12.1.3:

When executing a load plan to load the data, the SILOS_SIL_TIMEDIMENSION_MCALPERIOD Task is failing with the error message below:

ODI-1217: Session SILOS_SIL_TIMEDIMENSION_MCALPERIOD (11623500) fails with return code 1400.
ODI-1226: Step Run SIL_TimeDimension_MCalPeriod.W_MCAL_PERIOD_D fails after 1 attempt(s).
ODI-1240: Flow Run SIL_TimeDimension_MCalPeriod.W_MCAL_PERIOD_D fails while performing a Integration operation. This flow loads target table Fiscal Period Dimension Table.
ODI-1228: Task SIL_TimeDimension_MCalPeriod.W_MCAL_PERIOD_D (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("BIDEV_DW"."W_MCAL_PERIOD_D"."ROW_WID")


 

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