My Oracle Support Banner

Is it Possible to Create a New BI Publisher Report From a SQL Query? (Doc ID 2887421.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Primavera Cloud Service - Version 20.12 and later
Information in this document applies to any platform.


 When trying to create a new BI Publisher report from a SQL Query there is no Data Source listed in the drop-down.


1. In OPC select Reports -> Report List
2. Create a new report
3. Under Layouts click Add
4. BI Publisher will open
5. Create a Blank report
6. Click New -> Data Model
7. Click Data Sets and then add a SQL Query
8. In the popup window no Data Source is available




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.