12 Replies Latest reply on Jan 9, 2014 7:25 PM by Hussein Sawwan-Oracle

Adding a new language in EBS - VISION(12.1.3)

780293 Jan 5, 2014 1:42 PM

Hi All,

I installed vision on Linux-x86(32bit) and upgraded it to 12.1.3 successfully. After upgrading I want to enable Arabic language.

I followed couple of threads but got confused as to apply the NLS base language release for 12.1.1 or directly go for 12.1.3.

Done with the pre-req's

I already followed the document id

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

https://community.oracle.com/thread/2367701

Can anyone give me the exact steps and patches to be applied in order to get the Arabic Language enable on 12.1.3 on my VM-Machine

NLS_CHARACTERSET

AL32UTF8

I followed step given by Hussein

1. From Oracle Applications Manager, go to License Manager and activate or change your base language to a new one.

2. From AD Administration, run Maintain Multi-lingual Tables (AD Administration Main Menu > Maintain Applications Database Entities Menu).

3. Run the Translation Synchronization Patch utility (adgennls.pl). .

4. When you are notified that it is available, apply your Translation Synchronization Patch (TSP) for all languages you requested.

5. Install the Release 12 NLS Help, if available (optional).

For the step 3 do I still need to run the adgennls.pl?

Can anyone give me a brief idea abt this? and whether they need to be carried out in Vision instance too?

Thanks in advance

1. Re: Adding a new language in EBS - VISION(12.1.3)

Srini Chavali-Oracle Jan 5, 2014 2:11 PM (in response to 780293)

Pl follow the steps in MOS Doc 252422.1

HTH
Srini
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Adding a new language in EBS - VISION(12.1.3)

Hussein Sawwan-Oracle Jan 5, 2014 6:18 PM (in response to 780293)

For the step 3 do I still need to run the adgennls.pl?

Yes, I would run it.

Please see:

Oracle Applications NLS Release Notes Release 12 (Doc ID 405294.1)
How to resolve NLS translation issues in an Ebusiness Suite 11i and R12 environment (Doc ID 394112.1)
How to add a new language in R12 (Doc ID 1511692.1)
Troubleshooting NLS issues with Oracle Applications (Doc ID 1478859.1)

Thanks,
Hussein
1 person found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Adding a new language in EBS - VISION(12.1.3)

780293 Jan 6, 2014 5:54 AM (in response to Hussein Sawwan-Oracle)

Hi Hussein & Srini,

Thank you for the answers

My question is as I have upgraded from 12.1.1. to 12.1.3 and now I decided to add Arabic Lang do I have to apply the base release patch for Arabic first i.e 6678700_AR(12.1.1) or shall I go with 12.1.3 patch(9239090_AR)?
Is it mandatory to run the Translation Synchronisation Utility?
As I find in the document [How to add a new language in R12 (Doc ID 1511692.1)] you can apply the NLS patch directly? correct me if I'm wrong.

Thank you in advance
Like Show 0 Likes(0)

Actions
4. Re: Adding a new language in EBS - VISION(12.1.3)

EBSDBA Jan 6, 2014 6:50 AM (in response to 780293)

Hi,

My question is as I have upgraded from 12.1.1. to 12.1.3 and now I decided to add Arabic Lang do I have to apply the base release patch for Arabic first i.e 6678700_AR(12.1.1) or shall I go with 12.1.3 patch(9239090_AR)?

You could do it both the ways. Which are

1. Apply patch 6678700, 9239090 and adgennls.pl

or

2. Run adgennls.pl and apply the arabic patch one time for all (12.1.1+12.1.3+remaining patches not included in 12.1.1 and 12.1.3)

The basic concept of adgennls.pl is to find the translation patch for english patches. For example if you have applied patches 1,2,3,4 for US english. After running adgennls.pl patch oracle will give you the arabic patch for patches 1,2,3,4.

Is it mandatory to run the Translation Synchronisation Utility?

Not mandatory. But if you have applied a patch for US english that fix will work only for english interface.

Thanks
Like Show 0 Likes(0)

Actions
5. Re: Adding a new language in EBS - VISION(12.1.3)

Hussein Sawwan-Oracle Jan 6, 2014 4:43 PM (in response to 780293)

I believe EBSDBA answered your first two questions.

As I find in the document [How to add a new language in R12 (Doc ID 1511692.1)] you can apply the NLS patch directly? correct me if I'm wrong.

Correct, provided that the new language was activated properly and you have run "Maintain Multi-lingual Tables" via adadmin.

Please see "Adding and Maintaining NLS Languages" section in Oracle E-Business Suite Maintenance Procedures

Thanks,
Hussein
Like Show 0 Likes(0)

Actions
6. Re: Adding a new language in EBS - VISION(12.1.3)

780293 Jan 7, 2014 5:35 AM (in response to Hussein Sawwan-Oracle)

Thanks Hussein & EBSDBA

Yes Hussein I did already add the new language and have run the Multi-lingual Tables via adadmin.

I have requested for the Translation Synchronization Patch for which I have received the link to download with password.
I will apply the patch and update the forum.

Thanks once again you guys doing a great job.
Like Show 0 Likes(0)

Actions
7. Re: Adding a new language in EBS - VISION(12.1.3)

780293 Jan 8, 2014 8:05 AM (in response to 780293)

Hi All.

As mentioned earlier this is my VISION instance.
I got the link from Oracle Support for Translation Synchronization Patch. I did download and applied accordingly. Patch Number 18034367_AR
But the workers keep failing and I tried to fixing them by recompiling the invalid objects, exiting from adpatch and restarting the same session.
Tried to skip them by using Option 8.
But still the same issue.
Is it possible to add another language in Vision? Did anyone try this before?
How can I resolve the worker issues. Can anyone help me out?

Thanks you all for your valuable time.

Sam
Like Show 0 Likes(0)

Actions
8. Re: Adding a new language in EBS - VISION(12.1.3)

Asif Muhammad Jan 8, 2014 9:12 AM (in response to 780293)

Hi Sam,

How can I resolve the worker issues. Can anyone help me out?

Please check the failing adworker.log file, which will give you more information for the cause. Post them here so that we may assist you.

Thanks &
Best Regards,
Asif
Like Show 0 Likes(0)

Actions
9. Re: Adding a new language in EBS - VISION(12.1.3)

780293 Jan 8, 2014 1:39 PM (in response to Asif Muhammad)

Hi Asif,

Thanks for your reply.
I found the issue it was with the datafiles which got exhausted. I put the datafiles on autoextend on and restarted the failed workers which indeed started to run again.

Regards,
Sam
Like Show 0 Likes(0)

Actions
10. Re: Adding a new language in EBS - VISION(12.1.3)

Asif Muhammad Jan 8, 2014 1:55 PM (in response to 780293)

Hi Sam,

Great!! Thanks for the update!!!

Thanks &
Best Regards,
Asif
Like Show 0 Likes(0)

Actions
11. Re: Adding a new language in EBS - VISION(12.1.3)

780293 Jan 9, 2014 8:16 AM (in response to Hussein Sawwan-Oracle)

Hi Hussein & EBSDBA,

Thank's for your help. At last I did add Arabic language to my Vision Instance and it works fine.

Cheers:)

Regards,
Sam
Like Show 0 Likes(0)

Actions
12. Re: Adding a new language in EBS - VISION(12.1.3)

Hussein Sawwan-Oracle Jan 9, 2014 7:25 PM (in response to 780293)

Good to hear that, Sam!

Regards,
Hussein
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.