AD/TXK Delta14 adop phase=cleanup errors with ORA-01722: invalid number
Hello,
Has anyone (in Europe) experienced this error? And can advise on the solution.
Opened a SR a week ago, still no progress there.
EBS version 12.2.11
Applying AD/TXK Delta 14 (from Delta 13)
Site Level Profile "ICX: Numeric characters" = 10.000,00
Database charset is WE8ISO8859P15
select value from v$nls_parameters where parameter = 'NLS_NUMERIC_CHARACTERS';
VALUE
----------------------------------------------------------------
,.
As we are located in Europe and not using the US standard with Decimal point as '.' we are using comma ','
the to_number for this query results in ORA-01722:
SQL> select substr(version_full,1,instr(version_full,'.',1,2)-1) from v$instance;