Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 21.1.6 data load issue "ORA-01722: invalid number"

zavrykMar 10 2023 — edited Mar 10 2023

Hi! I have data load definition from XLSX and everytime I trying to load numbers with decimals I getting ORA-01722: invalid number error.

I tried to change excel, data profile and column profile settings for decimal ,/.

also tried to set different format masks in column profile (999G999G999G999G990D00 , 999g999g999g999g990D00, etc), but no success.

Thank you in advance!

Current settings (mostly returned to default)

Error log

Data profile:

Column profile

NLS

Glodalization attributes:

Excel and system formats

This post has been answered by zavryk on Mar 10 2023
Jump to Answer
Comments
Post Details
Added on Mar 10 2023
4 comments
2,170 views