Should ORA_NLS10 be set to $ORACLE_HOME/nls/data/9idata for Oracle applications 11i on 11gR2 Databas
Hi all,
According to metalink note : Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) (Doc ID 881505.1)
ORA_NLS10 should be set to $ORACLE_HOME/nls/data/9idata
But according to another metalink note : Creating a Text Index Fails with DRG-00100 [51021],[drwaf.c],[1615] (Doc ID 1576539.1)
The $ORACLE_HOME/nls/data/9idata directory is no longer needed for EBS application running on 11.2 database. For database release 11.2, ORA_NLS10 should NOT be set. It should be left at the default setting which is $ORACLE_HOME/nls/data.
Which one is true statement? what shoud be followed?