Regionalization is the process of creating software that is able to be translated more easily. Changes to the code are not specific to any particular market. Order Management System supports multiple decimal and thousand separators as well as multiple date formats. Order Management System currently supports English as the language of the application.
This topic describes the configuration settings and features of the software that ensure that the base application can handle regionalization.
In this chapter:
• Defining Translation Defaults during Installation
• Setting the Default Date Format
• Setting the Default Decimal and Thousand Separator Format
For more information: See:
• Multi Currency by Offer (E03) for more information on how to configure the system to take orders in more than one currency.
• Using Alternate Currency Pricing for more information on how to configure the system to price offers in a foreign currency.
Recommended Screen Size
In order to align screens correctly, the default size of the application window has been adjusted to 800 x 1200. Displaying the application in this window size is recommended for most screens except the Streamlined Order Inquiry (DORI) menu option.
Defining Translation Defaults during Installation
During installation, the system:
• sets the base locale for the application to en (English) since English is the only supported language at this time. The system stores this locale in the DEFAULT_LOCALE property. See Setting the Default Locale for more information on defining a locale at the system, company, and user level.
• prompts for the base date format for the application. The system stores this date format in the DEFAULT_DATE_FORMAT property. See Setting the Default Date Format for more information on defining a date format at the system, company, and user level.
• prompts for the base decimal separator and thousand separator for numeric fields in the application, such as price and weight. The system stores the default decimal separator and default thousand separator in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties. See Setting the Default Decimal and Thousand Separator Format for more information.
• assigns the default locale and default date format to the admin user created during installation.
During installation, the system sets the default locale of Order Management System to en (English) since English is the only supported language at this time. The system:
• Stores the default locale in the DEFAULT_LOCALE property. When you create a new user or company, the system assigns the default locale to the user or company.
• Defaults this locale to the Locale field in the Company table for the companies delivered with Order Management System.
• Defaults this locale to the admin user that is created during installation.
Setting the Default Date Format
During installation, the system prompts for the default date format of Order Management System. The system:
• Stores the default date format in the DEFAULT_DATE_FORMAT property. When you create a new user or company, the system assigns the default date format to the user or company. However, you can change the date format for a company in Work with Companies (WCMP) and you can change the date format for a user in Work with Users (WUSR).
• Defaults this date format to the Date format field in the Company table for the companies delivered with Order Management System. You can change the date format for a company in Work with Companies (WCMP).
• Defaults this date format to the admin user that is created during installation. You can change the date format for a user in Work with Users (WUSR).
Note: Regardless of the date format that displays on screens, dates are stored in the database in CYYMMDD format.
Date Format on Reports, Forms, and Emails
Company date format: Emails, reports and forms that are not generated using Oracle Business Intelligence Publisher, display the date in the date format defined for the company.
Note: Reports that are not associated with a company display the date in the date format defined for the DEFAULT_DATE_FORMAT property.
Oracle Business Intelligence Publisher date format: Reports generated using Oracle Business Intelligence Publisher display the date in the date format defined in Oracle Business Intelligence Publisher for the locale in the Company table. Since the only locale supported is English, the date format for reports generated using Oracle Business Intelligence Publisher is always MM/DD/YY.
Date Format on Home Screen
User date format: The dates on the Open, Held Order Recap Dollars pie charts and Order Statistics display in the date format defined for the user.
Date Format on Screens
User date format: Unless otherwise noted, dates on screens display in the date format defined for the user.
Note: When manually entering a date on a screen, such as in a scan field, certain screens in the application require you to include forward slashes in the date. For example, if the Date Format defined for your user ID is MMDDYY, you need to manually enter the date as MM/DD/YY on the screen, such as 12/25/16 and not 122516. If you do not include the forward slashes, the system displays an error message indicating the valid date format and that slashes are required.
Company date format: The expected ship date included in the backorder card message that displays on the Display Order History screen, indicating when a backorder card was generated for the order, displays the date in the format defined for the company so that the date format in the message matches the date format included on the backorder card/email.
Date Entries in System Control Values
User date format: Date entries in system control values, such as the Tax Inclusive Cutoff Date (E79), display in the date format defined for the user.
Date Format of User Entered Dates
Not translated: When a user enters a date in a message or text field, such as an order message or tickler note, the system stores and displays the date in the format it was entered.
Date Format in APIs
Dates in APIs do not use the date format defined for the user or company. See each specific XML message in XML Messages for more information on the date format for each message.
Date Format in Uploads
Dates in uploads do not use the date format defined for the user or company. See each specific upload in Working with File Uploads (WUPL) for more information on the date format for each upload.
Calendar Widget
When you select a date from the calendar widget, the date displays in the date format defined for the user.
Setting the Default Decimal and Thousand Separator Format
During installation, the system prompts for the following values to determine the default decimal and thousand separator of Order Management System.
• Default decimal separator: The character format used to indicate the decimal place in a number. The system stores the default decimal separator in the DECIMAL_SEPARATOR property. This property is used for any numeric field that contains a decimal, such as price, cost, and weight.
• Default thousand separator: The character format used to separate groups of thousands. The system stores the default thousand separator in the THOUSAND_SEPARATOR property. This property is primarily used on reports and is not entered by a user.
Supported Formats
Default Thousand Separator |
Default Decimal Separator |
Results |
, (comma) |
. (period) |
4,294,967,295.00 |
. (period) |
, (comma) |
4.294.967.295,00 |
Number Format on Home Screen
Default number format: The Home screen displays numbers using the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties.
Number Format in Menu Options
Default number format: Screens in menu options display numbers using the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties.
Number Format on My Jobs, My Docs, My Forms
Default number format: The Job Management (My Jobs), Document Management (My Docs), and Forms Management (My Forms) screens display numbers using the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties.
Number Format of User Entered Numbers
Default number format: When a user enters a number, the correct decimal separator must be used and the thousand separator should not be entered since it is implied.
Example: To enter the number one thousand eleven and fifty cents:
• if the default decimal separator is . (period), enter 1011.50
• if the default decimal separator is , (comma), enter 1011,50
Number Format on Reports, Forms, and Emails
Default number format: Emails, reports and forms that are not generated using Oracle Business Intelligence Publisher display numbers using the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties.
Oracle Business Intelligence Publisher format: Reports and forms generated using Oracle Business Intelligence Publisher use the number format defined in Oracle Business Intelligence Publisher for the locale in the Company table. Since the only locale supported is English, the decimal separator is always a period (.) and the thousand separator is always a comma (,).
Number Format in APIs
Numbers in APIs do not use the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties. See each specific XML message in XML Messages for more information on the number format used in each message.
Number Format in Uploads
Numbers in APIs do not use the characters defined in the DECIMAL_SEPARATOR and THOUSAND_SEPARATOR properties. See each specific upload in Working with File Uploads (WUPL) for more information on the number format used for each upload.
| Application Configuration | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Advanced Queuing |
internationalization OROMS 17.0 2018 OTN