OBIA 11g - SILOS_SIL_TIMEDIMENSION_MCALPERIOD Task Failed with Error "ORA-01400: cannot insert NULL into ("W_MCAL_PERIOD_D"."ROW_WID")"
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
OBIA 220.127.116.11.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")
- There is no separate load plan for SIL and SDE as per <Note 1633595.1>: OBIA 11g: Session SILOS_SIL_TIMEDIMENSION_MCALPERIOD Fails With ORA-01400
- Table w_mcal_cal_d is empty but Table w_mcal_period_ds has data.
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