We have a multi-language application, where the default language is German.
We use an application item called FSP_LANGUAGE_PREFERENCE to set the application language and show the translated English application to the user.
Our issue is that we are trying to use German number formats in the English application, meaning a number should be formatted like this
1.234.567,89 instead of the English 1,234,567.89.
To do this, we wanted to set the NLS_NUMERIC_CHARACTERS preference for the DB session using this command in the APEX applications DB session initialization code:
execute immediate q'[alter session set NLS_NUMERIC_CHARACTERS=',.']';
However, this only causes issues. After publishing the English APEX application again, we encountered the following problem:
Error during rendering of region "NLS Showcase".
Contact your application administrator.
Technical Info (only available for developers)
is_internal_error: true
apex_error_code: APEX.REGION.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APEX_230100.WWV_FLOW_PAGE", line 1999
ORA-06512: at "APEX_230100.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_230100.WWV_FLOW_DISP_PAGE_PLUGS", line 1380
ORA-06512: at "APEX_230100.WWV_FLOW_PAGE", line 1947
component.type: APEX_APPLICATION_PAGES
component.id: 98772000000001
component.name: NLS Showcase
error_backtrace:
ORA-06512: at "APEX_230100.WWV_FLOW_PAGE", line 1999
ORA-06512: at "APEX_230100.WWV_FLOW_DISP_PAGE_PLUGS", line 1706
ORA-06512: at "APEX_230100.WWV_FLOW_DISP_PAGE_PLUGS", line 1380
ORA-06512: at "APEX_230100.WWV_FLOW_PAGE", line 1947
To showcase the error, I've built a minimal application, which can be found here:
https://apex.oracle.com/pls/apex/r/johannesdemo/nls-showcase
By default, the application is German. Once you click on "English" in the top right corner, you will encounter the issue.
What is the correct way to forcing German number formats in an English APEX application translation?
This has to be possible, right?
Thank you for your help!