My Oracle Support Banner

Enhancement Request: Inventory Request Should Allow Auto-approval Of Transfer If Repl Order Control = Manual (Doc ID 2710086.1)

Last updated on JUNE 12, 2021

Applies to:

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


The customer would like Inventory Requests coming from the store to create Transfers in Approved Status.

There is an issue with doing this based on other RMS requirements. The customer is using RMS Replenishment to replenish the Warehouse. They are using a Sales-based Forecast method (Dynamic). In order to aggregate the Store sales forecasts to the WH during the replenishment batch, RMS requires that Stores are also setup on replenishment with the Warehouse that is being replenished as the source. That serves as the link between the Stores and the Warehouses for the forecast aggregation purposes. As a result, the customer will setup Item/Stores on RMS Replenishment with Repl Order Control = Manual because while they do not want to use RMS Replenishment to replenish the stores, they do want to use it to replenish the Warehouse using a sales-based forecast.

When an Inventory Request comes in from the store using the Inventory Request RIB Subscription, if the item store is on RMS Replenishment, it looks at the Order Control to determine if the ad-hoc Transfer being created should be auto-approved or not. Due to this logic, the Transfer would be created in Input status and require a user to go online and manually approve this. With over 3,000 stores, this is not a reasonable ask. Also, because the intent of setting up the Store replenishment is only to allow WH replenishment to work, it is not valid to have that configuration impact the Inventory Request process.

What we think should be done is to allow the Transfer to be auto-approved if the Repl Order Control is set to 'Manual' ('Semi-Automatic' could still be valid for not allowing it to be auto-approved as that is a conscious decision to manually approve transfers).

The packages I suggest corrections to are
1. INV_REQUEST_SQL (invrequestb.pls), specifically the "VERIFY_REPL_INFO" function to mark it ad-hoc.
2. CREATE_ORD_TSF_SQL (creordtsfb.pls), specifically the "CREATE_ORD_TSF" function to Approve.


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.