My Oracle Support Banner

In the LoyaltyCloud Product Setup - the Process Refresh Denormalized Product Catalog Table For BI is not showing the Analytics Report data (Doc ID 2592543.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

Oracle Fusion Engagement Cloud Service - Version and later
Information in this document applies to any platform.


We have been working with Oracle Loyalty Cloud and were instructed to run the “Refresh Denormalized Product Catalog Table for BI” process to populate the ZCA_BI_PRODUCT_DENORM table.  The below steps were followed in BOTH Test and PROD and the table was not populated.

Below are the steps:
1. Fusion Home > Navigator -> Scheduled Process -> Scheduled New Process
2. Search the process -  Refresh Denormalized Product Catalog Table for BI
3. Wait for 2 hours and rerun the report.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.