Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

ODI ETL failiure

Question

Views

Comments

User327172 Rank 1 - Community Starter

Jun 23, 2017 11:40AM 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.

Terence

MFA for Oracle Community

Oracle Business Intelligence Applications

Categories

ODI ETL failiure