My Oracle Support Banner

Backslash Symbol Present in Customer EMail Address Field is Duplicated Multiple Times Upon Linking Customer to a Transaction (Doc ID 1967036.1)

Last updated on MAY 28, 2021

Applies to:

Oracle Retail Point-of-Service - Version 12.0.9IN and later
Information in this document applies to any platform.


In Oracle Retail Point of Service India Localization version, if customer information contains a backslash symbol [" \ "] in EMail address field, problem occurs when linking that customer to a transaction.

Searching that customer and linking in a transaction, then saving that transaction, results in the backslash symbol being duplicated in the customer record in LO_EML_ADS by a factor of two.

Steps To Reproduce:


Find a customer with an email address that contains "\"

1. POS -> customer -> Find -> Cust. ID
2. Enter the customer ID, for a customer with an email address that contains "\",
ex. '04241137' (  LO_EML_ADS.EM_ADS = 'abc\xyz@<DOMAIN_NAME>com')

3. Notice the value of the Email: 'abc\xyz@<DOMAIN_NAME>com'
4. Link
5. Customer -> Find -> Cust. ID
6. Enter customer ID: 04241137
7. Notice the value of the Email: 'abc\\xyz@<DOMAIN_NAME>com'




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.