OBIEE 11g - XML Search and Replace Option in Catalog Manager does Not Work Against Quotes
Last updated on FEBRUARY 10, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.141014 and later
Information in this document applies to any platform.
While updating a lot of objects in Web Catalog using "XML Search and Replace" tool in Catalog Manager, it does not show the correct results.
The requirement is to update old table names in reports, prompts that contain "- Nx" in name, for example
Old value : sqlExpression"\>"- Nx
New value : sqlExpression"\>"Nx
Output - Items changed - none. But using search we can found a lot of objects with tables with - Nx
The issue can be reproduced at will with the following steps:
1. Open the catalog Manager in offline mode
2. Click Tools > "XML Search and Replace"
3. Search :
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