Revision 1 is Inserted in REV Tables When PO is Created as Part of Automatic Replenishment

(Doc ID 2059519.1)

Last updated on MARCH 13, 2017

Applies to:

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


In Oracle Retail Merchandising System (RMS), Revision 1 is inserted in REV tables when a purchase order (PO) is created as part of automatic replenishment.  It is expected that an entry with Revision 0 be created.

Steps to Reproduce:

  1. Set up an Automatic replenishment.
  2. Run all batches through rplapprv.
  3. Notice that an entry gets created with revision 1 in REV tables (ORDLOC_REV, ORDHEAD_REV,ORDSKU_REV).  It is expected that an entry with revision 0 should get inserted, as this is how it is done through GUI.


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