French Translation - CCP

When we are working on multilingual reports , we need to display the concurrent program names and parameters in french language.

We can achieve this in 2 ways.

1. While login to the oracle apps front end, set the language as french and query for the concurrent program and rename it using the google translator.

2. Go to the ccp window and query for the existing program and go to view --> translations, this will give option to enter the french translation for the english version.

Invalid Number error in French Language - NLS_NUMERIC_CHARACTERS

In general , for the amounts columns in english we will use ',' as separator and '.' as digit.But in french ',' will be used as a digit.So while multiplying this value with any other value, it will give invalid number error.

To overcome this we need to make the separator as ',' and digit as '.' using the below command.

select TO_NUMBER('99999,33' , '999999999.99' , 'NLS_NUMERIC_CHARACTERS=",."') from dual

To test the above scenario, you need to set the nls_language and nls_territory at the sql developer.

alter session set nls_language='CANDIAN FRENCH';
alter session set nls_territory='CANADA';