My Oracle Support Banner

After 22-A Select Count(From any table) Giving Incorrect Results When Ran from BI Publisher (Doc ID 2847991.1)

Last updated on APRIL 11, 2022

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.01.0 and later
Oracle Fusion CX Sales Cloud Service - Version 11.13.22.01.0 to 11.13.22.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On 22A

After creating a new Data Model that uses a: select count(<any column>) from <any fusion_table>

and running the query from the Data Model, the query results show the number of Rows set in the display results.

Example:

Create a  DM with the following SQL query:

 

 

 

Then click on the Data tab to view the results:


If the number of Rows returned is set to 10, then the query results show:
COUNT_DISTINCTPERSON_ID_ (10)




 

Change the number of Rows returned to 200, then the query results show:
COUNT_DISTINCTPERSON_ID_ (200)



 

Changes

 Upgraded to 22A

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.