My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.