Apex Websheet Default Application Territory Ignored for User Nobody
Last updated on FEBRUARY 09, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 4.0.2.00.07 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms