My Oracle Support Banner

Revision 1 is Inserted in REV Tables When PO is Created as Part of Automatic Replenishment (Doc ID 2059519.1)

Last updated on MAY 30, 2018

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.


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

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