Order Deal Is Not Correctly Recalculated After Applying Item Cost Changes

(Doc ID 2357800.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

Values in ORDLOC_DISCOUNT table are not properly recalculated after applying item cost changes.


Steps to reproduce:

  1. Create a multi location order
  2. Create/Apply a PO-specific deal to an order for multiple location
  3. Approve and receive the order for a single location where deal is applied.
  4. Create a cost change for that Item Supplier Country Location (ISCL) on Order with RECALC_ORDER_IND as 'Y'
  5. Run the cost change batches and the batch that applies Deal discounts to Purchase Orders. (sccext and orddscnt batches)
  6. Notice that unit cost is updated on ORDLOC table for not-received locations but ORDLOC_DISCOUNT table is not updated.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms