My Oracle Support Banner

OBIEE Patch Causes Incorrect Data Results In Selected Reports (Doc ID 2056808.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


After applying Patch, reports return the wrong data if the post install step 5.3: Configuration, for fix of 16222516, is also applied.

This step configures the parameter OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL, and is intended to fix bug 16222516. However, it can also change the physical SQL generated, while the logical SQL remains the same as in earlier versions. Known examples of changes made to the physical SQL include:

1. Adding a new case statement.
2. Changing how both Order By and Group By clauses are applied.

No error messages are reported, and only selected reports are affected.


 Applied OBIEE Bundled Patch


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.