Lately we see questions about Oracle Discoverer 11g certification with Oracle Database 19c. Oracle officially confirms that Discoverer is not tested or certified on the Oracle Database 19c.

We use Discoverer for development purposes only, but were curious if it will work with the 19c version. Recently we upgraded one of our EBS 12.1.3 databases to 19c and decided to test connecting and running several reports. And we’re happy to announce that everything works fine so far. To connect Discoverer to a 19c database connection descriptor has to include INSTANCE_NAME set to CDB and SERVICE_NAME to PDB:

19c =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=19c.localdomain)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_VIS)
(INSTANCE_NAME=CDBVIS)
)
)

Couple of test workbooks ran fine

Discoverer test workbook run

So Discoverer 11.1.0.7 works with Oracle EBS 12.1.3 on Database 19.7, but it can’t be treated as a reliable configuration. Oracle encourages customers to migrate to other solutions.

If you’re looking for a Discoverer replacement, consider Blitz Report. Its Discoverer import migrates entire workbook libraries automatically, including parameters, conditions and LOVs, and converts cross-tab layouts into Excel pivot tables.

Discoverer replacement with Blitz Report describes the complete process, from exporting the workbooks with Discoverer Administrator to validating the imported reports. The video below walks through an end-to-end migration of 311 workbooks:

Author: