My Oracle Support Banner

DTXQL Query Does Not Return The Expected Record Count (Doc ID 2994256.1)

Last updated on DECEMBER 22, 2023

Applies to:

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

Symptoms

On : NA version, Xstore Services

Actual Behavior
-----------------

When a COUNT calculation DTX query is executed on tables that have ORG_CODE and ORG_VALUE columns, calculation only considers records with ORG_CODE and ORG_VALUE with the value '*'.
For records with different ORG_CODE and ORG_VALUE values from * (example: ORG_CODE: STORE), the query will be included in the returned count.

Expected Behavior
---------------------

The COUNT calculation should return all existing records.

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
Cause
Solution


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