Poor Performance When Updating a Modifier Which Has a Large Number of Qualifiers (Doc ID 3039994.1)

Last updated on AUGUST 08, 2024

Applies to:

Symptoms

Find poor performance when updating a modifier which has a large number of qualifiers.
It takes an hour for the update to save.
Expects modifier update to save in seconds, not hours.

The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Pricing Manager
2. Navigate to: Modifier > Modifier Setup
3. Query the modifier
4. Update modifier and save. Find poor performance.

Cause

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