My Oracle Support Banner

WS StoreTransfer - OP LookupTransferHeader - Issue Using NO_VALUE As Status (Doc ID 2834964.1)

Last updated on JANUARY 21, 2022

Applies to:

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

Goal

We are testing the operation 'lookupTransferHeader' available in the Web Service StoreTransfer, if NO_VALUE in set in the <status> tag of the search criteria, no results are returned even when there are records in the TSF table for different statuses that match the search criteria. NO_VALUE is used to specify no value for the criteria – meaning do not limit the search by this criteria.

Scenarios:
1. No data is returned when NO_VALUE is used in the 'status' field.
2. Replacing the status by COMPLETED and keeping the remaining values the same, records are returned.
3. Replacing the status by REJECTED and keeping the remaining values the same, records are returned.
4. Replacing the status by CANCELED_REQUEST and keeping the remaining values the same, records are returned.

 

Solution

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
Goal
Solution
References


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