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.
On : 12.2.6 version, Horizontal View in Test
Users are on 12.2.6 and have applied patch 26969891 184.108.40.206 - 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
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!