ETM - Database, Zone And Business Service Conflicts With & Character (Doc ID 1188245.1)

Last updated on SEPTEMBER 13, 2010

Applies to:

Oracle Enterprise Taxation Management - Version: 2.1.5 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Symptoms

We have a Person Name in the database with an ampersand in it, the zones and business services that retrieve that name are converting each instance of the ampersand to &. This is a necessary step for a Business Service since it uses XML, and & is a reserved character in XML. But to get the value from the database to the Business Service, we need to first pull it into a Zone, which also changes each & into &.

The end result is that our forms validation, which needs to verify that the name on the form matches the Person Name in the database, is failing because it is comparing the form value "T & C INTERNATIONAL COMPANY" against the retrieved value "T & C INTERNATIONAL COMPANY".

I have two suggestions for the fix:

1) The zone that retrieves the name from the database should return the & as is, without converting it to &
or
2) The business service should recognize the string "&" and leave the & alone.

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