Showing posts with label 12.1.3. Show all posts
Showing posts with label 12.1.3. Show all posts

2012/03/18

Upgrade Oracle E-Business Suite R12.1.1 to R12.1.3 on Oracle Linux

 

Reference from Oracle Support DocId : 1080973.1

 

My EBS on my Oracle Linux is 12.1.1. I want to upgrade it to 12.1.3 to experience the new OAF Rich UI.

Here are my steps, the issues I encountered and the solutions.

 

Apply Patch 9239089

This one is easy.

Download the patch 9239089.

Unzip it.

Apply patch.

 

Apply Patch 9239090

This patch is big. It is seperated into 6 files, but still the same steps.

Download the patch 9239090.

Unzip them.

Apply the patch.

It spends a lot of time to apply this patch. And during applying the patch, there are several issues come to my server.

One is EGOSILDU.sql issue, which can be solved by DocId. 847687.1. But I don't use "Advanced Product Catalog" which I can ignore this issue by using adctrl and press 8.

And I also encountered another issue which is some form objects could not be compiled correctly.

au resource ASTACLIB.pll
au resource ASTCORE.pll
au resource ASTCUREL.pll
au resource ASTLSLIB.pll
au resource ASTCPREP.pll
au resource ASTOPLIB.pll
au resource IEXCORE.pll
au resource ASTRCALL.pll
au resource OKSSRVAV.pll
au resource ASTSLLIB.pll
au resource ASTCULIB.pll
au resource CSCUTILS.pll

And in this document

https://forums.oracle.com/forums/thread.jspa?threadID=2131259

Just recompile the db package AS_API_RECORDS_PKG and recompile the previous pll files to plx would solve this issue.

 

Apply Patch 9239095

This one is easy, too.

Download the patch 9239095

Unzip the patch

Apply the patch

 

Post-Updates Steps

Finally the patches of Oracle E-Business Suite R12.1.3 is done.I also need to apply patches 9817770 & 9966055, otherwise my responsibilities won't appear.

Update Code Level

To keep application tier and database tier the correct code level,  do the following steps:

Login as application os user, cd $ADMIN_SCRIPTS_HOME, run adautocfg.sh to generate the context file.

cd $AD_TOP/bin, run admkappsutil.pl.

This will generate latest appsutil.zip under $INST_TOP/admin/out

Then login as database os user, cd $ORACLE_HOME, ftp or copy the appsutil.zip (which is created by application os user) to current folder.

unzip -o  appsutil.zip

Run adautocfg.sh on $ORACLE_HOME.

then run adpreclone.pl dbTier using database user, and adpreclone.pl appsTier using application user.

Now everything is ready, you may startup your Oracle E-Business Suite 12.1.3 now!

 

image

image

2012/03/13

Oracle E-Business Suite R12 OAF Rich User Interface Enhancement

Reference from Oracle
There are some new enhancements since Oracle EBS R12.1.2 was introduced, especially the OAF Rich UI.
I think Oracle is getting better and better now. I'm going to upgrade my R12.1.1 on my Oracle Linux later on.
Now let's give it a glance.

I just captured the picture from the document. All the copyright of the picture belong to Oracle.

Now we have new navigator in the left
image
You can put some embedded content, see the right
image
You can have Drop-Down Navigator Menu. I love this function myself.
image
The Drop-Down Favorites. I love this one too.
image
This one is even better! The Inline, look-ahead LOV window.
image
The Inline View Attachment Window
image
Inline Popup Window
image
Embedded OBIEE Analytic Contents. Every boss asked about this!
image
Embedded Custom Rich Content
image
Function after R12.1.3
image
Exceptions as Popups.
image
AutoVue Integration.
image
View Object Creation.
image
Create your own Dynamic View Object
image
Copy & Undo funtion
image

Summary

I think Oracle is really trying hard to get Oracle E-Business Suite better and better. Though it's not fast enough, but I think I still love these new functions introduced.
Keep visiting my blog, I might have a chance to share my process of upgrade from R12.1.1 to R12.1.3.
See you soon.