My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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


On : 12.2.6 version, Horizontal View in Test

Users are on 12.2.6 and have applied patch 26969891 - 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:

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

No data was found for your search criteria

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


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

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