OBIEE Patch 184.108.40.206.150120 Causes Incorrect Data Results In Selected Reports
Last updated on JUNE 20, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.150120 and later
Information in this document applies to any platform.
After applying Patch 18.104.22.168.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 22.214.171.124.150120.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms