My Oracle Support Banner

Application Order Of The Off_invoices Deals Not Applied According To SYSTEM_OPTIONS (Doc ID 577362.1)

Last updated on OCTOBER 03, 2022

Applies to:

Oracle Retail Merchandising System - Version 12.0.5.6 and later
Information in this document applies to any platform.

Symptoms

Despite the settings in SYSTEM_OPTIONS table, "DEAL_TYPE_PRIORITY" set to 'P' and "DEAL_AGE_PRIORITY" set to 'N', the annual deal is applied before the promotion deal.

 Steps To Reproduce:

  1. Create and approve an Annual invoice type deal for a period.
  2. Create and approve a promotion for the same range of items and dates within period mentioned above.
  3. Create and approve a Purchase Order for the same range of items and dates within period mentioned above.
  4. Run respective batch or use the "Apply Process" button (form ordhead), select "Apply Deals" and hit "OK" button (form ordcalc).
  5. Verify "APPLICATION_ORDER" field at "ORDLOC_DISCOUNT" table for the "ORDER_NO" number  created above.

 

Cause

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
Symptoms
Cause
Solution
References

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