add language

[Eden Yu]

Hi Erman . I have a doubt.
I want to installing a new language fro EBS 12.2.7.

Now I am doing this
1). adop  phase=prepare
2).[applmgr@ebshost 24690690_ZHS]$ adop phase=apply


But it has error.I do not know how this file came from.
(/u01/oracle/apps/fs2/EBSapps/appl/pa/12.0.0/patch/115/publisher/templates/ZHS/PAXRWPJS_XML.xlf (No such file or directory))
adwork001.log

Can you give me some solutions?

[ErmanArslansOracleBlog]

First check whether you have the file or not..

cd $APPL_TOP
find . -name 'PAXRWPJS*' -print

You first installed 12.2.0 and then you tried to upgrade it to 12.2.7 , right?

So did you applied NLS version of 12.2.0 before upgrading it to 12.2.7?

Please note that: The 12.2.0 patch only installs the base 12.2.0 files. File PAXRWPJS_XML.xlf should be provided via the associated NLS patch for 12.2.

If you didn't install 12.2.0's NLS version, you can add your new language by using a translation sych patch.

Read this: http://ermanarslan.blogspot.com.tr/2014/06/ebs-122-applying-nls-translation-patches.html

[Eden Yu]

Hi Erman，Thank you for your answer!

I've checked it.
[applmgr@ebshost ~]$ cd $APPL_TOP
[applmgr@ebshost appl]$ pwd
/u01/oracle/apps/fs1/EBSapps/appl
[applmgr@ebshost appl]$ find . -name 'PAXRWPJS*' -print
./pa/12.0.0/reports/US/PAXRWPJS.rdf
./pa/12.0.0/patch/115/sql/PAXRWPJSB.pls
./pa/12.0.0/patch/115/sql/PAXRWPJSS.pls
./pa/12.0.0/patch/115/publisher/defs/PAXRWPJS_XML.xml
./pa/12.0.0/patch/115/publisher/templates/US/PAXRWPJS_XML.rtf

You first installed 12.2.0 and then you tried to upgrade it to 12.2.7 , right?
Yes.

So did you applied NLS version of 12.2.0 before upgrading it to 12.2.7?
No.

And I will try install  12.2.0's NLS and upgrade it to 12.2.7.
(We're just studying the preparatory process first.)

[Eden Yu]

I have another doubt.About patch 25525148.

Now I am doing this：
1) cd /u01/StageR122/startCD/Disk1/rapidwiz/bin
2)  ./buildStage.sh
3) cd /u01/StageR122/patches/StartCD51/25525148
4) ./patchRIStage.sh
5) cd /u01/StageR122/startCD/Disk1/rapidwiz
6) ./rapidwiz


But 4) just copy ten file.
Patch 25525148,RAPID INSTALL CONSOLIDATED ONE-OFF BUNDLE ON TOP OF STARTCD 51,right?
I think it should install everything  patches(in the /u01/StageR122/patches),and The ETCC inspection will directly pass through.

[ErmanArslansOracleBlog]

First of all, you need to understand one thing ->

there are 2 methods for enabling an additional language in EBS 12.2.

1)you install EBS 12.2.0 & its NLS patch.. And afterward you apply the NLS patches for every patch that you apply during your upgrade. (you do this process by following EBS documents and patch readmes..)
 
2)you install EBS 12.2.0  and upgrade it to 12.2.7.. (you do this process by following EBS documents and patch readmes..) Once you upgrade your EBS to 12.2.7; you request a translation synchronization patch
and apply that patch to enable your additional language in your EBS 12.2.7 instance..


In other words;

Apply NLS version of Release 12.2.0 and NLS version of the last applied American English Release Update Pack, for each of the new languages in the system.
OR
My Oracle Support Knowledge Document 252422.1, Requesting Translation Synchronization Patches. Follow the instructions for new language installation

[ErmanArslansOracleBlog]

Please create a seperate/new issue for your new question..
The last question you asked about the patching is not related with this topic.

Open a new issue and I will support you from thereç

[Eden Yu]

Hi Erman,

I fully understand what you say.
Now we are still choosing service providers, there is no way to see My Oracle Support Knowledge Document 252422.1.
So I have to restart the installation.

Thank you for your reminder!

[ErmanArslansOracleBlog]

So, you don't have an Oracle SUPPORT account.. I understand.. you can't reach the document named "R11i / R12 : Requesting Translation Synchronization Patches (Doc ID 252422.1)".

Then, you can follow my note to understand the Translation Synch Patching..

I can give you my notes on this:

Example: to apply NLS ( Turkish ) Language patch, follow the instructions in correct order :

· Activate the new language using the Oracle Applications Manager (OAM) License Manager.

· Maintain snapshot information

· Run the AD Administration utility to maintain multi-lingual tables from the Maintain Applications Database Entities menu.

· Log on to your Applications' administration node as the APPLMGR user and source the APPL_TOP environment file. If you are on Release 12.2.0 or above, make sure you are connected to the RUN edition. Use the manifest generation tool to generate a manifest file by executing the following command:

perl $AD_TOP/bin/adgennls.pl

The manifest generated from the tool is located at :
$APPL_TOP/admin/$TWO_TASK/out/adgennls.txt

Request a translation sync path using "https://updates.oracle.com/TransSync"
Upload and apply patch with adop through an online patching cycle (prepare,apply,finalize,cutover,cleanup)

[Eden Yu]

Hi Erman ,

I just tried to install NLS patch(10124646) on ebs 12.2.0,but it still made a mistake.

What should I do?



Log:

[Eden Yu]

And I run adopscanlog.

It outputs the contents of the file.

1.txt

[ErmanArslansOracleBlog]

What error this WMSLABEL.fmx generates while compiling..?

check the logs, find the compile command for WMSLABEL.fmx.  Execute it yourself and send me the output...

[Eden Yu]

This is log :
**********************************************************


Time when worker completed job: Wed Jan 17 2018 14:32:37


Time when worker started job: Wed Jan 17 2018 14:32:37


Start time for file is: Wed Jan 17 2018 14:32:37


Executing 'parallel_fs' command with filesystem action "formgen"

Connect string is: "APPS/*****"

The filelist for the Oracle Forms object to generate is:

wms forms/ZHS WMSLABEL.fmx /u01/oracle/apps/fs2/EBSapps/appl/wms/12.0.0/forms/ZHS/WMSLABEL.fmx


**********************************************************
You are running adfrmgen

Header information is:
  $Header: aiogfm.lc 120.11.12020000.4 2016/04/12 12:14:18 seetsing ship $

Start of adfrmgen session
Date/Time is Wed Jan 17 2018 14:32:37
Filelist file is: /u01/oracle/apps/fs2/EBSapps/appl/admin/PROD_patch/out/pwlapp004.txt
Database connect string is: APPS/*****


Generating Oracle Forms files...

  Temporarily resetting FORMS_PATH to:
  "/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/resource:/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS:/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/resource/ZHS"

Generating form "forms/ZHS/WMSLABEL.fmx" with command:

/u01/oracle/apps/fs2/EBSapps/10.1.2/bin/frmcmp_batch module=/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS/WMSLABEL.fmb output_file=/u01/oracle/apps/fs2/EBSapps/appl/wms/12.0.0/forms/ZHS/WMSLABEL.fmx module_type=form batch=yes compile_all=special


ERROR generating form "forms/ZHS/WMSLABEL.fmx" from input file
/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS/WMSLABEL.fmb

Results of form generation:
(from file /u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS/WMSLABEL.err
 AD Worker has deleted the original .err file)
-------------------------------------------------------------------------


I change FORMS_PATH and execute command.
Output:
2.txt

[Eden Yu]

This is my order of installation:
1. Installation EBS 12.2.0
2. EBS Technology Codelevel Checker,and apply db Patches
3. EBS Technology Codelevel Checker,and apply app Patches
4. Apply Consolidated Seed Table Upgrade Patch
5. Apply the Latest AD and TXK Delta Release Update Packs
6. APply 12.2.0 NLS

[ErmanArslansOracleBlog]

Do you have the following objects in your database?

Connect with APPS user and check their existence and their status:

mgd_idencoding_category , mgd_idencoding_type

[Eden Yu]

None of them exist.

-----------------------------------------------
[oracle@ebshost ~]$ sqlplus apps/apps

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 18 09:08:03 2018

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

Last Successful login time: Thu Jan 18 2018 09:06:32 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select * from mgd_idencoding_category ;
select * from mgd_idencoding_category
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from mgd_idencoding_type ;
select * from mgd_idencoding_type
              *
ERROR at line 1:
ORA-00942: table or view does not exist
--------------------------------


In the previous command, I always used the system account to operate the database.

Does it had an impact?

[ErmanArslansOracleBlog]

Check by querying dba_objects

[Eden Yu]

Still does not exist.


SQL> select owner,object_name,object_id from dba_objects where object_name='mgd_idencoding_category';

no rows selected

SQL> select owner,object_name,object_id from dba_objects where object_name='mgd_idencoding_type';

no rows selected

[ErmanArslansOracleBlog]

write the object names with UPPERCARSE letters in your query! and send me the result afterwards

[Eden Yu]

Hi  Erman,

The result is the same as before.

-------------------------------------------------
SQL> select owner,object_name,object_id from dba_objects where object_name='MGD_IDENCODING_CATEGORY';

no rows selected

SQL> select owner,object_name,object_id from dba_objects where object_name='MGD_IDENCODING_TYPE';

no rows selected
-------------------------------------------------

And I found a similar problem with me.
It mentioned that this is a bug.
https://community.oracle.com/thread/4036781

[ErmanArslansOracleBlog]

Weird.

You have 4 choices >

choice 1) Risk everyting :)
anyways, take a full apps+db backup and implement the actions in the following document ->

R12 Generating Form WMSLABEL.fmx fails with 'FRM-30064: Unable to parse statement' after Patch has been applied (Doc ID 761949.1)

This seems to be for 12.0.6, but people applies it for 12.1 as well.
So why not for 12.2..
This is a TEST installation, anyways right?

Take a backup and implement..

Update me with the outcome..


choice 2)Change your NLS enablement method..
I mean do your installation and upgrade without applying NLS patches.
But  at the end, request a Translation Sync Patch and apply it.

choice 3)Wait Oracle to solve the bug named : Bug 25931734 : FAILED TO GENERATE FORM WMSLABEL IN 12.2.0

choice 4) ignore the error (make adop ignore it) , if you are not planning to use that FORM.