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.
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.
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:
Change the number of Rows returned to 200, then the query results show:
Upgraded to 22A
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