Cancel or Approve Option is enabled in RMS for SIM created RTV's and on clicking throws an Error (Doc ID 2673630.1)

Last updated on MAY 26, 2020

Applies to:

Symptoms

While Approving the RTV(Return to Vendor) created in SIM(Store Inventory_management) and throwing error as "Cannot approve the order" .

Expected behavior is the Since the RTV is only approved from SIM and in RMS((Oracle Retail Merchandising System) , it comes as "In-progress", and  cancel/approve option is enabled in RMS.

Steps To Reproduce:

1. Create a RTV from SIM and approve it . Observed that Status in SIM becomes 4 i.e.approved.
2. After successfully consuming the RTVCre message, RTV is integrated to RMS and status in RTV_HEAD table is 12 (In-Progress).
3. Navigate to RMS UI Return to Vendor option, click on EDIT and enter the same RTV_NO.
4. Click on options and observed that  Cancel/approve option is enabled.
5. Click on Cancel option and an error is thrown as "The completed date cannot be before the created date ".
6. Click on "OK" for the error and the Ship_date in RMS UI is populated as the current date (which is not expected as the RTV is not yet shipped).

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.