Symptom
The Product Category ID information is updated in an opportunity.
The Opportunity Item data source still shows the old Product Category ID information, instead of updated details in existing Opportunities.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Navigate to Business Analytics -> Design Data Sources.
- Search for Opportunity Item and click on Preview.
- Run the data source for any one existing Opportunity.
- Add the fields Opportunity, Product and Product Category ID to the view.
- Note down the Product Category ID value.
- Now navigate to Product -> Product Categories and change value for above Product Category ID.
- Repeat the steps 1 to 5.
- The Opportunity Item Data source preview still shows the old value for Product Category ID.
Cause
Opportunity Item Data Source is designed in a way that the Product Category information at the time of the creation of the opportunity will be retained and will not be modified, if the same Product Category ID is updated to a new value.
The Opportunities created after the change will show the new Product Category ID information in the Opportunity item Data source.
Resolution
This is the current system behavior.
As a workaround, you can use the field Product Category ID (Product) which is an attribute of the characteristic Product. The modified Product Category information will be updated at Product level. So, this field will show you the updated value in the Opportunity Item data source.
Keywords
Product Category, Product Category ID, wrong, incorrect, old, Opportunity Item, Data Source, Value, updated, Opportunity , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem