Error While Running Load Plan in Oracle BI APPS. I have increased DEV_DW"."I$_8475500_1"."FST_DAY_EN

Question

ODI-1519: Serial step "Start Load Plan (InternalID:12274500)" failed because child step "Global Variable Refresh (InternalID:12275500)" is in error. ODI-1519: Serial step "Global Variable Refresh (InternalID:12275500)" failed because child step "Warehouse Load Phase (InternalID:14649500)" is in error. ODI-1519: Serial step "Warehouse Load Phase (InternalID:14649500)" failed because child step "1 SIL Load (InternalID:14650500)" is in error. ODI-1519: Serial step "1 SIL Load (InternalID:14650500)" failed because child step "2 SIL Dimension Group (InternalID:14651500)" is in error. ODI-1519: Serial step "2 SIL Dimension Group (InternalID:14651500)" failed because child step "Parallel - Others (InternalID:14818500)" is in error. ODI-1518: Parallel step "Parallel - Others (InternalID:14818500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: 3 SIL Dims TIME_DIM (InternalID:15544500) ODI-1519: Serial step "3 SIL Dims TIME_DIM (InternalID:15544500)" failed because child step "TIME_DIM (InternalID:15560500)" is in error. ODI-1519: Serial step "TIME_DIM (InternalID:15560500)" failed because child step "SIL_TIMEDIMENSION_UPDATEENTERPRISEATTRIBUTES (InternalID:15579500)" is in error. ODI-1217: Session SILOS_SIL_TIMEDIMENSION_UPDATEENTERPRISEATTRIBUTES (8475500) fails with return code 12899. ODI-1226: Step Run SIL_TimeDimension_UpdateEnterpriseAttributes.W_DAY_D fails after 1 attempt(s). ODI-1240: Flow Run SIL_TimeDimension_UpdateEnterpriseAttributes.W_DAY_D fails while performing a Integration operation. This flow loads target table Day Dimension. ODI-1228: Task SIL_TimeDimension_UpdateEnterpriseAttributes.W_DAY_D (Integration) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-12899: value too large for column "DEV_DW"."I$_8475500_1"."FST_DAY_ENT_PERIOD_FLG" (actual: 10, maximum: 1)

Thomas Dodds · Answer

Don't change the table structure & column sizes to work around this ... as mentioned by @VAp it is a FLAG -- it's a data issue so trace the mappings back to the source and see if you've got the wrong source column coming in.

VAp · Answer

By looking at the error, instead of flag value(usually like Y/N or 1/0) being populated, some other value(value of length 10) is getting into this column. please verify the SQL in the Operator.

Also, I$ table is drop and create at each run. so if you manually change the column length of this table in DW, it might not be effective when u run this mapping again. If we really want to increase the column length of this I$, then we need to change the column length of the DW Target table (to see what value is getting populated to this column).