Do you have any recommendation on Oracle NLS settings for 3.4.2?


I’ve currently seen an error when importing the data pump dump of Oracle. The error concerned a failed SQL when creating the REP_TEMPLATE_HDR table. After searching, the error was caused by the default value of column OM_UPDATED_DATE… The default value was a char value in format “DD-MON-RR”, which does not correspond to our nls_date_format setting.

Do you have any recommendation on NLS settings for TRIRIGA Application Platform 3.4.2? I haven’t found any information in the Installation Guide (pdf_tap_install.pdf). Should we define “DD-MON-RR” as nls_date_format and “AMERICAN” as nls_date_language? Note that we will have two languages: EN_US (US English) as the base language and FR_FR (French) as the second language. Thanks in advance for your suggestion!

[Admin: NLS refers to National Language Support parameters in Oracle.]

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s