"ORA-01403: NO_DATA_FOUND" Error During Data Collection

(Doc ID 2394178.1)

Last updated on MAY 22, 2018

Applies to:

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

Symptoms

When run data collection in target mode (with All Entities), The Collection Job Set program was successful, but the Create Tree Structures program was in Error with below log message

ERROR

Creating tree structures for Time Dimension in Target Mode
 Error_Stack...
ORA-01403: NO_DATA_FOUND
 Error_Backtrace...
ORA-06512: "FUSION.MSC_COLL_HIERARCHIES", line 2798

"Create Tree Structures" Scheduled Process request has completed with errors



STEPS TO REPRODUCE
1. Go to planning > Plan Inputs > task drawer: Collect Planning Data
2. Fill in data need to be collected: Source System-> <source_system_code>, Collection Type->Targeted, All Entities chosen.
3. Submit and Go to scheduled Processes and check the ESS status.



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