No Records In REPL_RESULTS After Running REQEXT Program (Doc ID 1276037.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle Retail Merchandising System - Version 10.1.12 and later
Information in this document applies to any platform.
Checked for relevance as on 30-Jul-2012
Checked for relevance as on 10-JAN-2014

Symptoms

Records are not populated in REPL_RESULTS table for a component item when pack item is associated after running REQEXT program.

Steps To Recreate:

  1. Create a component item
  2. Create simple pack item. Associated that component item to the pack item.
  3. Add required details like supplier, location, etc. to pack item.
  4. Approve the pack item.
  5. Add replenishment attribute for a component item.
    Stock Category: Warehouse Stock
    Order Control: Automatic
    Replenishment Method: Constant
    Set the replenishment pack item for this item/loc combination.
  6. Run replenishment batches.
  7. There is record in RPL_NET_INVENTORY_TMP table.
  8. Run REQEXT Progam. Check in REPL_RESULTS table, there is no record created after running REQEXT program.
Note:
For Direct to store, When pack item is associated, records are added in REPL_RESULTS and order is created. But, for Warehouse Stock there is no record added in REPL_RESTULS after running REQEXT program.

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