OBIEE Patch 22.214.171.124.150120 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 126.96.36.199.150120 and later
Information in this document applies to any platform.
After applying Patch 188.8.131.52.150120, 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 184.108.40.206.150120.
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