Order Closed Through XORDERDTLMOD Not Updating the CLOSE_DATE in ORDHEAD Table

(Doc ID 1963489.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version to 13.2.9 [Release 13.2]
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release. This article will be updated as official patch information becomes available.
This issue has been resolved, and the fix will be included as part of the Oracle Retail Merchandising System 13.2.9 patch (once available).

Order closed through XORDERDTLMOD is not updating the CLOSE_DATE in ORDHEAD table, and a record gets inserted in DEAL_CALC_QUEUE table even when the order is closed.

Steps to Reproduce:

  1. Create an order in RMS and approve it.
  2. Cancel all items on the order through XorderDtlMod.
  3. Notice that a record is inserted into DEAL_CALC_QUEUE, and CLOSE_DATE is not updated in ORDHEAD table for this closed order.


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