My Oracle Support Banner

QTY_REQUESTED on RTV_DETAIL Table Shows as 0 After Upgrading to 19.3.019 (Doc ID 2970251.1)

Last updated on AUGUST 25, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


On: MFCS/RMS 19.3.019 version

Actual Behavior

The RTV created with ORIGIN_IND as “EXTGEN” has only the QTY_RETURNED field populated at the time of RTV message integration, and QTY_REQUESTED is Zero.

There is no issue, but all other postings, like SOH, TRAN_DATA posting, etc., are working as usual. Only the QTY_REQUESTED field is populating as Zero.

Expected Behavior
Before the upgrade to 19.3.019, the QTY_REQUESTED showed the actual QTY requested.

Steps to Reproduce
1. Create and publish the RTVCre payload via SOAP UI/other tools.
2. Verify RTV is created in RMS.
3. Check the QTY_REQUESTED on the RTV_DETAIL table as '0'.




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.