Infrastructure Technology Group – APPSINFODB

Finding solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s Data Integrity

  • Blog Stats

    • 39,804 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    March 2009
    M T W T F S S
    « Feb   Apr »
  • Archives

  • Authors

Applying Oracle Applications Technology (RUP5)

Posted by appsinfo on March 1, 2009

Steps to apply (RUP5)

 Pre-install Steps:


Step 1 Upgrade the RDBMS to Oracle9i Database or higher (Required)

Upgrade your RDBMS to Oracle9i Database before upgrading to (RUP5). Refer Upgrade document OracleMetaLink Note 362203.1

For Windows installations only: Download and apply patches 3095277 and 3380100. Follow instructions in each readme to upgrade the database first to and then to Patch 5.


Step 2 Apply the AD minipack. (Conditionally Required)

Ensure that the you have installed the latest version of AD before proceeding with this patch. At this time the latest version is AD minipack I.4.

·         4712852 – AD: Patch 11i.AD.I.4  or AD.I.6


Step 3 Apply additional prerequisites as needed. (Conditionally Required)

Depending on the baseline of your installation, patches in this section must be applied prior to proceeding with further with the RUP 5 installation steps.

Apply the following patches for all installations:

·         5989593 – AD: 11i: Remove “REVOKE ALL FROM PUBLIC” from ADGRANTS.SQL

·         3218526 – BNE: Patch 11i.BNE.D – Refer to About Web Applications Desktop Integrator Mini-pack 11i.BNE.D, OracleMetaLink Note 287080.1, for installation instructions.

·         4206794 – FRM: Patch 11i.FRM.H – Refer to About Oracle Report Manager Minipack 11i.FRM.H, OracleMetaLink Note 378338.1, for installation instructions.


Step 4 Run the Technology Stack Validation Utility. (Required)

In your operating system file system, navigate to the directory where you have unzipped these Applications Technology Updates.

  •  Establish the needed environment parameters by sourcing the Applications environment file  as the owner of the application tier file system.
  • Ensure “APPLRGF” variable is set in environment. If not, set it to the same value as “APPLTMP”.
  • From the location where this patch was unzipped, change directory to fnd/patch/115/bin.
  • Run the utility as follows:

%ADPERLPRG% -script=ValidateRollup  -outfile=%APPLTMP%\txkValidateRollup.html   -appspass=<apps database password>


Step 5 : Applying this patch (RUP5)

Oracle Applications Technology Updates for (RUP5) contains a unified patch driver to be applied with AutoPatch. Please apply the driver file on all application tier server nodes.

·         u5473858.drv


After you apply this patch…

Post-install Steps

Once you have successfully applied Oracle Applications Technology Updates for (RUP5), you must complete these additional steps. If you completed a task during a previous 11i patch application, then you do not need to complete the step again, unless otherwise instructed.

Step 1 Apply Post-Install Patches. (Required)

Apply the following patch (all releases):

·         3865683 – AD: Release 11.5.10 Products Name Patch

·         6145463 – Support Negative Currency Profile Value ‘(XXX)’


Step 2 Apply Release-Specific Post-Install Patches. (Conditionally Required)

Apply the relevant patches if your installation is on a listed release level.

4619025 – Invalid Package CS_WF_ACTIVITIES_PKG

5368595 – KM Pages Incorrectly Switch to Guest User Responsibility in iSupport Flow

5910548 – Patch for Bug 5879690 Failed – Core HRMS


Step 3 Apply SSO 10g Integration Patch. (Conditionally Required)

This step applies only to those E-Business Suite deployments that are integrated with Oracle Application Server 10g (Single Sign-On and Oracle Internet Directory). If the E-Business Suite deployment is not integrated with Oracle Application Server 10g, you can skip this step.

Do not apply this patch if you want to retain your existing Oracle Login Server 3.0.9 and Oracle Portal 3.0.9 integration. This patch includes libraries that are incompatible with Oracle Login Server 3.0.9.

For this step, apply the following patch:

·         5674941 – 11i.ATG_PF.H RUP5 SSO 10g Integration

This patch delivers an updated Single Sign-On SDK; you will need to de-register and re-register all your SSO partner applications. Please follow Option 3 under “Appendix C: Advanced Configuration – Manual SSO/OID Registration” in the Installation Guide, Metalink Note 233436.1, to de-register the partner applications first and then re-register them again.

If you are integrating the E-Business Suite deployment with Oracle Application Server 10g for the first time, refer to MetaLink Note 233436.1 for detailed instructions.


Step 4 Run Technology Stack script. (Conditionally Required)

If your environment is SSL-enabled, run the following script (for Technology Stack patch 4029076, included in (RUP5):

On Unix: -script=InstSSLFix

On Windows:

perl %FND_TOP%\bin\ -script=InstSSLFix


Step 5 : Upgrade Oracle XML Parser for Java v9.0.4 with Oracle Applications 11i. (Required)

Follow the instructions in OracleMetaLink note 271148.1 to configure and apply interoperability patches for Oracle XML Parser for Java v9.0.4.

Step 6 Run AutoConfig. (Required)

Run AutoConfig on the application and database tiers. For instructions on how to run AutoConfig, refer to OracleMetaLink note 165195.1.

Customers using the AutoConfig Customizations feature must merge any customizations with the AutoConfig templates provided via this patch before running AutoConfig.

Step 7 Create APPS_TS_TOOLS Tablespace. (Conditionally Required)

Customers who have migrated to the new Oracle Applications Tablespace Model must create the APPS_TS_TOOLS tablespace, either manually through SQL*Plus or by invoking the Tablespace Migration Utility menu, before running the AD Splicer to introduce a new product schema. For more information, see: Understanding the Tablespace Migration Utility Main Menu, Oracle Applications System Administrator’s Guide – Configuration.

The default initial size for the APPS_TS_TOOLS tablespace is 500 MB, with auto segment management enabled. If you create the APPS_TS_TOOLS tablespace through SQL*Plus, outside of the OATM utility, you can use the following statement:

datafile_name.dbf‘ SIZE 500M

You can override these storage recommendations with storage parameters to suit the expected size required for objects that will be in the Tools tablespace at your site.

Step 8 Disable Default Users. (Recommended)


Application User







AD (Application DBA)




AD (Application DBA)


AD (Application DBA)




Mobile Applications Admin


Field Service/Sales Application Admin


AD (Application DBA)


Sales Application guest user


Internet Expenses


iSupport Guest user – 1


iSupport Admin user


iSupport Guest user – 1


OP (Process Manufacturing) Admin User


Customer Care Admin for Oracle Provisioning


iRec Employee Guest Login


iRecruitment External Guest Login


Step 9 Copy Fonts for Oracle XML Publisher. (Required)

Copy the following font files from $FND_TOP/resource to the /lib/fonts directory (under OA_JRE_TOP and JRE_TOP) on all Web and concurrent nodes. If $FND_TOP/resource does not contain the font files, apply patch 3639533: Albany (Display) Font 4.02 Release.

The font files are:

ALBANYWT.ttf – “single-byte” characters only

ALBANWTJ.ttf – Unicode font with Japanese Han Ideographs

ALBANWTK.ttf – Unicode font with Korean Han Ideographs

ALBANWTS.ttf – Unicode font with Simplified Chinese Han Ideographs

ALBANWTT.ttf – Unicode font with Traditional Chinese Han Ideographs

Please refer to the OracleMetaLink document 240862.1, Install Oracle Unicode Fonts for Dynamic Image Generation in Oracle Applications, for more details.

Step 10 Update Configuration for Dedicated Notification Mailers. (Conditionally Required)

If you have defined any custom notification mailer service components that are dedicated to process only messages from a particular item type, then you must update the correlation ID value for those notification mailers to continue processing messages. You can set the correlation ID in the Define page of the advanced configuration wizard in Oracle Workflow Manager. For each notification mailer, set the correlation ID to the internal item type name followed by a colon and a percent sign in the following format:


For example:



One Response to “Applying Oracle Applications Technology (RUP5)”

  1. sql wildcard,sql wildcards,sql rollback,rollback sql,sql copy table,sql sum,sql mirroring,sum sql,sql cluster,sql server performance,truncate in sql,backup sql,backup sql database,backup sql server,sql performance,date functions in sql,sql over,trunc…

    […]Applying Oracle Applications Technology (RUP5) « Oracle DBA’s Group[…]…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: