The LOAD_PLAN_DAILY ETL fails in executing "Task Merge into Refdel table" with the error "ORA-30926: unable to get a stable set of rows in the source tables" (Doc ID 2967412.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

When attempting to run daily ETL,
the following error occurs.

ERROR
-----------------------
Complete insert on ETL_PROJECTLIST
Complete populate W_DAY_D
Complete update on W_DAY_D
[ERROR] RUNNER_SCHEDULED_P6
[ERROR] P6_SCHEDULED_W_REFDELETE_S_PHYSICAL
[ERROR] 10 \-\ Physical_STEP
[ERROR] 10 /-/ SERIAL - MAP_MAIN - null
[WARNING] 20 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_SRC_LS_UNIT
[WARNING] 30 /-/ Drop work table - LKM Oracle to Oracle (DBLINK) - null
[DONE] 40 /-/ Lock journalized table - LKM Oracle to Oracle (DBLINK) - null
[DONE] 50 /-/ Create view/table on source - LKM Oracle to Oracle (DBLINK) - null
[WARNING] 60 /-/ Drop synonym on target - LKM Oracle to Oracle (DBLINK) - null
[DONE] 70 /-/ Create synonym on target - LKM Oracle to Oracle (DBLINK) - null
[ERROR] 80 /-/ SERIAL - EU - PRIMAVERA_ANALYTICS_TGT_LS_UNIT
[DONE] 90 /-/ Create parking table - IKM Oracle Incremental Update (DELETE) - null
[WARNING] 100 /-/ Drop flow table - IKM Oracle Incremental Update (DELETE) - null
[DONE] 110 /-/ Delete Staging table before - IKM Oracle Incremental Update (DELETE) - null
[DONE] 120 /-/ Create flow table I$ - IKM Oracle Incremental Update (DELETE) - null
[DONE] 130 /-/ Insert flow into I$ table - IKM Oracle Incremental Update (DELETE) - null
[DONE] 140 /-/ Analyze integration table - IKM Oracle Incremental Update (DELETE) - null
[DONE] 150 /-/ Create Index on flow table - IKM Oracle Incremental Update (DELETE) - null
[ERROR] 160 /-/ Merge into Refdel table - IKM Oracle Incremental Update (DELETE)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Daily load plan ETL fails with above error

Cause

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