My Oracle Support Banner

Modifier or Price List is Not Working Due to an Inactive Qualifier (Doc ID 2915888.1)

Last updated on DECEMBER 20, 2022

Applies to:

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


Find that some modifiers and/or price lists are not working.
Further investigation shows that the active_flag is set to 'N' on one or more of the qualifiers assigned,
even though the active flag on the modifier and/or price list is set to 'Y'.

Expects the active_flag for the qualifier to match the value assigned to the active_flag of the pricing entity (modifier or price list header record).
When a qualifier is created (inserted), the active_flag on the qualifier record (qp_qualifiers) is populated from the active_flag of the price list / modifier list to which it is attached. 
If the user creates a price list with active_flag = 'N', and attaches a qualifier to it, both the price list header and qualifier will have active_flag = 'N'. 
Then if user changes the active flag on the price list header to 'Y' qualifier  active_flag should get changed to 'Y'.

The issue cannot be replicated at will.
Hence if the active_flag is different between the qualifier record and the qp_List_headers_b record,
there are only two scenarios where this may result according to Development

1) There can be some database update (using SQL) done to the price list, modifier or qualifier active_flag column
2) The qualifier may have been attached through an api where active_flag for the qualifier record was explicitly sent as 'N' while creating that record in the database.




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.