EBS 12.2.4 Turkish NLS Problems

[Berke]

Hello Erman,

We have a Oracle EBS 12.2.4 Production VM Template. We wanted to apply Turkish NLS so we have followed the steps  given in the  How To Add A New Language In R12 (Doc ID 1511692.1) and R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1) .

After we have applied the TSP, we were still seeing the forms in English.
Even though we have applied 10124646_TR (12.2.0 Turkish NLS) and  17919161_TR(12.2.4 Turkish NLS) we still couldnt see the forms in Turkish other than some mesages in Turkish.

Our problem can be seen below. Even though we have Turkish messages, we are getting US forms.


Güncel Ekran
----------------------------------------
Ekran Uygulaması : İnsan Kaynakları
Ekran Adı : PERWSHRG
Ekran Dizin Yolu : /u01/install/APPS/fs1/EBSapps/appl/per/12.0.0/forms/US/PERWSHRG.fmx
Ekran Sürümü : 12.0.41.12020000.14
Ekran Son Değişikliği : $Date: 2013/05/22 07:29  $
-------------


According the output below we dont have Turkish Forms. How can this be?

[applmgr@t1vstebsapp02 NLS_Patch]$ cd $PER_TOP
[applmgr@t1vstebsapp02 12.0.0]$ ls
admin  flash  forms  help  html  java  log  mds  media  mesg  out  patch  reports  sql  xml
[applmgr@t1vstebsapp02 12.0.0]$ cd forms/
[applmgr@t1vstebsapp02 forms]$ ls
US


Thanks

[ErmanArslansOracleBlog]

It seems, it didnt generate the TR directory and files (like turkish forms)

First check the following blog post;
http://ermanarslan.blogspot.com.tr/2014/06/ebs-122-applying-nls-translation-patches.html

did you do all the steps mentioned there?

[ErmanArslansOracleBlog]

I didnt see the logs, but here is a known issue;

When installing a new language, you might encounter failure during forms generation for 'per forms/<Language Code> PERWSBFR.fmx'. To fix this issue, after running 'adop phase=finalize' for that patching cycle, run AD Admin to regenerate this specific failed form on the RUN file system. Refer to Oracle E-Business Suite Maintenance Guide, 'Applications DBA System Maintenance Tasks and Tools' chapter which has information on how to Generate Product files.

Note: Ensure that you choose the correct file system prior to using AD Administration tasks.

[Berke]

Hello,

I have followed the steps you listed in that document. Although, i think this problem might have be present in other forms too since somehow I dont have Turkish forms under Per directory and adadmin doesnt create it again.

Below you may see that I have applied every NLS software patch.

select * from ad_applied_patches where patch_name in  ('10124646' , '17919161');

34387 10124646 MAINTENANCE-PACK 12.2.0 DRV 4/24/2015 7:02:49 AM 5 4/24/2015 7:02:49 AM 5
17373 10124646 MAINTENANCE-PACK 12.2.0 DRV 11/26/2012 7:49:40 PM 5 11/26/2012 7:49:40 PM 5
16373 10124646 MAINTENANCE-PACK 12.2.0 DRV 11/26/2012 3:34:49 PM 5 11/26/2012 3:34:49 PM 5 Y
34388 17919161 MAINTENANCE-PACK 12.2.4 DRV 4/24/2015 7:30:02 AM 5 4/24/2015 7:30:02 AM 5
32380 17919161 MAINTENANCE-PACK 12.2.4 DRV 8/11/2014 12:55:11 PM 5 8/11/2014 12:55:11 PM 5 Y
33377 17919161 MAINTENANCE-PACK 12.2.4 DRV 8/11/2014 8:38:06 PM 5 8/11/2014 8:38:06 PM 5 Y


I have checked the logs and it says in the adpatch log that NLS patch for 10124646 is not applied. How can that be even though it is seen in the query result.

The section where it says that adpatch is not applied:

Current View - 10124646:TR is NOT_APPLIED
Comprising patches - 10124646:US is NOT_APPLIED
Current View - 10124646:US is EXPLICIT

[Berke]

I have also couldnt find patch 10124646:US . If I ever need to apply that too although I have it listed in the database, where can I find it? It is said that edelivery.oracle.com has it but I just couldnt find it.

[ErmanArslansOracleBlog]

For 12.2- >
Apply NLS version of Release 12.2 Patch 10124646 and NLS version of the last applied American English Release Update Pack, for each of the new languages in the system


All references to "NLS Patch 10124646" and "NLS Release 12.2.0 Patch 10124646" refer to the Release 12.2 NLS software for the language. The software is available from the NLS DVD media or from EPD (http://edelivery.oracle.com/). The NLS software is a zip file that contains the NLS Release 12.2.0 Patch 10124646, a README.txt file and a README.html file with instructions on how to install the NLS software.

1)What are you trying to achieve? Are you installing a new EBS 12.2.0  or are you upgrading EBS 12.2.0 to 12.2.4?

2)What did you do so far? (For example : Installed EBS 12.2, applied the patch X and so on)

[Berke]

Hello,

We have already an  EBS with version 12.2.4  . We are trying to setup Turkish Translation on our System.

We have installed EBS 12.2.4 Production VM from edelivery. Then we have licenced Turkish and maintained multi language from adadmin. We updated current snapshot from adadmin and then we asked for a TSP. We applied that TSP. But we have seen that it was not enough as we didnt see forms in Turkish. Therefore we have applied EBS 12.2.0 NLS Software for Turkish  and 12.2.4 NLS software for English. Even then it was not enough so we must be skipping something or the patches are not applied.


Regarding the matter 10124646, in the SQL result that we have sent, you can see that 10124646 is applied but in the patch log it says that it is not applied. That confused us.


Even if we have wanted to apply 10124646 again, we couldn't find it in http://edelivery.oracle.com/

[ErmanArslansOracleBlog]

Normally, after you import the 12.2.4 template, you need to reqeuest a TSP and apply the TSP.
So, you did this already, but the translated forms files are missing.

Can you send me the TSP log files.

[Berke]

I have sent you the TSP logs via mail. I will upload docs from the forum  for NLS software patches.

[Berke]

Hello,

I have attached the log files of our NLS software installation logs within this post. 28.rar


25.rarZip file called 25.rar includes the log files of the TSP patch.

[ErmanArslansOracleBlog]

Note that:
After apply we continue with adop=finalize. In this phase, application and database specific actions such as compilation takes place.


Did you finalize this?

Adop phases:

Prepare:

Syncronization of patch and run on the filesystem.( Oracle doesnt blindly copy everyting.. It is an incremental sync) Only files changed after the last patch are copied. Patch FS= Run FS --> they become synced.
A new patch edition in the db is created. Copies made for every code object. They are virtual copies though..The copied objects are actually pointers. They dont consume space.. Only, when an object is patched, it become real/actualized, and only then it consumes space.
For ex: When you change a view or package , it become real and occupy space inside the patch edition..
Note that: Objects like Tables and Indexes are not copied  in online patching, as they are non-editioned objects!

Apply:

Adop runs adpatch to apply one more patches.
Patches are applied to the Patch edition. Normally, in a EBS patch, we have a fs patch driver and db patch driver in the backend.So, Fs patch driver uses patch filesystem(lets say fs2), and db driver uses patch edition created in prepare phase.

Finalize:
It is just a staging point. We compile invalid objects, generate derived objects, pre-compute ddl to be run at cutover and getting ready.
--We can pause at this stage as long as we want. We can wait for the appropriate downtime for the cutover in this stage.

Cutover: (downtime in minutes)

It restarts the application on the patched copy.
Oracle cutovers to the patch edition of the FS , and cutovers to the patch edition of the db.
Oracle(adop) restarts the middle tier services.
Users are logged off when the middle tier is stopped. Run FS becomes the Patch FS (vice versa) and Run Db edition becomes the Patch Db edition (vice versa)
In this stage, a final maintanence is performed, too.
At the end, the users are brought back online on the patched System..

Cleanup:

We do the cleanup the keep the System tablespace clean. In this phase, Adop deletes the unnecessary editioned objects on the db tier.
Once all objects are deleted from an old edition. The old edition itself is deleted, too.
Filesystems are resyncronized..(Oracle doesnt delete any files on FS actually )

[ErmanArslansOracleBlog]

Also send me the manifest file that you sent to the Oracle Support for getting the relevant TSP patch.

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

[Berke]

Hello,

I am attaching 25 again.25.001

I am also sending you adgennls textadgennls.txt

[Berke]

Hello,

A couple of updates on our case:
-We dont have the adgennls.txt of the time when we ordered TSP. I have mistakenly sent you the adgennls.txt of the current environment.

-Applied_patch.xls The applied patch output could help us see whether patches were defined or not.

[ErmanArslansOracleBlog]

1)
Is your modules licensed? For example: Is your HR licensed? If it is not licensed, it "may" be cause this to happen.  If that's the case, license your applications and apply the TSP patch again.

Also there is a very little chance that the TSP patch may also be wrong, you need to analyze the patch driver files and see if it is really designed to generate those form files..

2)
translation manifest file looks good.
It has all the fmb files listed there..
So your TSP should contain the TR version of the form files.
But when I look at the patch logs, I dont see all the form files are generated..
For example PER forms are not generated and  that 's the problem..
Somehow, adop /or lets say adpatch behaves likes this. It seems it does not feel itself need to compile/generated these kind of forms..

If your licensed are good;
This may be a result of multiple nls patching iterations.
I suggest you to update complete appl_top , and request the TSP patch again.
$   adadmin  <follow initial prompts>
             2.    Maintain Applications Files menu
                 4.    Maintain snapshot information
                    2.    Update current view snapshot
                       1.    Update Complete APPL_TOP

[Berke]

Hello Erman,

We have solved our NLS Problem. In fact, our licences were not complete. Therefore:
1- We licenced HR module for the application.
2- Then we updated our Snapshot information with Complete APPL_TOP option.
3- Then we applied the TSP Patch that we have ordered before.

In the end we were successful. The disappointing thing was the Oracle Documentation regarding the NLS setup still doesn't include this case. We have to have the modules licenced that we are going to use so that all TSP could show its effect.

Thanks,