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.]