My Oracle Support Banner

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

Last updated on AUGUST 24, 2020

Applies to:

Oracle Public Sector Revenue Management - Version 2.1.5 and later
Information in this document applies to any platform.


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 "TEST & COMPANY" against the retrieved value "TEST & 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 &
2) The business service should recognize the string "&" and leave the & alone.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.