My Oracle Support Banner

Is There a Direct Route Using an API for Loading Qualifiers for the Modifier Header? (Doc ID 1301767.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Advanced Pricing - Version 12.0.0 and later
Information in this document applies to any platform.

Goal


The goal is to address the following question and to provide best performance possible.

Is there a direct route using an API for loading qualifiers for the modifier header after the modifier header record is created manually through the form?


One is facing a performance issues by using oracle API ( ‘QP_Qualifier_Rules_Pub’ )
due to the number of steps involved.

Solution

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
Goal
 Is there a direct route using an API for loading qualifiers for the modifier header after the modifier header record is created manually through the form?
Solution
 1) One may use API process_modifiers to add the qualifiers.
 2) Set profile option QP: Denormalize Qualifiers = No, for Improved Performance.
 3) Run QP: Maintains Denormalized Data in QP Qualifiers
 4) If Pattern Search is enabled, run  QP: Pattern Upgrade with no criteria.
References


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