Modifier Gets Applied During Re-pricing Of the Line Even After End-Dating The Line Qualifier (Doc ID 428738.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

An active modifier has line qualifiers for several customers.
The qualifier line for a customer was end-dated, but the modifier still gets applied for that customer.

Issue happens to sales orders which were entered earlier when qualifier was active but order lines are not yet picked or shipped.

Re-pricing happens after order line is picked, shipped, interfaced to OM.
From the 'View Adjustments' screen on the order organizer, the order line shows modifier applied, although its qualifier is end-dated.

The issue can be reproduced at will with the following steps:
1. Enter sales order for a customer and book it.
2. End-date the qualifier on a modifier which is applicable to the above sales order line.
Make sure the qualifier is for customer qualifier attribute.
3. Pick release the order line.
4. Ship confirm.
5. Run interface trip stop.
6. Run 'Workflow Background Process'.

Notice that the modifier with end-dated qualifier is still applied on the sales order line.

Cause

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