Configuring Oracle NLS Language Parameters for use with ESI
To configure the Oracle ERP system to run in a particular language, the Oracle NLS parameters must be set for use with Windchill ESI. The NLS language parameters for Oracle sessions created by Windchill ESI must agree with the language configuration of the TIBCO environment. This will ensure that all TIBCO messages, database error messages, and Oracle ERP system messages are returned in the same language. It also ensures that localized Oracle ERP system data for Objects, Bills of Material, and Engineering Change Orders are saved correctly.
Windchill ESI uses a trigger to set the NLS language parameters for each Oracle database session. The trigger sets the values for NLS_LANGUAGE and NLS_TERRITORY. No other NLS parameters should be set or modified. Doing so may cause publish operations to fail or a possible data corruption.
The script listed below creates a trigger that sets the NLS parameters. The trigger gets installed in the Oracle schema that owns the other Windchill ESI and TIBCO database objects.
esi_nls_parm_trg.sql
To configure the NLS parameters for a particular language, modify the script and set the NLS_LANGUAGE and NLS_TERRITORY values appropriate for your environment. The script contains the settings for valid combinations of NLS_LANGAUGE and NLS_TERRITORY. Configure the trigger for your environment by selecting the desired NLS values by removing the two dashes at the start of each line.