Redundant Order Versions Are Created in ORDHEAD_REV and ORDLOC_REV Tables Through RMS Application (Doc ID 1990012.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

Order revisions are sometimes created starting revision zero and others starting revision one.

If any approved PO is created through a batch (e.g., Replenishment Order, Special Order, SIM Inventory Request), in that case order revisions created in order revision tables start from 1 (i.e., the first revision for this order has rev_no = 1).
However, when the user updates this PO in RMS and moves the status to Worksheet then back to Approved, a record with rev_no=0 is created for this order.

On the other hand, if the PO is created and approved through the RMS application, then order revisions created in order revision tables start from 0 (i.e., the first revision for this order has rev_no = 0).


Steps to Reproduce:

  1. Create a PO using replenishment or a SIM inventory request.
  2. Note that the PO is created in Approved status in RMS and note that it will initially be created as version 1 in ORDHEAD_REV table.
  3. Now suppose user wants to modify the PO from the RMS screen and changes the status from Approve to Worksheet.
  4. Note that once the PO is approved again, it will create a record in ORDHEAD_REV table with REV_NO = 0.

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