My Oracle Support Banner

Poor Performance of PLP_RetailPartSeedFact for 'W_RTL_INV_IT_LC_DY_F' and 'W_RTL_INV_IT_LC_WK_A' at End of Month (Doc ID 2214691.1)

Last updated on MARCH 14, 2019

Applies to:

Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.


Users are experiencing poor performance of PLP_RetailPartSeedFact for W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A at end of month (EOM). The execution time taken by PLP_RetailPartSeedFact is increasing every EOM.

This job inserts all records from W_RTL_INV_IT_LC_G table in new partitions of W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A on EOM. This job takes over four hours to complete and is affecting the availability of RA applications.

Steps to Reproduce:

1. Run PLP_RetailPartSeedFact on EOM.
    This job takes 4hrs to complete execution only for W_RTL_INV_IT_LC_DY_F and W_RTL_INV_IT_LC_WK_A table.


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.