Oracle Applications Upgrade to 12.1.2

Pre-requisites:

Applications should be of 12.1.1

For upgrading Oracle Applications from12.0.x to 12.1.1 please refer my blogpost

http://balajiabhi.blogspot.com/2009/07/upgrade-oracle-e-business-suite-1205-to.html

Web OH should be above 10.1.3.4

Step:1

Download AD_B_2 (8502056)

Download R121RUP2 (7303033)

Download Online Help patch (7303032)

Step:2

Apply 8502056:

Copy adgrants.sql from admin directory of the patch directory and copy to Database Oracle HOME/appsutil/admin

Source the Database environment file:

Run adgrants.sql as

Sqlplus /nolog

@adgrants.sql APPS

Source the Application Environment file

Apply the unified driver of 8502056 on the Application tier using adpatch

Be Sure that you have WEB_OH as 10.1.3.4 and above.

You can see that in WEB_OH (ORACLE_APPS_BASE/apps/tech_st/10.1.3/config/ias.properties) version.

Step 3:

Apply 7303033 using adpatch with default options.

• Be sure that you have enough space in APPS_TS_TX_DATA and APPS_TS_TX_IDX before starting the patch application.

After application of patch 7303033, it is advised to apply the online Help patch no. 7303032 using adpatch with default options

After application of these patches,

Please run autoconfig on the apps Tier and then make the appsutil.zip file from $AD_TOP/bin/perl

admkappsutil.pl

Copy the file to the $RDBMS_ORACLE_HOME and unzip the file.

Run autoconfig on the Database Tier.

It is mandatory to do a preclone on both the tiers which will enable to create a new clone directory structures during cloning.

Startup the instance.

Verify the upgrade using apps account in the backend

SQL> select release_name from FND_PRODUCT_GROUPS;

RELEASE_NAME

--------------------------------------------------

12.1.2

SQL>

Front end:

From the Forms:

Issues:

One object becomes invalid after application of the main patch.

OBJECT_NAME OWNER OBJECT_TYPE

------------------------------ ------------------- ----------------------------------

PA_PWP_SUMM_PKG APPS PACKAGE BODY

When you try to compile the object manually as apps, we got the following error:

SQL> alter package PA_PWP_SUMM_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show err

Errors for PACKAGE BODY PA_PWP_SUMM_PKG:

LINE/COL ERROR

-------- -----------------------------------------------------------------

342/1 PL/SQL: SQL Statement ignored

375/10 PL/SQL: ORA-00942: table or view does not exist

I raised SR against this error. Let me update any fix for this. Until now, the upgrade is uneventful.

Cheers!!!!