EBS -- 12.2 EMEA Add-on Localizations --Turkey

There are localization patch already available for Oracle EBS 12.2 on Oracle Support.
There are two phases to apply the localizations in EBS 12.2.
First we need to apply the prereq patches, then we need to apply the Localization patches.
This post will be about Turkish localizations but in general the same path should apply for other countries, too..

The document to follow for prereq actions is Creating CLE Product & Applying Mandatory Patches for R12.2 EMEA Add-on Localizations (Doc ID 1628719.1) So, firstly, we need to apply patch 13725897. There is only generic version of it. This patch is required to install CLE(EMEA Add-on Localizations).. The instructions for applying this patch is as follows;

Source the run filesystem..
Unzip the patch and copy the .txt files from the 13725897\cle\admin directory  to the $APPL_TOP/admin directory..
Open newprods.txt and modify it if necessary

For example:

product=cle
base_product_top= *APPL_TOP*
oracle_schema=cle
sizing_factor=100
main_tspace= APPS_TS_TX_DATA
index_tspace=APPS_TS_TX_IDX
temp_tspace=TEMP
default_tspace= APPS_TS_TX_DATA

Ensure that you are in the $APPL_TOP/admin directory and then run adsplice from there...  

Note that:  We dont apply 13725897.drv at all..We only use this patch for adsplice operations..

Next, we need to apply patch 13768679(R12.CLE.C) and patch 18367133(R12.2 - CLE:SEED patch for Localization DFF/GDFF, Forms Personalization) .. Note that : There is only generic versions available for patch 13768679.. On the other hand; there are translated version of patch 18367133 available in Oracle Support.

For these two patches we need to execute adop.
we use adop phase=prepare first of all;
then we unzip the patches to the $APPL_TOP_NE/../patch directory
and use adop phase=apply to apply them..
After the applying phase, we continue with performing adop phase =finalize and adop phase=cutover

Note that while applying 13768679, I have encountered the following problems:

CREATE UNIQUE INDEX "CLE"."CLE~FA~MASS~REVALS~EXT" ON "CLE"."CLE~FA~MASS~REVALS~EXT" ("DFF_ID")

  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS

  STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)

  TABLESPACE "APPS_TS_TX_IDX"

 ONLINE

Start time for statement above is Mon Apr 21 22:49:07 EEST 2014

ORA-942 error occured during Index creation.

Invoking Utility FndXdfCmp ...

Class: oracle.apps.fnd.odf2.FndXdfCmp

Method: applyXDF

Arguments: &un_cle &pw_cle &un_apps &pw_apps &jdbc_protocol &jdbc_db_addr table &fullpath_cle_patch/115/xdf_cle_fa_mass_revals_ext.xdf &fullpath_fnd_patch/115/xdf_xsl index_category=small parallel_index_threshold=20000

So it was clear that patch could not create an index on CLE_FA_MASS_REVALS_EXT  table..

It was normal because the index name was CLE~FA~MASS~REVALS~EXT, so the strange character was creating the problem.

So I skipped it, and loaded it manually ..

To load manually, I set the patch environment and used XLIFFLoader 

adjava -mx512m -nojit oracle.apps.xdo.oa.util.XLIFFLoader -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION erptest:1521:TEST -APPS_SHOT_NAME IBY -TEMPLATE_CODE IBYD_TR_APSBISTOTSN  -FILE_NAME CLEDE_TR_APSBISTSN.xlf

So , this action have fixed the problem..

Note that , while applying patch 18367133, I have encounter another problem, and raised an SR for this.

After the investigation, SR have sent me another patch(modified version of the same patch) to replace this one..

So the prereq patches which are applied in these patch have become;

13725897

13768679

18367133 ( I raised an SR and they have sent me the modified version of this patch)

Anyways, after finising the prerequisite patches, we continue with applying the localization patches.

For the localization patches, the document to follow is R12 EMEA Add-on Localizations - Turkey (Doc ID 472686.1) in my case. All of the patches in this contexts have to be applied to using adop.

Functional admins have to choose the needed localization areas, and as Apps Dba's we apply the needed patches for the chose localization.

In this case, we choose to apply the following localization patches:

Turkey Add-on Localizations - Complete Set(16048944) -- translated version of patch is available
Periodic Prepaid Expenses Distribution(18425260) -- translated version of patch is available
BABS Form Reports( 18425376)  -- translated version of patch is available

Unfortuneatly, I have been encountered a big of problem in applying complete set(patch 16048944)

The problem was the form :CLE_F147_ARCNBE.fmx. It could not be compiled. I have opened another SR for this patch, and the SR sent me another patch for compiling this .. p18520314_R12.CLEC_R12_GENERIC.zip.
So after applying patch 16048944 and its translated version, I applied the patch that was sent by SR. --just to compile the problematic form.
Even after this patch, the form could not be compiled, To compile this form, I had to compile the flexfield named  CLE: Additional Info On Receipt Classes using EBS screens..

Anyways, after applying the patch that sent by SR, I could apply  patch 16048944 successfully, and could compile all the CLE forms without any problems.

In brief,  I can't say that EBS 12.2 localizations are ready for the production, unfortuneatly.-- at least Turkish localizations were not ready in my case. 

So I had to open SRs on the way.  On the other hand,  during my SR updates, I also noticed that, the Localization documents and patches are updated day by day.. So next time, we will not face with this kind of errors, I hope..