Apex Websheet Default Application Territory Ignored for User Nobody
(Doc ID 1589894.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Application Express (APEX) - Version 4.0.2.00.07 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
The default language in set in the websheet options are not applied to anonymous users.
If you set the Default Application Territory as "Netherlands" they are expecting decimal signs to be commas. Once they log-in to the websheet this settings (was) not default but can be saved with the "language" setting in the websheet. This setting is saved for that user.
However, it is not possible to set the Default Application Territory to Netherlands for the "nobody" i.e(anonymous users) user.
Decimal signs keep falling back to periods for that user.
To reproduce the problem:
1. Log-in to the APEX instance
2. Go to the Application Builder, and click on the appropriate websheet application.
3. Edit Properties
4. Check the default languages (Default Application Language: English / Default Application Territory: Netherlands)
5. Cancel or apply changes
6. Press the RUN button to launch the websheet application.
At this moment you are not logged in to the websheet app ! So you are user "nobody".
1. Click Language
2. Check the language settings. For this example the default Application Language should be: English and default Application Territory: Netherlands here.
Instead it is Chinese / Algeria.
3. Now click Cancel
4. Click Log-in
5. Log-in with the provided credentials
6. Click Language
7. Check the language settings. Now it works like as expected and the default Application Language: English and default
Application Territory: Netherlands are selected here.
Because of this a data grid / report will not function as expected with comma's as decimal signs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document