My Oracle Support Banner

SEC_GROUPS table DTXQL Query Returns A 400 Error Code Response (Doc ID 2921679.1)

Last updated on JANUARY 20, 2023

Applies to:

Oracle Retail Xstore Office Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

On : Xstore v21.1, Operations & Maintenance

Problem Summary
---------------------

The customer reported that error messages are returned when attempting to retrieve data via XOCS REST API. In the case of some objects specified in Xstore Services Guide, Appendix A, error messages are seen in the response indicating that an exception has occurred. In the description of the exceptions, there are parameters mentioned that are not used as part of the query.

400 Bad Request getObjectByQuery() exception CAUGHT on datasource Local while executing query key: GROUPS with params: ({argOrganizationId=1,argRetailLocation=0}) or similar returned when using DTXQL to query the SEC_GROUPS table

Problem Description
----------------------

Error 400 code messages are returned when attempting to retrieve SEC_GROUPS table data via the Xstore Office Cloud Service (XOCS) REST API.
  
Steps to replicate the issue:

Execute the following query in an appropriate API call:

<query xmlns:ns3="http://micros.com/xstore/config/query" name="GROUPS">
<ns3:Select from="Group"/>
<ns3:Where>
<ns3:Required field="organizationId"/>
</ns3:Where>
</query>

Expected Result:

The query should fetch the required data from the XOCS SEC_GROUPS table.

Actual Result:

The query returns a 400 error code.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.