Monday, May 5, 2014

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..

20 comments :

  1. Dear Erman,

    I was applying localization Patch 18955675: R12.2 - CLE: Israel Patch Set on my 12.2.3 system. The patch was unable to generate a particular form CLE_F114_CEREC.fmx and failed. There was no invalid object in system and tried to compile it manually but no help.

    I have already raised an SR and waiting for Oracle to come up with something. But I am in tight schedule to deliver the system.

    Did you faced similar kind of issue during applying localization to 12.2.3? Any known workaround for this?

    Regards
    Ribhu

    ReplyDelete
  2. I have applied Turkish Localizations not Israel Localization, but yes I have faced similar problems . Localization patches are like that ..
    I also noticed that, the Localization documents and patches are updated day by day.. So I can say that you made a good thing for raising SR.. Oracle may send you a new patch for fixing the issue.

    At the same I can try to help you.. Can you compile the form using frmcmp utility? Please send me the form compilation log. (copy&paste in here)

    ReplyDelete
  3. By the way, the patch seems to be changed in the document named: R12 EMEA Add-on Localizations - Israel (Doc ID 470635.1).
    Here :
    Patch 18955657: R12.2 - CLE: Israel Patch Set..
    "So can you abort & rollback 18955675 and try to apply 18955657"

    ReplyDelete
    Replies
    1. I do not find any of this update. Kindly let me know which part describes this on the note.

      Ribhu

      Delete
    2. "Israel Add-on Localizations - Complete Set" section of Doc ID 470635.1.
      It says : Patch 18955657 for 12.2

      Delete
    3. It says 18955657 not 18955675..

      Or may be you write it wrong?

      Delete
  4. Tried to compile it manually but form was not generated. Please find below the log:

    Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

    Forms 10.1 (Form Compiler): Release - Production

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    PL/SQL Version 10.1.0.5.0 (Production)
    Oracle Procedure Builder V10.1.2.3.0 - Production
    Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
    Oracle Multimedia Version 10.1.2.0.2 (Production)
    Oracle Tools Integration Version 10.1.2.0.2 (Production)
    Oracle Tools Common Area Version 10.1.2.0.2
    Oracle CORE 10.1.0.5.0 Production
    Compiling package specification LINES_EVENT...
    No compilation errors.

    Compiling package specification AVAILABLE_QF...
    No compilation errors.

    Compiling package specification AVAILABLE_QF2...
    No compilation errors.

    Compiling package specification AXCABMR2...
    No compilation errors.

    Compiling package specification RUNTOT_COMMON...
    No compilation errors.

    Compiling package specification APP_CUSTOM...
    No compilation errors.

    Compiling package specification AVAILABLE_QF_BUTTONS...
    No compilation errors.

    Compiling package specification QUERY_AVTRX...
    No compilation errors.

    Compiling package specification LINES_PRIVATE...
    No compilation errors.

    Compiling package specification AVAILABLE_QF3...
    No compilation errors.

    Compiling package specification LINES...
    No compilation errors.

    Compiling package specification AVAILABLE_QF4...
    No compilation errors.

    Compiling package specification LINES_PRIVATE3...
    No compilation errors.

    Compiling package specification LINES_PRIVATE2...
    No compilation errors.

    Compiling package specification AVAILABLE_PRIVATE2...
    No compilation errors.

    Compiling package specification AVAILABLE...
    No compilation errors.

    Compiling package specification AVAILABLE_PRIVATE...
    No compilation errors.

    Compiling package specification AVAILABLE2...
    No compilation errors.

    Compiling package specification AVAILABLE_AMOUNTS...
    No compilation errors.

    Compiling package specification AVAILABLE_EVENT...
    No compilation errors.

    ReplyDelete
  5. Compiling package specification BATCHES...
    No compilation errors.

    Compiling package specification BATCHES_EVENT...
    No compilation errors.

    Compiling package specification TRX_COMMON...
    No compilation errors.

    Compiling package specification COPY_LINES_EVENT...
    No compilation errors.

    Compiling package specification AVAILABLE_EXCHANGE...
    No compilation errors.

    Compiling package specification RECONCILED...
    No compilation errors.

    Compiling package specification RECONCILED_EVENT...
    No compilation errors.

    Compiling package specification TRX_LOCK...
    No compilation errors.

    Compiling package specification CONTROL_LINES...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_EVENT...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_EXCHANGE...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_PRIVATE...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_SEQNUM...
    No compilation errors.

    Compiling package specification AXCABMR...
    No compilation errors.

    Compiling package specification CONTROL2...
    No compilation errors.

    Compiling package specification CE_CALCULATE...
    No compilation errors.

    Compiling package specification AVAILABLE_EXCHANGE2...
    No compilation errors.

    Compiling package specification CAL_BANK_MATCHED...
    No compilation errors.

    Compiling package specification CAL_BANK_MATCHED_C...
    No compilation errors.

    Compiling package specification COPY2...
    No compilation errors.

    Compiling package specification JAF...
    No compilation errors.

    Compiling package body LINES_EVENT...
    No compilation errors.

    Compiling package specification LINES_EVENT...
    No compilation errors.

    Compiling package specification AVAILABLE_QF...
    No compilation errors.

    Compiling package body RUNTOT_COMMON...
    No compilation errors.

    Compiling package specification AVAILABLE_QF2...
    No compilation errors.

    Compiling package specification AXCABMR2...
    No compilation errors.

    Compiling package specification RUNTOT_COMMON...
    No compilation errors.

    ReplyDelete
  6. Compiling package specification APP_CUSTOM...
    No compilation errors.

    Compiling package specification AVAILABLE_QF_BUTTONS...
    No compilation errors.

    Compiling package specification QUERY_AVTRX...
    No compilation errors.

    Compiling package body QUERY_AVTRX...
    No compilation errors.

    Compiling package body AVAILABLE_QF_BUTTONS...
    No compilation errors.

    Compiling package body AVAILABLE_QF...
    No compilation errors.

    Compiling procedure AVAILABLE_QF_REGIONS...
    No compilation errors.

    Compiling package body LINES_PRIVATE...
    No compilation errors.

    Compiling package body AXCABMR2...
    No compilation errors.

    Compiling package body AXCABMR...
    No compilation errors.

    Compiling package body AVAILABLE_QF4...
    No compilation errors.

    Compiling package specification LINES_PRIVATE...
    No compilation errors.

    Compiling package specification AVAILABLE_QF3...
    No compilation errors.

    Compiling package body LINES_PRIVATE2...
    No compilation errors.

    Compiling package specification LINES...
    No compilation errors.

    Compiling package body LINES...
    No compilation errors.

    Compiling package body AVAILABLE_QF3...
    No compilation errors.

    Compiling package specification AVAILABLE_QF4...
    No compilation errors.

    Compiling package specification LINES_PRIVATE3...
    No compilation errors.

    Compiling package body AVAILABLE_QF2...
    No compilation errors.

    Compiling package specification LINES_PRIVATE2...
    No compilation errors.

    Compiling package body LINES_PRIVATE3...
    No compilation errors.

    Compiling procedure LINES_ST_REGIONS...
    No compilation errors.

    Compiling package specification AVAILABLE_PRIVATE2...
    No compilation errors.

    Compiling package body AVAILABLE_PRIVATE2...
    Compilation error on package body AVAILABLE_PRIVATE2:
    PL/SQL ERROR 201 at line 1029, column 5
    identifier 'CLEF114_CE_AUTO_BANK_CLEAR1.POPULATE_AVAIL_TRX' must be declared
    PL/SQL ERROR 0 at line 1029, column 5
    Statement ignored

    Compiling package specification AVAILABLE...
    No compilation errors.

    Compiling package body AVAILABLE...
    No compilation errors.

    Compiling package specification AVAILABLE_PRIVATE...
    No compilation errors.

    Compiling package body AVAILABLE_PRIVATE...
    No compilation errors.

    ReplyDelete
  7. Compiling package specification AVAILABLE2...
    No compilation errors.

    Compiling package body AVAILABLE2...
    No compilation errors.

    Compiling package specification AVAILABLE_AMOUNTS...
    No compilation errors.

    Compiling package body AVAILABLE_AMOUNTS...
    No compilation errors.

    Compiling procedure LINE_REGIONS...
    No compilation errors.

    Compiling package specification AVAILABLE_EVENT...
    No compilation errors.

    Compiling package specification BATCHES...
    No compilation errors.

    Compiling package body BATCHES...
    Compilation error on package body BATCHES:
    PL/SQL ERROR 201 at line 206, column 13
    identifier 'CLEF114_CE_200_TRANSACTIONS_V' must be declared
    PL/SQL ERROR 0 at line 202, column 7
    SQL Statement ignored

    Compiling package specification BATCHES_EVENT...
    No compilation errors.

    Compiling package body BATCHES_EVENT...
    Compilation error on package body BATCHES_EVENT:
    PL/SQL ERROR 201 at line 158, column 1
    identifier 'CLEF114_CE_AUTO_BANK_CLEAR1.OFFSET_GLOBAL_VAR' must be declared
    PL/SQL ERROR 0 at line 158, column 1
    Statement ignored
    PL/SQL ERROR 201 at line 218, column 9
    identifier 'CLEF114_CE_AUTO_BANK_CLEAR1.OFFSET_GLOBAL_VAR' must be declared
    PL/SQL ERROR 0 at line 218, column 9
    Statement ignored

    Compiling package specification TRX_COMMON...
    No compilation errors.

    Compiling package body TRX_COMMON...
    No compilation errors.

    Compiling package specification COPY_LINES_EVENT...
    No compilation errors.

    Compilation error on package body COPY_LINES_EVENT:
    Compiling package body COPY_LINES_EVENT...
    PL/SQL ERROR 201 at line 805, column 5
    identifier 'CLEF114_CE_AUTO_BANK_CLEAR1.POPULATE_AVAIL_TRX' must be declared
    PL/SQL ERROR 0 at line 805, column 5
    Statement ignored

    Compiling package body APP_MULTI...
    No compilation errors.

    Compiling package body AVAILABLE_EXCHANGE...
    No compilation errors.

    Compiling package specification AVAILABLE_EXCHANGE...
    No compilation errors.

    Compiling package specification RECONCILED...
    No compilation errors.

    Compiling package body RECONCILED...
    No compilation errors.

    Compiling package specification RECONCILED_EVENT...
    No compilation errors.

    ReplyDelete
  8. Compiling package body RECONCILED_EVENT...
    Compilation error on package body RECONCILED_EVENT:
    PL/SQL ERROR 201 at line 37, column 7
    identifier 'CLEF114_CE_AUTO_BANK_CLEAR1.OFFSET_GLOBAL_VAR' must be declared
    PL/SQL ERROR 0 at line 37, column 7
    Statement ignored

    Compiling procedure RECONCILED_REGIONS...
    No compilation errors.

    Compiling package specification TRX_LOCK...
    No compilation errors.

    Compiling package body TRX_LOCK...
    No compilation errors.

    Compiling procedure MULTI_RETURN_ACTION...
    No compilation errors.

    Compiling package specification CONTROL_LINES...
    No compilation errors.

    Compiling package body CONTROL_LINES...
    No compilation errors.

    Compiling package body APP_CUSTOM...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_EVENT...
    No compilation errors.

    Compiling package body MISC_RECEIPTS_EVENT...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_EXCHANGE...
    No compilation errors.

    Compiling package body MISC_RECEIPTS_EXCHANGE...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_PRIVATE...
    No compilation errors.

    Compiling package body MISC_RECEIPTS_PRIVATE...
    No compilation errors.

    Compiling procedure MISC_RECEIPTS_REGIONS...
    No compilation errors.

    Compiling package specification MISC_RECEIPTS_SEQNUM...
    No compilation errors.

    Compiling package body MISC_RECEIPTS_SEQNUM...
    No compilation errors.

    Compiling package body MISC_RECEIPTS...
    No compilation errors.

    Compiling function CE_GET_PERIOD...
    No compilation errors.

    Compiling package specification AXCABMR...
    No compilation errors.

    Compiling package specification CONTROL2...
    No compilation errors.

    Compiling package body CONTROL2...
    No compilation errors.

    Compiling package specification CE_CALCULATE...
    No compilation errors.

    Compiling package body CE_CALCULATE...
    No compilation errors.

    Compiling package body AVAILABLE_EVENT...
    No compilation errors.

    Compiling package body CE_LOOKUP...
    No compilation errors.

    Compiling package specification AVAILABLE_EXCHANGE2...
    No compilation errors.

    Compiling package body AVAILABLE_EXCHANGE2...
    No compilation errors.

    Compiling package specification CAL_BANK_MATCHED...
    No compilation errors.

    ReplyDelete
  9. Compiling package body CAL_BANK_MATCHED...
    No compilation errors.

    Compiling package specification CAL_BANK_MATCHED_C...
    No compilation errors.

    Compiling package body CAL_BANK_MATCHED_C...
    No compilation errors.

    Compiling package body APP_FIND...
    No compilation errors.

    Compiling package body APP_MAINTAIN_OLD_FIELDS...
    No compilation errors.

    Compiling package specification COPY2...
    No compilation errors.

    Compiling package body COPY2...
    No compilation errors.

    Compiling package body APP_ORDER_BY...
    No compilation errors.

    Compiling package body APP_MULTI_PRIVATE...
    No compilation errors.

    Compiling procedure IW_LABLES...
    No compilation errors.

    Compiling function CHECK_MANUAL_TOLERANCE...
    No compilation errors.

    Compiling package body JAF...
    No compilation errors.

    Compiling package specification JAF...
    No compilation errors.


    Compilation errors have occurred.


    Form not created





    Sorry for flooding your blog with compilation log.

    Regards,
    Ribhu

    ReplyDelete
  10. Okay. Did you see my last post?
    ->>By the way, the patch seems to be changed in the document named: R12 EMEA Add-on Localizations - Israel (Doc ID 470635.1).
    Here :
    Patch 18955657: R12.2 - CLE: Israel Patch Set..
    "So can you abort & rollback 18955675 and try to apply 18955657"

    ReplyDelete
  11. I don't know how you find this part. But when I am opening the note there is no trace or mention of rollback. Wish I could share my screen with you.

    Do you found my log helpful to help me out?

    Ribhu

    ReplyDelete
  12. Your log says you have some definition missing in some of the packages..
    Here , for example:
    The object CLEF114_CE_AUTO_BANK_CLEAR1.OFFSET_GLOBAL_VAR can not be found, that s why the relevant package can not compiled.
    This seems to be a patching problem. Opening SR is a good thing for those problems.

    Note that:
    If you are in 12.2 and using adop utility to patch your env, you can rollback a patch.

    The document is clear as follows;

    Israel Add-on Localizations - Complete Set

    Use these links to download the complete set of Add-on Localizations for Israel.

    Installation and Documentation list R12.0.6 R12.1 R12.2
    Patch Set Patch 13859912 Patch 13859912 Patch 18955657

    ReplyDelete
  13. It was a typing mistake. I was applying 18955657 while I encountered the error. Sorry for all the confusion. Oracle has logged for a potential bug for this issue.

    Regards,
    Ribhu

    ReplyDelete
  14. Okay. Oracle will probably prepare a new patch for this..

    ReplyDelete
  15. Hi Erman!
    12.2.6 is out.
    EMEA add on localizations for 12.2.6 (E-Business Suite Add-on Localizations - 12.2.6 Availability (Doc ID 1491965.1)) - will be out by Dec 16.

    We are upgrading from 12.1.3 to 12.2.6
    So, if our user accepting testing will start in the end Jan 17, so hypotetically we have time install those localizations before that user big testing.

    The main user testing can start with the base 12.2 + required 1.2.CLE patches...

    Do you see here problem in this sceanrio ?
    I really dont want to go for 12.2.5 just beacuse localization 12.2.6 patch not ready yet...

    Whats your opinion ?

    Thank you,Linda :)

    ReplyDelete
  16. Sorry - I meant that now we upgrade 12.2.6 +CLE 12.2 required patches and steps -> so technical tests, customiz tests can start.
    Then in Dec 16 when Localization patch will be avaialble -> we will apply it and Jan Acceptance test will start. Any problems you see in his approach ? As I told - taking 1225 just because we have localiz 1225 ready patch ...sounds not good :)
    Thanks,Linda

    ReplyDelete
  17. Hi,

    Seems like a good plan, but there is a risk which needs to be taken. As there is only one month period between the release date of localization patches and UAT, the minor risk is there. So, you should apply the patches and stabilize the system in 1 month. This is normally not a problem for AD and other product patches, but when it comes to localization, the patching time may increase. The localization patches are problematic sometimes, and as these localization patches are prepared for 12.2.6, they are new. No known issues are there for them.. So, I would state this to the business side to make them know about it. As for testing the localizations in UAT, leave the decision to Business leaders, as they will accept or approve the system based on the results of UAT, and will promote the upgrade process to cutover planning and preparation.

    ReplyDelete