Products not shown in Opportunities: ENI_PROD_DEN_HRCHY_PARENTS_V is empty
Last updated on SEPTEMBER 01, 2016
Applies to:Oracle Product Hub - Version 18.104.22.168 to 12 [Release 11.5 to 12]
Oracle Sales - Version 22.214.171.124 to 12 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
***Checked for relevance on12-MAR-2014***
A new catalog has been created.
Now, no products are displayed in the "Add Product" screen in Oracle Sales.
Receiving error in "Product Category" column:
No data exists.
Steps to reproduce:
- Sales User Responsibility
- Sales Dashboard
- Select an Open opportunity
- Go to Products
- Click Add Product.
Also, you note that the table EGO_PROD_CAT_SALES_MARKET_AGV
only contains information about the old catalog. The new catalog is missing.
select distinct CATEGORY_SET_ID from EGO_PROD_CAT_SALES_MARKET_AGV;
The old catalog is not longer used. Due to new business requirements, a new catalog has been created from the scratch.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms