"Analyze Target Table" Step in PLP_RETAILPRODUCTDIMENSIONLKUPTEMP Package Not Functioning as Expected: W_PRODUCT_D_RTL_TMP Is Not Being Analyzed
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.
In PLP_RETAILPRODUCTDIMENSIONLKUPTEMP package, step "Analyze target table" is not functioning as expected.
Steps to Recreate:
- Run prditmsupsil.ksh.
- Package PLP_RETAILPRODUCTDIMENSIONLKUPTEMP executes successfully.
- In ODI log, the step "Analyze target table" shows success but with zero rows updated.
- In the database, column num_rows in table ALL_TABLES is not updated for the target table W_PRODUCT_D_RTL_TMP.
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