My Oracle Support Banner

ORDDSCNT Batch Creates PO Revision Even When No Changes Are Made (Doc ID 2059771.1)

Last updated on MARCH 05, 2019

Applies to:

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


Find that the ORDDSCNT batch is creating purchase order (PO) revisions even when there are no changes. 
The multiple versions of POs is causing redundant information to flow to the vendor.

Steps to Reproduce:

  1. Create and approve a PO. 
  2. Note the version 0 record inserted into the order revision tables and no record is inserted into the REV_ORDERS table.
    Also note the record inserted into DEAL_CALC_QUEUE table for the approved order.
  3. Run ORDDSCNT batch. 
  4. Note that a record is inserted into the REV_ORDERS table for the PO.
  5. Run ORDREV batch.  This process will create the version 1 record in the revision tables, even though there is no cost/quantity changed on the PO.


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
 Patch / Patchset
 Relevant Bug

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