My Oracle Support Banner

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 FEBRUARY 14, 2019

Applies to:

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


OBIA 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")



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

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