Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Saturday, 17 July 2010

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]

No comments: