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

Last updated on DECEMBER 20, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR 
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'.

EXPECTED BEHAVIOR
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
    or
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.

Changes

Cause

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