How I upgrade our Oracle EBS from R12.1.1 to 12.1.3

SkySys - Oracle Applications EBS 12.1.3 Login page

Objective:

To describe the procedure I have followed in upgrading our Oracle EBS Release 12.1.1 to 12.1.3. While the procedure mentioned in this blog are the exact steps I have followed (including the commands issued) the best document to read about the upgrade is Oracle support note 1080973.1.

Our Oracle Server current configuration:-

a. Hardware and host environment:-

> Base server:  Windows 7 Professional 64-bit, CPU = Intel Core i7-2600 @3.40GHz, RAM = 16.0 GB

> VMware platform on top of Windows 7:- VMware Server 2.0.2

> Virtual machine specifications:-

  Operating system type = Red Hat Enterprise Linux 4 (32-bit)

  HDD space allocated = 400GB

  RAM allocated = 8.0 GB

b. Oracle EBS server (current) – Vision instance

 hostname = ls1.skysys.com.au  (alias “ls1”)

 Installation home = /home/oracle/VIS

 Oracle Database version = 11.1.0.7

  Applications Release name/version = 12.1.1

Upgrade procedure followed:-

1. I have downloaded following patches and extracted into /home/oracle/R12-Patches directory.

9239089
9239090
9817770
9966055
9239095

2. Stopped all application tier services.

$ /home/oracle/VIS/inst/apps/VIS_ls1/admin/scripts/adstpall.sh apps/******

I kept the Oracle Enterprise Manage DB console service running as it helped me monitor the database performance, tablespaces health, etc.

3. Switched the instance into maintenance mode.

$cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=ENABLE_MAINT_MODE workers=4

4. Run adgrants.sql as a pre-requisite for the first patch 9239089

– “adgrants.sql” is a file extracted out of 9239089 patch. Copied this sql script into $ORACLE_HOME/appsutil/admin directory.

$ cd /home/oracle/VIS/db/tech_st/11.1.0/appsutil/admin

$ sqlplus /nolog

SQL> @adgrants.sql apps

—- adgrants.sql executed and database changes committed.

SQL> exit

5. Applied the first patch 9239089.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239089.log patchtop=/home/oracle/VIS/R12-Patches/9239089 driver=u9239089.drv workers=8

6. Applied the second patch 9239090.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239090.log patchtop=/home/oracle/VIS/R12-Patches/9239090 driver=u9239090.drv workers=8

The 9239090 patch ran for nearly 12 hours. There was an incident when one of the workers has failed and I have to skip the job (worker) by using “adctl” utility.

7. Applied the next patch 9239095.

$ /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9239095.log patchtop=/home/oracle/VIS/R12-Patches/9239095 driver=u9239095.drv workers=8

Now moved on to the post update steps:-

8. Applied the mandatory post-install patch 981770.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9817770.log patchtop=/home/oracle/VIS/R12-Patches/9817770 driver=u9817770.drv workers=8

9. Applied the second mandatory post-install patch 9966055.

$ cd /home/oracle/VIS/apps/apps_st/appl/ad/12.0.0/bin

$ . APPSVIS_ls1.env

$ adpatch defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=u9966055.log patchtop=/home/oracle/VIS/R12-Patches/9966055 driver=u9966055.drv workers=8

10. Updated the DB tier with the EBS 12.1.3 code level

$ cd $APPL_TOP

$ . APPSVIS_ls1.env

> Executed the admkappsutil.pl utility to create the appsutil.zip

$ cd $AD_TOP/bin

$ admkappsutil.pl

> As the outcome of the above script the appsutil.zip got created into the $INST_TOP/admin/out directory.

> Copied appsutil.zip (created in previous step) to $ORACLE_HOME

$ cp $INST_TOP/admin/out/appsutil.zip $ORACLE_HOME

> Unzipped the appsutil.zip at $ORACLE_HOME

$ cd $ORACLE_HOME

$ unzip -o appsutil.zip

> Executed the autoconfig utilities on Database tier:

$ perl $ORCLE_HOME/appsutil/bin/adbldxml.pl

$ cd $ORACLE_HOME/appsutil/bin

$ sh adconfig.sh

11. Executed the adpreclone.pl on database tier and then on the applications tier.

$ cd $ORACLE_HOME

$ . VIS_ls1.env        — sourced database environment

$perl appsutil/bin/adpreclone.pl dbTier

$ cd $APPL_TOP/appl/scripts

$ . /VIS_ls1.env        — sourced application environment

$ perl $INST_TOP/appl/appsutil/bin/adpreclone.pl dbTier

12. Got the environment back to normal from maintenance mode.

$adadmin defaultsfile=$APPL_TOP/admin/$TWO_TASK/adalldefaults.txt logfile=adadmin.log menu_option=DISABLE_MODE workers=4

13. Inquired the Oracle EBS code level to see the upgrade is all well.

$ cd $ORALE_HOME

$ . VIS_ls1.env

$ sqlplus apps/*****

SQL> select release_name from fnd_product_groups;

RELEASE_NAME

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

12.1.3

13. Restarted the application services.

$ cd $ADMIN_SCRIPTS_HOME

$ sh adstrtal.sh apps/*****

We have got our Oracle EBS 12.1.3 ready to play (learn I mean).

Thank you for visiting our blog. Have a great day.

Asset and it’s relationships within eAM

Asset as in “Asset Number” in Oracle eAM module represents an individual object. It could be an equipment, a part of equipment, a group of equipments that collectively performs a function, a facility or just an area. Any thing that gets maintained (predominantly physical maintenance) by a business organisation can be treated as an asset in Oracle eAM, defined as an Asset number.

an eAM Asset number must belong to an eAM Asset Group. For better clarity on the data model of the eAM Asset Group, please read my blog where I have explained the eAM Assets inter-relationships with other modules.

Objective:-

In this blog I want to explain how an individual Asset (eAM Asset Number) relates to the key data objects within Oracle Enterprise Asset Management (eAM) module.

Please take a look at following diagram that illustrates the direct and indirect links between eAM Asset Number with other objects:

Asset relationships within eAM

• eAM Attributes are set against an eAM Asset Number. These attributes are combined into groups.
• eAM Activities are assigned to an eAM Asset Number. Each activity has individual Routing and Bill of material definitions.
• eAM Meters are assigned to an eAM Asset Number. Each meter reading details are updated against the Asset.
• eAM PM Schedules are assigned right down to an eAM Asset Number. Same goes with PM Suppressions.
• Bill of material are defined at eAM Asset Group level only. ie, all eAM Assets belonging to that eAM Asset Group share that bill. The effectivity of a particular bill component is be limited to one or range of eAM Asset Numbers by using ‘Serial Effectivity’ control functionality within bill of material definition.
• Routings are defined at eAM Asset Group level only. ie, all eAM Assets belonging to that eAM Asset Group share that routing.
• Quality Plans are assigned at eAM Asset Group level. This can be done right at the eAM Asset level as well.
• Documents (or links) can be attached to an eAM Asset Number. These attachments will get defaulted on to the eAM work orders created for that asset.

Thank you for visiting this blog. Have a great day.

…Jag

Asset Group and it’s relationships within eAM

The word “Asset Group” trips out many people and remains a clearly un-answered question for range of Oracle users including technical consultants and business end users. explaining the Asset Group to different user groups is challenge, particularly when it comes to linear assets.

For better clarity on the data model of the eAM Asset Group, please read my blog where I have explained the eAM Assets inter-relationships with other modules.

Objective:-

In this blog I want to explain how an Asset Group relates to the key data objects within Oracle Enterprise Asset Management (eAM) module. These relationships are very important to consider while deciding on eAM Asset Groups for an organisation.

Details:-

Please take a look at following diagram that illustrates the direct and indirect links between eAM Asset Groups with other objects:

Asset Group relationships within eAM

•  eAM Attribute Groups are assigned to a particular eAM Asset Group. ie, all eAM Assets belonging to that eAM Asset Group inherit the assigned attribute groups.
• eAM Activities are assigned to a particular eAM Asset Group. ie, all eAM Assets belonging to that eAM Asset Group inherit the assigned activities.
• eAM Meter Templates are assigned to a particular eAM Asset Group. ie, all eAM Assets belonging to that eAM Asset Group inherit the meters that are part of the assigned meter templates.
• eAM PM Schedule Templates are assigned to a particular eAM Asset Group. ie, all eAM Assets belonging to that eAM Asset Group inherit the PM schedules that are part of the assigned PM Schedule Templates. Same goes with PM Suppression templates.
• Bill of material are defined at eAM Asset Group level only. ie, all eAM Assets belonging to that eAM Asset Group share that bill. Although the effectivity of a particular bill component can be limited to one or range of eAM Asset Numbers the process of maintaining that effectivity control can get quite cumbersome.
• Routings are defined at eAM Asset Group level only. ie, all eAM Assets belonging to that eAM Asset Group share that routing.
• Quality Plans are assigned at eAM Asset Group level. This can be done right at the eAM Asset level as well, but the data management can get complicated and over burden.
• eAM Failure Sets are assigned to a particular eAM Asset Group. ie, all eAM Assets belonging to that eAM Asset Group inherit the failure sets, there by the failure codes, causes, etc.
• Documents (or links) can be attached to the eAM Asset Group that can be shared across the related eAM Assets. although this is not a major advantage it just helps to simplify the management of attachments.

Final note:-

When it comes to deciding on the asset groups, although the Oracle eAM documentation states the Asset Group is simple as the combination of Make and Model of the assets, in reality it’s a tough decision to make. The Oracle EBS shouldn’t be overloaded with too many unneccessary asset groups, same time the seeded functionalities of eAM can be comprehensively used. The consultants and business process owners needs to work closely to get the balance right.

Thank you for visiting this blog. Have a great day.

…Jag