Installation of patch 11i.ATG_PF.H.delta.7 [RUP7, patch#6241631]:

Installing patch 11i.ATG_PF.H.delta.7 [RUP7, patch#6241631]:

Pre-Requisite patches before applying this patch:

S. No.	Patch Number	Description	Status
1 2 3	7429271 3218526 4206794	AD: Patch 11i.AD.I.7 BNE: Patch 11i.BNE.D FRM: Patch 11i.FRM.H	Not Applied Applied Applied

Note: If you are already on AD.I.6, then no need to apply AD.I.7

If you have not applied patches 3218526, 4206734 then first apply these patches before applying AD.I.7.

In my case these patches were already applied.

Installing patch 7429271 - AD: Patch 11i.AD.I.7:

Pre-patch Steps:

• Verify version of Perl minimum it should be 5.005
• Check FNDLOAD executable is present in $FND_TOP/bin
• Enable maintenance mode

Apply this mini pack on both the nodes Including Arabic patch

Post-Patch Steps:

• Copy adgrants.sql script from patch_top/admin/ directory to RDBMS $ORACLE_HOME/appsutil/admin
• Run script as below:

bash-3.00$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 29 13:39:25 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> @adgrants.sql APPLSYS

Connected.

• Unzip apps.zip file under $JAVA_TOP (This step already completed as a part of Rup6 patch)

Running RUP7 pre patch validation script:

bash-3.00$ cd /appl/erp_patches/6241631/fnd/patch/115/bin

bash-3.00$ perl txkprepatchcheck.pl -script=ValidateRollup -outfile=/export/home/appltest/Apps_Scripts/txkValidateRollup1.html appspass=******

Enter Apps password ?

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

*** STDOUT = /appl/apps/prodnewcomn/rgf/PRODTEST_testappl/TXK/txkValidateRollup_Tue_Jun_29_13_50_28_2010_stdout.log

Reportfile /export/home/appltest/Apps_Scripts/txkValidateRollup.html generated with [FAIL]'s on some of the validation tests.

The script failed due to lower version of java on Server. Follow mentioned below steps in order to upgrade JDK 1.5 in Oracle Application 11i. After upgrading java patch pre-validation script completed with result as Success.

Upgrade java on Database and Application nodes:

• Copy “jdk-1_5_0_22-solaris-sparc.tar.Z” file on Servers
• Unzip and Install java as mentioned below:

bash-3.00# zcat jdk-1_5_0_22-solaris-sparc.tar.Z | tar -xf -

bash-3.00# pwd

/appl/erp_patches

bash-3.00# date

Tue Jun 29 14:33:09 AST 2010

bash-3.00#pkgadd -d . SUNWj5rt SUNWj5dev SUNWj5cfg SUNWj5man SUNWj5dmo

• After successful completion of java Installation on both nodes, verify the version of java.
• Install patch “4372996” on both the nodes, all pre-requisites patches are already exists on the Instance.
• Run java upgrade script on both nodes as mentioned below:

bash-3.00$ cd /appl/erp_patches/4372996/fnd/bin

bash-3.00$ txkrun.pl -script=SetJDKCfg -contextfile=$CONTEXT_FILE -runautoconfig=Yes -appspass=***** -jdktop=/usr/jdk/instances/jdk1.5.0/

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

*** Log File = /appl/apps/prodnewcomn/rgf/PRODTEST_testappl/TXK/txkSetJDKCfg_Tue_Jun_29_15_53_33_2010.log

Program : /appl/apps/prodnewappl/fnd/11.5.0/patch/115/bin/txkSetJDKCfg.pl started @ Tue Jun 29 15:53:34 2010

• Regenerate the appsborg2.zip File & Product JAR Files with adadmin utility.

Adadmin main menu -->Generate Applications Files menu --> Generate product JAR files

Select YES for force regeneration of all jar files.

• Verify whether jdbc drivers upgraded or not:

* 115.27 (for jdbc14.zip), 115.42 (for jdbc12.zip), or 115.47 (for jdbc111.zip) for JDBC Drivers version 9.2.0.8.

issue the commands from java_top:

bash-3.00$ unzip -z jdbc14.zip

Archive: jdbc14.zip

$Header: jdbc14.zip 115.27 2007/03/08 10:29 hhui ship $

bash-3.00$ unzip -z jdbc12.zip

Archive: jdbc12.zip

$Header: jdbc12.zip 115.42 2007/03/08 10:35 hhui ship $

bash-3.00$ unzip -z jdbc111.zip

Archive: jdbc111.zip

$Header: jdbc111.zip 115.47 2007/03/08 10:42 hhui ship $

bash-3.00$

• After Upgrading java Install patch using adpatch option udriver file for ATG_RUP7
• When Installation of RUP7 completed successfully, install all post and known issue patches.
  
• After successful Installation of family pack, Install post application patches as applicable:

S.No.	Patch Number	Description	Installation be on
1	5970422	ARU for Additional Data Page: LOV does not Populate Segment Values	11i.10 Cumulative Update 2 with Oracle HRMS Family Pack I, or later HRMS Family Packs
2	5910548	Patch for Bug 5879690 Failed - Core HRMS – This patch is not applicable as we are on lower family pack	11i.10 Cumulative Update 2 with Oracle Self-Service HR (product code PER) fully installed
3	4396821	Account Analysis and Drilldown Rollup Patch – GL	Any release using Oracle Report Manager
4	6741394	FSG Functionality for R11i Including XML – GL	-
5	6505416	Report Manager Drills Present Incorrect Ranges When Using Content Sets – GL	-
6	7418579	Column Heading Mismatch for FSG Report with XML Output – GL	-
7	8798855	The concurrent request submission screen hangs after RUP7 is applied or When attempting to click the refresh button after submitting a concurrent job the following error occurs: FRM-40815: Variable GLOBAL.JOBS_QF_FIND_CLKT does not exist
8	8761881	HR patches that run hrglobal.drv after RUP7 will not upload data via FNDLOAD
9	9053932	Viewing of Concurrent request output is disabled when profile "Concurrent: Report Access Level" is set to responsibility When Submitting a Request FNDRSRUN Pops Up with the 'Find Requests' dialogue
10	8908907	The initial Page Access Tracking page in OAM has performance issues
11	8990356	Some lookup types do not allow new lookup values or deletion of lookup values.
12	8991381	A hidden Flexfield segment is incorrectly set to a null value.
13	7828862	LAST_UPDATED_BY column in FND_USER has Incorrect Value
14	9158621	Unable to create an organization in Oracle Customers Online after RUP7
15	7477784	After applying ATG RUP 7 EDI invoices (INO) do not send Line info for some Invoices
16	9109247	Concurrent managers executing requests with expired users or responsibilities will loop consuming high amounts of CPU
17	9288021	SSO wrongly attempts to redirect users to a portal page after a session time out due to inactivity even though Portal is not integrated with eBusiness Suite. Note: this ONLY affects customers who have integrated eBusiness Suite with SSO
18	9304675	After applying RUP 7 the Internal Concurrent Manager (ICM) goes down when requests which have conflict domains are enabled. This issue is marked Highly Recommended
19	9442701	FRM-40831: Truncation occurred: value too long for field DESCRIPTIVE_FLEX_CONTEXT_CODE.
20	9187813	In the Inventory form INVIDITM when trying to change the name of a new or existing item the original name returns after saving This happens even when Profile option: INV: Updateable item name = YES is set
21	9747572	The organization context is not being set for the the database session in which the 'Workflow Background Process' is run. Or in some cases the org context is switched. This isssue affects Workflow accross multiple products and can manifest is many ways and is highly recommended
22	9003549	The purge concurrent requests program (FNDCPPUR) when run with the "count" option does not purge the correct number of requests.
23	8757781	java.lang.NullPointerExceptions result in increased java memory use and eventually OutOfMemory errors and JVM instability
24	8248307	RUP7 documentation patch

Always apply patches on TEST Instance before applying it on PRODUCTION.

Tech Notes:

1) About Oracle Applications Technology 11i.ATG_PF.H.delta.7 (RUP 7) [ID 783600.1]

2) Known Issues On Top of 11i.ATG_PF.H.delta.7 (RUP7) - 6241631 [ID 858801.1]

3) After ATG RUP7 Requests Scheduled 'On Specific Days' Jump Ahead by Extra Day in FNDRSRUN [ID 976781.1]

4) Login Error 'Internal Server Error' [ID 1097374.1]