My Oracle Support Banner

Slowness On Searching For Promotions (Doc ID 3052452.1)

Last updated on NOVEMBER 05, 2024

Applies to:

Oracle Retail Pricing Cloud Service - Version 24.0 to 24.1 [Release 24.0 to 24.1]
Information in this document applies to any platform.

Symptoms

On : 24.0 version, Operations & Maintenance

ACTUAL BEHAVIOR
---------------
Slowness on searching for promotions

When searching for promotions in RPCS using the advance search, the search times are long for small result sets:
search by dept + start-date between two dates
search by dept + start_date and end_date each between two dates

EXPECTED BEHAVIOR
-----------------------
Performance improvement required

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- go to manage promotions
- open advance search
- input dept, start_date between two dates
- click search

User searched promotion with dept=1001 and effective date. Search returned results after 3.30 min.

Cause

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
Symptoms
Cause
Solution
References


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