Error 'ORA-30926: unable to get a stable set of rows in the source tables' During Collection for Entity FOB

(Doc ID 2405433.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Fusion Planning Central Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

During Collection for Entity FOB receiving the following error:

ERROR
The Load Entity process started with refresh number 3006.
ORA-30926: unable to get a stable set of rows in the source tables
ORA-30926: unable to get a stable set of rows in the source tables

ORA-06512: at "FUSION.MSC_COLL_LOOKUPS", line 1180

ORA-30926: unable to get a stable set of rows in the source tables
ORA-30926: unable to get a stable set of rows in the source tables

ORA-06512: at "FUSION.MSC_COLL_LOOKUPS", line 1481
ORA-06512: at "FUSION.MSC_COLL_LOOKUPS", line 1554
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1447

ORA-30926: unable to get a stable set of rows in the source tables
ORA-30926: unable to get a stable set of rows in the source tables

ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1459
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 2779


STEPS TO REPRODUCE
1. Launch Collection in Targeted node
2. Check the logs
3. Find the error.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms