Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center