My Oracle Support Banner

CP Horizontal View Error No data was found for your search criteria (Doc ID 2416772.1)

Last updated on JUNE 28, 2018

Applies to:

Oracle Collaborative Planning - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Horizontal View in Test

Users are on 12.2.6 and have applied patch 26969891 12.2.6.3 - Mandatory Cum Patch for 12.2.6 / R12.SCP_PF.C.Delta.7. They are testing creating a User Preference Set in the Horizontal View. Currently if No preference set is selected, the horizontal view shows data as expected. Then they create their own user preference set as follows:

Name = ARUP_PREF_SET
View your demand/supply = by individual organizations
View trading partner demand/supply = aggregated by trading partner
Graphing options = No Graph
Category is NULL
Days from today to start display = 500
Display buckets = 12 months
All order types have been selected

When they refresh the horizontal view and query using this user preference set they see the following Error

ERROR
=======
Error
No data was found for your search criteria

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a user preference set in CP
2. Query using user preference set
3. No data found error occurs
4. Query data with no user preference set and data is shown as expected

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!


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