Oracle E-Business Suite:Applying NLS Patch - Adding Languages To EBS in R12 & R11 - EBS'e Türkçe Dil Desteği Eklemek

After a fresh install of Oracle Production EBS R12.2.4 VM Template on our servers we wanted to add language support on our application system. Therefore we followed this document :"R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)"


In that document, it pretty much says everything about languages in an EBS system. You can either add a new language, or update the current language with respect to the other english file versions, just change the language files with the refreshed translations.

The whole process goes like:

1-We should check out the prerequisites under this topic "Before Requesting Translation Synchronization Patch" .  There some patches that you need to apply. according the patch level. You can check out  the patch level with the following SQL

 select * from fnd_product_installations where patch_level like '%AD%';

If you want to see that a patch is installed or not you can use the following patch: 

select * from AD_APPLIED_PATCHES where patch_name='%';  

2- Then  we activate the new language by using Oracle Applications Manager (OAM) Licence Manager.

We first click on Licence Manager.

Then we activate the language that we want.

3- After the activating the language, we go on with the adadmin utiliy the application node.

You run "adadmin" then go on with the "Maintain multi-lingual tables" which is under the the "Maintain Applications Database Entities Menu"

4- Then we request for a new syncronization patch by running the following command and uploading the output to the  following address.

Command:

 perl $AD_TOP/bin/adgennls.pl 

Output:

 $APPL_TOP/admin/$TWO_TASK/out/adgennls.txt 

Upload Address:

https://updates.oracle.com/TransSync

5- Then you receive  a translation syncrhonization patch to apply. To apply the for R12.2.4 

5.1- Change directory to the patch directory

5.2- Then execute the following command 

"adop phase=prepare,apply,finalize,cutover,cleanup"

6- Last step would be to generate message files from the adadmin utility.

Referances:


1-R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=176620445661286&id=252422.1&_afrWindowMode=0&_adf.ctrl-state=303mg8osv_25


2-Oracle E-Business Suite NLS Release Notes, Release 12.2 (Doc ID 1314621.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=176932629461056&parent=DOCUMENT&sourceId=252422.1&id=1314621.1&_afrWindowMode=0&_adf.ctrl-state=303mg8osv_70


3-How To Troubleshoot NLS Forms Generation Errors When Applying An NLS Patch In R12 Or 11i (Doc ID 1537973.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=273461662123937&id=1537973.1&_afrWindowMode=0&_adf.ctrl-state=1803s998f3_4


4- Oracle E-Business Suite Installation Guide: Using Rapid Install - Part Number E22950-18 - Finishing Tasks - Installing NLS Language Support

https://docs.oracle.com/cd/E26401_01/doc.122/e22950/T422699i4783.htm

5-  Using Lightweight MLS With Oracle E-Business Suite Release 12.1.3 and higher (Doc ID 1077709.1)

Oracle E-Business Suite: Forms Compilation Error - Form Derleme Hatası

In R12.1.3

Recently we have encountered errors such as these:


Compiling KEY-NXTBLK trigger on QUERY_FIND data block...
Compilation error on KEY-NXTBLK trigger on QUERY_FIND data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

It turned out that FORMS60_PATH was not set correctly. Whenever forms are compiled FORMS60_PATH is set to:

FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource

In context file it was set as:

$AU_TOP/resource:$AU_TOP/resource/stub

After correcting this and compiling manually it worked. To make this permanent change the s_f60path to include $AU_TOP/forms/US:$AU_TOP/resource

In R12.2.4 or in R12.2 we should be adding the following to the $FORMS_PATH variable in the context file which is in the $APPL_TOP/$SID_$HOSTNAME.env path  

$AU_TOP/forms/US:$AU_TOP/forms/TR 

After that forms can be compiled with the following command.

E.g.:

frmcmp_batch AKDFLOWB.fmb   apps/apps output_file=$AK_TOP/forms/TR/AKDFLOWB.fmx compile_all=special;


Referanslar:

Forms Compilation hatası
http://oracleappstechnology.blogspot.com.tr/2009/03/forms-compilation-errors.html

Oracle Fusion Middleware: Running RDA For Hyperion - Remote Diagnostic Agent(RDA) - Hyperion için RDA Çalıştırmak

We have written about the RDA before for OBIEE and EBS.

1- http://berkeoz1.blogspot.com.tr/2014/01/oracle-e-business-suite-rda-nedir.html
2- http://berkeoz1.blogspot.com.tr/2014/07/oracle-fusion-middleware-running-rda.html

Now we would like to specify the usage of rda for Hyperion. The need to that has arisen to detect problems in the Hyperion system. What we had used before was the diagnostic tool of Hyperion.
(http://berkeoz1.blogspot.com.tr/2014/08/oracle-hyperion-starting-and-stopping.html)
However we will be using rda as a complementary tool to our diagnostic efforts.

Where is RDA?

RDA is found in the Middleware Home. (For example:E:\Oracle\Middleware\oracle_common\rda)

We could do the setup which is giving the appropriate details for running rda by "rda.cmd -S".

To list all the profiles that we can run we could use:

rda.exe -L

With that command all the modules and previously defined profiles to analyze the system can be found.



An example of the command to run RDA with using just the HFM module is below:

rda.cmd -vSCRP HFM

An example of the command to run RDA with using profile for HFM is below:

rda.cmd -vSCRP -p Hyperion1112_HFM

In the end, we would have something like the directory structure below in which we run first the "RDA_index.htm" file

References:

1-How to Use Remote Diagnostic Agent (RDA) to Gather Diagnostic Information On Oracle Hyperion Financial Management (HFM) Servers to Help Resolve Service Requests Faster [Video] (Doc ID 1100612.1)