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 laterInformation 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 |