How To Create a JDBC Data Source Within BI Publisher for Use With Contract Management (Doc ID 1406714.1)

Last updated on JUNE 16, 2021

Applies to:

Goal

How to create a JDBC Data Source within BI Publisher Administration, for use with Contract Management 14.0. 

In order to utilize the Letters functionality, the Data Model for any of the Letter Templates being used must be pointing to a valid JDBC Data Source from within the BI Publisher Administration Page.  JDBC Data Sources are also required for previewing Reports and Forms from within BI Publisher.

There is no requirement for creating, nor associating a JDBC connection with standard reports and forms within Contract Management.
Primavera Contract Management provides JDBC information at report run time. The appropriate JDBC connection will be used regardless of what is configured in Oracle BI Publisher.

If the objective is to preview reports from within Oracle BI Publisher, it will be necessary to have different JDBC connections pointing to appropriate group database(s). BI Publisher users need to assign the correct JDBC connection to corresponding data models when previewing the report via BI Publisher to ensure the correct output is displayed.

In a conventional BI Publisher configuration, users would have different sets of reports for each group database and have different JDBC connections for each group. This is not required in Primavera Contract Management, as such a design is not enforced within Contract Management.

Solution

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