CPU July-2018 EBS R12.1.3

Patch Location:

/interface/patches/CPU_2018

######################################################################################################

1) Apply AD Pacthes (US) in below order

====>Enable Maintaince Mode

sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

cd /interface/patches/CPU_2018/ADPATCH_US

23231676

24840574

25110821

22284589

23200210

————————————————————>

28018146–> PRE-Steps : adgrants.sql from DB Node

  • Compare the version of adgrants.sql(UNIX) in $APPL_TOP/admin to that in patch directory(PATCH/admin/adgrants.sql)
  • Copy the higher version of adgrants.sql (UNIX) to RDBMS “$ORACLE_HOME/appsutil/admin”

Login to DB tier & use SQL*Plus to run the script as sys user.

sqlplus “/as sysdba”

@$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

Apply Patch –28018146

——————————————————————>

====>Disable Maintaince Mode

sqlplus apps/apps4ebsdb @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

######################################################################################################

2) Apply NLS Pacthes in Hotpacth ( Screen Mode)

screen -S CPU_18JUL

cd /interface/patches/CPU_2018/ADPATCH_NLS/ADPATCH_NLS_D

adpatch options=hotpatch driver=u_merged.drv logfile=CPU_JUL2018_12_17SEP.log

######################################################################################################

Take backup of 10.1.3 and 10.1.2 Homes

cp -pr 10.1.3 10.1.3_bkp_CPU_19SEP

cp -pr 10.1.2 10.1.2_bkp_CPU_19SEP

10.1.3 Patch :

######################################################################################################

1) Apply 21845960———————–>

export OPATCH_PLATFORM_ID=46

echo $OPATCH_PLATFORM_ID

cd /interface/patches/CPU_2018/1013_PATCH/21845960

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch napply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 21845960

unset OPATCH_PLATFORM_ID

OUI Patch

applmgr@of201:/interface/patches $ unzip p6640838_10106_Linux-x86-64.zip

2) Apply 22123753———————–>

cd /interface/patches/CPU_2018/1013_PATCH/22123753

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch apply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 22123753

10.1.2 Patch

######################################################################################################

1) Apply 26825525

cd /interface/patches/CPU_2018/1012_PATCH/26825525

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;

$ORACLE_HOME/OPatch/opatch apply

$ORACLE_HOME/OPatch/opatch lsinventory|egrep 26825525

###################

“Forms having some issues while opening

to fix the issue,Re-deploy forms.ear file

(Given in Readme,but steps are not correct,refer comments)”

“Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1) –Change Password for oc4jadmin

TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — EBSPRD patch opmnctl”

###################

JRE Patch

Using JDK 7.0 Latest Update with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 1467892.1)

Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)

R12 E-Business Suite Java / JRE Upgrade Does Not Correctly Update The 3 Digit Version Of Java Installed In The Context File,

Forms Applications, Or Java Console (Doc ID 2227147.1)

http://erpondb.blogspot.com/2015/11/ebs-r121-patching-for-jre-18.html

######################################################################################################

cd /interface/patches/CPU_2018/JRE

——–Backup of Webapps———————————

cd $COMMON_TOP

cp -rp webapps webapps_bkp_CPU_19SEP

——–Backup of Webapps———————————

==> Apply interoperability Patch 21624242:R12.TXK.B. (ALready Applied ) ******************>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

1)Download 32 Bit Microsoft Version

unzip p27890728_180181_WINNT.zip

cp -p jre-8u181-windows-i586.exe $COMMON_TOP/webapps/oacore/util/jinitiator/j2se18181.exe

$FND_TOP/bin/txkSetPlugin.sh 18181

$FND_TOP/bin/txkSetPlugin.sh 18073 –Revert to old if any issues

Issues :

#########################################################################################################################

diff -y /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp_bkp_18SEP |grep ‘|’

add diff lines

[ VERSION CONFLICTS INFORMATION ]

Template shipped by oracle is having a version different than the template lying in custom directory.

Template shipped by Oracle : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/orion_web_xml_1013.tmp(version: 120.69.12010000.17)

Custom template : /ebsdb/apps/apps_st/appl/fnd/12.0.0/admin/template/custom/orion_web_xml_1013.tmp(version: 120.69.12010000.10)

Please resolve the differences between the two templates or refer to Metalink Note 387859.1 for further details.

Issues :

===============

lsinventory is failing with below error

##############################

LsInventory: OPatch Exception while accessing O2O

OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred:

OPatch Exception: OUI found no such ORACLE_HOME set in the environment

Can not get details for given Oracle Home

An exception occurs

null

##############################

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;

cd $ORACLE_HOME/oui/bin

./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.2 ORACLE_HOME_NAME=EBSDEV_1012_home

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;

cd $ORACLE_HOME/oui/bin

./runInstaller -silent -attachHome ORACLE_HOME=/EBSDEV/tech_st/10.1.3 ORACLE_HOME_NAME=EBSDEV_1013_home

##############################

10.1.2 runInstaller attachHome failing with below error

.The Java RunTime Environment was not found at /tmp/OraInstall2018-09-16_12-18-52PM/jre/bin/java. Hence, the Oracle Universal Installer cannot be run.

##############################

Reason for the error

On investigation,I found the following solution to the problem

The oraparam.ini file is incorrect in $ORACLE_HOME/oui directory.

The line in the oraparm.ini file that was incorrect was:

appltst@of552:/ebsdb/apps/tech_st/10.1.2/oui $ cat oraparam.ini|grep -i JRE|grep -v ^#

JRE_LOCATION=/apps/prd/apps/tech_st/10.1.2/jdk/jre ****************************************************pointing to prod Path

JRE_MEMORY_OPTIONS=”-mx256m”

1. Back up the oraparm.ini file in $ORACLE_HOME/oui

2. Modify the oraparam.ini file:

vi oraparam.ini

JRE_LOCATION=../../jdk/jre

3. Run the universal installer from $ORACLE_HOME/oui/bin/runInstaller

TXKRUN.PL Deploying a New Forms

applmgr@of201:~ $ $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log

Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl started @ Wed Sep 19 05:57:14 2018

*** Log File = /EBSDEV/inst/apps/EBSDEV_of201/logs/appl/rgf/TXK/txkCfgOC4JApp_Wed_Sep_19_05_57_14_2018.log

Enter Application name for re-deployment ? forms

Enter Oc4j Instance password for re-deployment ?

Run Autoconfig ? No

*****************************************************

Required values for starting OC4J instance “forms”:

====================================================

s_formsstatus = enabled

s_forms_nprocs = 1 (value should be greater than 0)

Existing values from the context file:

======================================

s_formsstatus = enabled

s_forms_nprocs = 1

———————————————-

*** Values for context variables are VALID ***

———————————————-

*****************************************************

Stopping all OPMN processes.

OPMN stopped.

OPMN started.

Deplolying Application : “forms” onto OC4J instance: “forms”

Application deployed successfully.

Stopping and starting OC4J instances.

Started OC4J instances.

Binding webApp : “forms” with webmodule : “formsweb” for OC4J instance: “forms”

Web application bound successfully.

Stopping OPMN.

OPMN stopped.

Program : /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl completed @ Wed Sep 19 05:57:54 2018

End of /EBSDEV/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl : No Errors encountered

applmgr@of201:~ $

AD Pacthes
Patch –  Desciption Pre

requisities

Post

requisities

Applied Patch –  Desciption Pre-Requisities

Not Appiled

Post

requisities

Not Appiled

28018146

12.1:CPU PATCH FOR JULY 2018

Yes NoRun ADGRANTS Yes 9239089

R12.AD.B.delta.3

NA NA
Yes 19559960

R12.FRM.B.delta.4

NA NA
No 23231676

R12.JTT.B.delta.4

NA 24840574

JSP COMPILATION FAILS AFTER APPLYING R12.JTT.B.DELTA.4

25110821

ERROR ON FLEXFIELDS AFTER APPLYING R12.JTT.B.DELTA.4

Yes 8919491

R12.ATG_PF.B.delta.3

NA NA
Yes 19273341

R12.BNE.B.delta.4

NA NA
No 22284589

R12.FWK.B.delta.5

NA 23200210

PERFORMANCE ISSUE WHILE SEARCHACCOUNT FLEXFIELD( SELECT FROM FND_FLEX_VALUES_VL)

12572001:

AFTER FRAMEWORK PATCH 11894708 JAVA ERROR ON CREATE CLAIM, CLAIM LINE, SYS PARAM (Not Required as we don’t have OZF)

Required

Actions

If Not On

Apr 2018 CPU

14108961

Only if Landed Cost Management is used

Check Below Applications are used or not with Funactional Teamand see if this are applied INL Inactive select

abbreviation

,codelevel

from

ad_trackable_entities

where

abbreviation in( ‘hr_pf’,’ibe’,’prc_pf’,’inl’,’ozf’ )

order by

abbreviation;

22465286

IF have applied Patch 21198991:R12.PRC_PF.B then apply Patch 22465286:R12.PON.B after applying this CPU patch.

PON Inactive select decode(nvl(a.APPLICATION_short_name,’Not Found’),

‘SQLAP’,’AP’,’SQLGL’,’GL’,’OFA’,’FA’,

‘Not Found’,’id ‘||to_char(fpi.application_id),

a.APPLICATION_short_name) apps,

decode(fpi.status,’I’,’Installed’,’S’,’Shared’,

‘N’,’Inactive’,fpi.status) status,

fpi.product_version,

nvl(fpi.patch_level,’– Not Available –‘) Patchset,

to_char(fpi.last_update_date,’dd-Mon-RRRR’) “Update Date”

from fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi

where fpi.application_id = a.application_id(+)

and fpi.oracle_id = o.oracle_id(+)

and APPLICATION_short_name in( ‘HR’,’IBE’,’PRC’,’INL’,’OZF’ )

order by 1,2

25510561

If have applied R12.HR_PF.B.delta.9, Release 12.1 HRMS RUP9, apply Patch 25510561:R12.PAY.B after applying this CPU patch.

Current Version is HR PF  DELTA 3

PAY Shared

26267391

If have applied R12.IBE.B.Delta.4, apply Patch 26267391:R12.IBE.B after applying this CPU patch.

IBE Inactive
DB Patches:
28317232

COMBO OF OJVM COMPONENT 12.1.0.2.180717 DB PSU + DBPSU 12.1.0.2.180717

12.1.0.2 NA REVIEW With CORE DBA TEAM
Java JRE
27890728

Oracle JRE 8 Update 181

Apply only 32 bit patch

No -Pre Req

10.1.3.5 Patches
21845960CPUOCT2015 TRACKING BUG FOR APPLICATION SERVER 10.1.3.5 UNIX 10.1.3.5.0 NA If you encounter conflicts with Patch 19943587 and Patch 18025250, allow OPatch to roll it back. The fix for 19943587 and 18025250 is already included in the Oct 2015 CPU Patch 21845960.mv: cannot stat `.backup/.10011970/cabo’: No such file or directory

mv: cannot stat `cabo’: No such file or directory

This message can safely be ignored.

We can apply 32 bit

version in Linux X86-64

run the below command before applying patch

$ export OPATCH_PLATFORM_ID=46

19943587/18025250

Not appliedApply 21845960. directly

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘22123753|20683632|20426272|19943587|18025250|21845960’
22123753CPUOCT2015: MLR ON TOP OF 10.1.3.5.0 FOR BUGS 20034700 8939568 20492610 10.1.3.5.0 NA If you have previously installed Patch 20683632 or Patch 20426272, use OPatch to explicitly roll it back. Then, apply Patch 22123753.why this patch ?

Slow performance of HTML-based (self-service) applications on Oracle E-Business Suite Release 12.1.

20683632/20426272

Not appliedApply 22123753 directly

Only if TLS 1.2 Configured

27078378|27208670

10.1.3.5.0 NA to enable TLS 1.2 you should update the OpenSSL libraries by applying two patches – Patch 27078378 and Patch 27208670 27078378|27208670

Not appplied

. $INST_TOP/ora/10.1.3/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘27078378|27208670’
10.1.2 Patches
26825525MERGE REQUEST ON TOP OF 10.1.2.3.2PSU FOR BUGS 25768948 1770039 25990479 10.1.2.3 NA Only Available for Linux X86, not with 64 bit

we have to check with Oracle for applying

Pre-Reqs are applied.

14825718 /8551790OUI 10.1 8551790

. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;$ORACLE_HOME/OPatch/opatch lsinventory|egrep ‘14825718|8551790|26825525’. $INST_TOP/ora/10.1.2/*.env;echo $ORACLE_HOME;grep -i version= $ORACLE_HOME/oui/oraparam.ini
 Known Issue Categories, Details and Resolutions
UI issues (such as poorly rendered fonts, missing links, or buttons and fields out of place) in Oracle E-Business Suite Release 12.1.3. Refer to Solution A in Document 1348791.1, R12: Font and Links Have Changed After Patching.
Patch Type Pacth# Comments References
10.1.3 21845960
10.1.3 22123753
10.1.2 26825525 Forms having some issues while opening

to fix the issue,Re-deploy forms.ear file

(Given in Readme,but steps are not correct,refer comments)

Deploying a New EAR File in Oracle Applications Release 12 (Doc ID 397174.1)   –Change Password for oc4jadmin

TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start (Doc ID 1295791.1) — Prod patch opmn ctl

JRE Plugin 27890728 After applying JRE Plugin,Forms are not opening ,no errors.

Reverted the changes,after that forms are opening

Upgrading JRE Plugin with Oracle Applications R12 (MetaLink Note 393931.1)

#notes