"Analyze Target Table" Step in PLP_RETAILPRODUCTDIMENSIONLKUPTEMP Package Not Functioning as Expected: W_PRODUCT_D_RTL_TMP Is Not Being Analyzed (Doc ID 1562892.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising Analytics - Version 13.2.4 to 13.2.5 [Release 13.2]
Oracle Retail Merchandising Analytics - Version 13.3 to 13.3.6 [Release 13.3]
Oracle Retail Merchandising Analytics - Version 14.0 to 14.0.1 [Release 14.0]
Information in this document applies to any platform.

Symptoms

In PLP_RETAILPRODUCTDIMENSIONLKUPTEMP package, step "Analyze target table" is not functioning as expected.

Steps to Recreate:

  1. Run prditmsupsil.ksh.
  2. Package PLP_RETAILPRODUCTDIMENSIONLKUPTEMP executes successfully.
  3. In ODI log, the step "Analyze target table" shows success but with zero rows updated.
  4. In the database, column num_rows in table ALL_TABLES is not updated for the target table W_PRODUCT_D_RTL_TMP.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms