Creating CSR using the Web Client missing half required information (4319783)

When trying to create new CSR from Stat Web Client, it is missing half required information.

Possibly special characters used in the customers table.

WORKAROUND:

1. From Tools | Table Dump Utility :

SELECT LAST_NAME FROM CUSTOMERS WHERE LAST_NAME LIKE '%’%'

2. It should returns some rows of lastnames that has abnormal ' apostrophe. Probably the name like example - O’Conner was cut and paste from Microsoft Word instead of Notepad or Wordpad. MS Word will paste in the abnormal ' apostrophe.

3. Please use Toad or SQL Plus logon as stat/password then run the update:

UPDATE CUSTOMERS SET LAST_NAME = TRANSLATE(LAST_NAME, '’', '''') WHERE LAST_NAME LIKE '%’%'

commit;