Posts

Multi Language Supported Oracle

Oracle is now Supporting Multilingual   (Meaning we can install other languages along with base Language, So that we can get multiple language Report outputs as on when needed with little effort). Basic Questions: 1. How do i know weather my customer is using multiple languages or not ?. SELECT * FROM FND_LANGUAGES where INSTALLED_FLAG in ('B','I'); 2.How to enable multiple languages for concurrent program ?. Develop an PL/SQL Function to get all the Languages Required in a String format. And add that function as executable. Attach Executable as MLS Function in the CP window. So basically when the program submitted from SRS window, CP will run multiple times Once for each language returned by MLS function. To get the report output in different languages, Need to develop the RTF templates in different languages and attach the templates in XML publisher responsibility, Template session. -- Stay tuned for PL/SQL function (I am going to add shortly)
Recent posts