My Oracle Support Banner

RPLATUPD is Not Inserting Data to REPL_ITEM_LOC When There Are Changes to Attributes and Methods (Doc ID 2719448.1)

Last updated on AUGUST 16, 2022

Applies to:

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


Replenishment Attribute Update (RPLATUPD) Batch is not updating new data when the changes are done on the same day.
Steps To Recreate:

1. In Retail Merchandising System(RMS), Navigate to the Replenishment task.
2. Enter in the Create Replenishment Attribute task.
3. Enter the data for the attribute creation for any store.
4. Create the Replenishment Attribute, complete all the fields.
5. Once the attribute is configured, we will click on the option “Save and Close”.
6. Enter in the Manage Scheduled Replenishment task.
7. Search the item/location to update.
8. Update the attribute of Replenishment.

a. Picking to Receiving: 8 days to 16 days.
b. Constant Method to Min/Max.
i. Minimum: 10.
ii. Maximum: 100
c. Review Cycle: add Thursday

9. Apply “Yes” to do the update of replenishment.
10. Validate the table REPL_ATTR_UPDATE_HEAD, REPL_ATTR_UPDATE_ITEM and REPL_ATTR_UPDATE_LOC, user can see the two rows (One to create and other to update).
11. Execute the Replenishment Batch (including RPLATUPD).
12. If user validate the table REPL_ITEM_LOC, user don’t have rows of the configuration. 


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.