My Oracle Support Banner

Rplatupd Batch Removes Deactivate Date For Discontinued Item/Loc When Updating Any Attribute (Doc ID 2224402.1)

Last updated on JUNE 12, 2021

Applies to:

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


In Oracle Retail Merchandising System (RMS), when the rplatupd batch runs, the deactivate date is being removed for Item/Loc in discontinued status.

Steps to Recreate:

  1. Notice the vdate on day-1.
  2. Create an Item List.
  3. Use the Item List to create a replenishment at ranged locations.
  4. Run rplatupd and rilmaint batches and notice replenishment tables are populated.
  5. Make the Item#1 discontinued at Location#1 on same day (ITEM_LOC.STATUS = C).
  6. Run rilmaint batch and notice REPL_ITEM_LOC.DEACTIVATE_DATE for Item#1/Location#1 combination is populated.
  7. Change the vdate to next day.
  8. Select action as 'New' in 'Replenishment Attribute Maintenance' form.
  9. Use the item#1 and 'Update' replenishment attributes for all stores.
  10. Run rplatupd and rilmaint batches and notice that Item#1/Location#1 REPL_ITEM_LOC.DEACTIVATE_DATE is null again even though ITEM_LOC.STATUS is C.





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.