When you set up your users, you reference a display profile. A user's display profile controls how dates, times, and numbers displayed. Choose to maintain display profiles.
Description of Page
Enter a unique Display Profile ID and Description to identify the profile.
Enter a Date Format. This affects how users view dates and how entered dates are parsed. This is a "free format" field with some rules.
dd or d is interpreted as the day of the month. The d option suppresses a leading 0.
MM or M is interpreted as the month number. The M option suppresses a leading 0.
yyyy, yy, or y is interpreted as the year. The year can be 4 or 2 digits. The y option allows entry in either 2 or 4-digit form and is displayed in 2-digit form.
Other characters are displayed as entered. Typically, these other characters should be separators, such as "-", ".", or "/". Separators are optional; a blank space cannot be use.
Here are some examples of date formats.
Format | Displayed / entered as |
---|---|
MM-dd-yyyy | 04-09-2001 |
d/M/yyyy | 9/4/2001 |
yy.MM.dd | 01.04.09 |
MM-dd-y | 04-09-01 - in this case you could also enter the date as 04-09-2001 |
In addition, the following date localization functionality is supported. Note that in every case, the date is stored in the database using the Gregorian format. The settings below result in a conversion of the date for the user interface.
Hijri Dates
Entering iiii for the year is interpreted as a year entered and displayed in Hijri format. For example, the Gregorian date 2014–05–30 may be entered / displayed as 1435/07/30 for a user whose display profile date format is iiii/MM/dd. Note that this functionality relies on date mapping to be defined in the Hijri to Gregorian Date Mapping entry. Refer to Additional Hijri Date Configuration for more information.
Taiwanese Dates
Entering tttt for the year is interpreted as a year entered and displayed in Taiwanese format where year 1911 is considered year 0000. For example, if the Gregorian date is 01-01-2005, it is displayed as 01-01-0094 for a user whose display profile date format is dd-mm-tttt.
Japanese Dates
There are two options available for configuring Japanese Era date support. The setting Gyy for the year is interpreted as a year entered and displayed using an English character for the era followed by the era number. The letter ‘T’ is used for dates that fall within the Taisho era. The letter ‘S’ is used for dates that fall within the Showa era and the letter ‘H’ is used for dates that fall within the Heisei era. For example, for a user whose display profile date format is Gyy/mm/dd the Gregorian date 2008/01/01 is shown as H20/01/01 ; the Gregorian date 1986/03/15 is shown as S61/03/15. The setting GGGGyy is interpreted as a year entered and displayed using Japanese characters for the era followed by the era number.
Japanese date limitations are as follows:
The years 1912 through the current date are supported.
Any functionality that displays Month and Year does not support Japanese Era dates. These dates are shown in Gregorian format.
Graphs that display dates do not support the GGGGyy format.
Enter a Time Format. This is a "free format" display with some rules.
Here are some examples of time formats.
Format | Displayed / entered as |
---|---|
hh:mma | 09:34PM (can be entered as 09:34p) |
hh:mm:ss | 21:34:00 |
h:m:s | 9:34:0 |
There are several options for displaying Numbers.
Decimal Symbol defines the separator between the integer and decimal parts of a number. Valid values are "." (a period) or "," (a comma),
Group Symbol defines the means to separate groups of bigger numbers. Valid values are
"," (comma). Large numbers group by threes separated by a comma, for example 1,000,000.
"." (period). Large numbers group by threes separated by a period, for example 1.000.000.
None. Large numbers do not have any separator, for example 1000000.
South Asian. This option uses a comma for its separator but will group large numbers as follows: the first comma is used for the thousands separation and numbers over 9,999 are grouped with 2 units, for example 10,00,000.
Space. Large numbers group by threes separated by a space, for example 1 000 000.
Negative Format defines how negative values are displayed. Valid values are -9.9, (9.9), or 9.9-.
Currency values can have a different Negative Format from other numbers. Valid values are -S9.9, (S9.9), or S9.9-, where the "S" represents the currency symbol.
Where Used
Follow this link to open the data dictionary where you can view the tables that reference CI_DISP_PROF.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]