The SQL in the Initialization Block may be Rewritten After Changing the Database Type
(Doc ID 2892624.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.211207 and laterInformation in this document applies to any platform.
Symptoms
Open repository and Change database type from 'Oracle 11g' to 'Oracle 12c on Exadata'. Save it and you will find that the initialization block might have been rewritten.
Example Before change:
'select <string> from dual'
Example After change:
'select distinct ':USER' from <table>'
Changes
Upgraded from BIEE 11g to 12.2.1.4. (Database 11g to 19c)
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |