Apex Websheet Default Application Territory Ignored for User Nobody (Doc ID 1589894.1)

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.

Symptoms

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.

Cause

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