Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODI ETL failiure

Question
3
Views
0
Comments
User327172
User327172 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

BIAPPS 12c EBS load is failing

message we are getting is:

ODI-1226: Step Run SIL_PositionDimensionHierarchy.W_POSITION_DH fails after 1 attempt(s). ODI-1240: Flow Run SIL_PositionDimensionHierarchy.W_POSITION_DH fails while performing a Integration operation. This flow loads target table W_POSITION_D

ODI-1228: Task SIL_PositionDimensionHierarchy.W_POSITION_DH (Integration) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PRD_DW.W_POSITION_DH_U2) violated

Any help appreciated.

TerenceODI.JPG