Replenishment For PO Does Not Consider On-Order Quantity (Doc ID 1934860.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

After setting a Replenishment attribute with "everyday" option, it is not checking correctly on_order quantities from existing orders and always keep on creating orders with quantity as per max quantity set during replenishment setup for item.
Also, the on_order column in repl_results remains zero although the orders created daily have qty_ordered populated.

Expected behaviour is that it should check for on_order quantities based on orders which were created either manually or created by previous run of replenishment batches. And then orders should be created based on quantities which are not received.


The issue can be reproduced at will with the following steps:

1. Set up replenishment for an item in RMS.
     - Replenishment Method - Min/Max
     - Repl Cycle - Every Day.
2. Run the replenishment batches in sequence:
       prepost rplatupd pre
       rplatupd
       prepost rplatupd post
       rilmaint
       prepost rilmaint post
       prepost replroq pre
       replroq.ksh
       prepost reqext pre
       batch_reqext.ksh
       prepost reqext post
       prepost rpl pre
       rplext.ksh
       prepost rplext post
       rplbld
       prepost rplapprv pre
       rplapprv
3. Orders are getting generated daily for same item/location and it is not considering on-order qty.

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