My Oracle Support Banner

Custom Approval Rules on Approved RTVs (Doc ID 2564740.1)

Last updated on MAY 16, 2022

Applies to:

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


It is possible to add custom business rules to be validated upon the approval of an RTV, like what can be done for POs and Transfers.
However on the RTV screen, once the RTV has passed the custom validations and thus is approved, it is still possible for the user to add items or edit the current RTV details without having the information submitted again for validation.
Since the validation is not triggered again, it allows to bypass the rules implemented by the business.

Steps to reproduce:

  1. Create a validation function to be called when a RTV is submitted. Design the function with a simple rule such as an RTV can only have one item or the quantity on the RTV is below 10, otherwise an error is returned to the user.

  2. Create a RTV with 2 items. Approve it. The validation function will be triggered and the RTV won't be accepted for approval. Edit the RTV so that it is valid according to the implemented rules, i.e in this example remove one item. Approve the RTV. the RTV should now move to the Approve status

  3. Once the RTV is approved. Add a new item. The item will be added to the RTV, triggering a RTVReqMod and passing the information to the downstream systems. However it breaks the business rule which was to only have RTVs with single items or qty below 10 or whatever rule was implemented.




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.