WebADI Completes With Error ORA-06502 When User Preference Number Format Changed To 10,000,00 From 10,000.00

(Doc ID 2097593.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.4 version, Catalog items

Find WebADI completes with error when user preference Number format changed to 10 000,00 from 10,000.00

Error
Error Code=-6502, Msg=INVPULI2.copy_template_attributes ORA-06502:
PL/SQL: numeric or value error: character to number conversion error


Steps
The issue can be reproduced at will with the following steps:
1. Navigation to change user preference: PIM Information Management Data Librarian -> Hope page -> Settings -> Preferences.

2. Change Number format for user preference Number format to 10 000,00 from 10,000.00


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