Run the Refresh Denormalized Product Catalog Table Process

Every time you publish a catalog, the scheduled process, Refresh Denormalized Product Catalog Table for BI, runs automatically to update the current view of the product group hierarchy in the applications.

In addition, each time you make a new assignment of Base to a root product group, you must run the process. If you don't run the process, your product group hierarchy may not appear in the applications.

Run the Process

Here's how to run the Refresh Denormalized Product Catalog Table for BI process:

1. Sign in as a setup user and navigate to Scheduled Processes.

2. In the Scheduled Processes page, click Schedule New Process.

3. In the Schedule New Process dialog window, click the down-arrow next to the Name field and click Search.

4. In the Search dialog window, enter %Refresh%, and click Search.

5. Select the Refresh Denormalized Product Catalog Table for BI process in the results that are returned and click Ok.

6. Click Ok again, if needed.

7. In the Process Details window, click Submit.