t2t_KDD_CASE_CUST_ADDR job failed with ORA-02291 (Doc ID 2751475.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

On : 8.0.7 version, Web UI

t2t_KDD_CASE_CUST_ADDR job failed with ORA-02291.

Error is in below task logs.

Information Date: 20210105
Batch Run ID: BDFCCMINFO_1574180238072_20210105_1
Task ID: Task260
Task Description: t2t_KDD_CASE_CUST_ACCT
Metadata Value: t2t_KDD_CASE_CUST_ACCT
Component ID: LOAD DATA
Task Status: [10105] Failed

MessageID Description Severity Time
736625 [10862] Fetched information regarding the given Information Domain INFORM 2021-01-06 14:03:25
736643 [17372] Error in executing Insert Statement. ORA-00001: unique constraint (SHBAATM.PK_1723) violated FATAL 2021-01-06 14:03:26
736644 [10874] No. of rows Successfully Loaded ->:5 INFORM 2021-01-06 14:03:26
736645 [10875] No of rows Rejected->:1 INFORM 2021-01-06 14:03:26
736646 [10900] Loading Failed, exceeded the reject threshold FATAL 2021-01-06 14:03:26
736647 [10865] Loading Failed. FATAL 2021-01-06 14:03:26

Information Date: 20210105
Batch Run ID: BDFCCMINFO_1574180238072_20210105_1
Task ID: Task277
Task Description: t2t_KDD_CASE_CUST_ADDR
Metadata Value: t2t_KDD_CASE_CUST_ADDR
Component ID: LOAD DATA
Task Status: [10105] Failed

MessageID Description Severity Time
736615 [10862] Fetched information regarding the given Information Domain INFORM 2021-01-06 14:03:24
736628 [17372] Error in executing Insert Statement. ORA-02291: integrity constraint (SHBAATM.FK_1724_1) violated - parent key not found FATAL 2021-01-06 14:03:25
736629 [10874] No. of rows Successfully Loaded ->:0 INFORM 2021-01-06 14:03:25
736630 [10875] No of rows Rejected->:1 INFORM 2021-01-06 14:03:25
736631 [10900] Loading Failed, exceeded the reject threshold FATAL 2021-01-06 14:03:25
736632 [10865] Loading Failed. FATAL 2021-01-06 14:03:25
 
.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.