My Oracle Support Banner

FA:SCM: SCP: Customer Data Collection Ends With Error (Doc ID 2570793.1)

Last updated on MARCH 03, 2020

Applies to:

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

Symptoms

On : 11.13.19.01.0 version, Data Collection

When attempting to run Collect Planning Data for Customer entity, the following error occurs.

ERROR
-----------------------
1. Net Change -->
CUSTOMERS : 1588375 : ORA-30926: unable to get a stable set of rows in the source tables

2. Target Refresh-->

The Load Entity process started for entity CUSTOMERS with refresh number 80781.

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_TRADING_PARTNERS", line 732


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_TRADING_PARTNERS", line 827
ORA-06512: at line 1
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 1625


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 1637
ORA-06512: at "FUSION.MSC_COLL_FRAMEWORK", line 3005

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Supply Chain Planning
2. Go to Task bar
3. Run Collect Planning data (ran for both target and net change)
4. Load Entity is failing

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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