ETL Failed While Loading Data Into W_AP_XACT_F Table
(Doc ID 3037712.1)
Last updated on JULY 31, 2024
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PS3 - Patch Set 3 and laterInformation in this document applies to any platform.
Goal
On : 11.1.1.10.3 - PS3 - Patch Set 3 version, DataWarehouse
ETL failed while loading data into W_AP_XACT_F table
The Daily ETL load failed with the below error while loading data into W_AP_XACT_F table.
Request you to check the attached logs and provide a solution.
ODI-1228: Task Insert new rows-IKM BIAPPS Oracle Fact Incremental Update- fails on the target connection BIAPPS_DW.
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (W_AP_XACT_F_U2) violated
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
Solution
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
| Goal |
| Solution |
| References |