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.


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.


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.