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

Last updated on APRIL 10, 2017

Applies to:

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

Symptoms

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.

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