My Oracle Support Banner

For Some Users Item Attribute Data Not Showing Up In SPP Supply Demand Analysis (Doc ID 2552394.1)

Last updated on OCTOBER 16, 2019

Applies to:

Oracle Service Parts Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, User Interface in Test

Users are on 12.2.4 and have applied VCP Cum Patch 12.2.4.1 - 19549533
After running SPP plan, there are some users who do not see item data in the supply demand analysis screen. They do see the worksheet data just not the item details. They've tried clearing cache and trying the update in Note 1915644.1 - Supply Demand Analysis Workbench Not Showing Any Rows For Forecast Analysis - however it does not help. They noticed that this usually happens when the user goes to User Preference > Create a new Preference Set and assign a Worksheet Preference. Example data:

For a particular user they query in Supply Demand Analysis
Item - JMSPPItem
All orgs that start with K%
Users see worksheet data but no item data (all fields blank)
For a different user they query same data and they can see all the item data for all 3 K orgs

One thing they found that seems to be a regular constant when the problem occurs is if they have enabled the default_flag in msc_user_preferences table for a particular user in their User Preferences. They found the following scripts help fix the problem:

update apps.MSC_USER_PREFERENCES
set default_flag = 2
where User_Id = &user_id
and name = '&User_name';

or

delete apps.MSC_USER_PREFERENCES
where 1=1
and user_id = &userid;

The problem is many users will want to specify a default user preference in CP - this is a loss of functionality to run these scripts

EXPECTED BEHAVIOR
-----------------------
Expect to see item data for all item/org combinations for all users in supply demand analysis screen

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Query Supply Demand Analysis data for item/orgs for an SPP plan
2. Some users see item data in the supply demand analysis
3. Some users do not see item data in supply demand analysis

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.