OBIEE 11g - XML Search and Replace Option in Catalog Manager does Not Work Against Quotes (Doc ID 2094473.1)

Last updated on FEBRUARY 10, 2016

Applies to:

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

Symptoms

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
"- Nx_All_Expenditure_Items"
to
"Nx_All_Expenditure_Items"


Old value : sqlExpression"\>"- Nx
New value : sqlExpression"\>"Nx

Result:
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 :
"- Nx_All_Expenditure_Items"
Replace with:
"Nx_All_Expenditure_Items"

Cause

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