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.

2012/02/05

VMWare Memory Setting

Just want to keep this for I sufferred from the physical memory not enough error for one day.

In Additional memory part the 3rd option : Allow most virtual machine memory to be swapped.

image

It was the 2nd option : Allow some virtual machine memory to be swapped. And notice that the Reserved memory is 4545 MB.

I got available memory  more than 4GB, VMWare still complaint I do not have enough memory for my 4G VM.

Though this option(3rd option) sacrificed the performance of the guest machine. At least I can have a slow but workable environment.

Valentine's Day 2012 V

Database parameter setting (Reference)



alter system set processes=300 scope=spfile;
alter system set session_cached_cursors=200 scope=spfile;
alter system set sga_target=2G scope=spfile;
alter system set shared_pool_size=600M scope=spfile;
alter system set pga_aggregate_target=1G scope=spfile;
alter system set job_queue_processes=20 scope=spfile;

2012/02/04

SOA Suite Installation on Oracle Linux 5.7

Valentine's Day 2012 V
According to Oracle official web page currently the SOA Suite can be installed only on 32-bit JVM.
In this article, we will install WebLogic, RCU, SOA Suite and JDeveloper.

OS Package Installation

compat-db-4.1.25-9
sysstat-5.0.5-1

Kernel Parameters OS Resource Limitation

/etc/security/limits.conf
*    hard    nofile    4096
*    soft     nofile    4096
image

Install WebLogic

In the Welcome windows, Next
image
Select Create a new Middleware Home, and give the Middleware Home Directory, then Next
image
opt out I wish to receive security updates via My Oracle Support, then Next
image
Choose Typical as Install type, this will install WebLogic Server & Oracle Coherence, then Next
image
Specify the directory of WebLogic Server and Oracle Coherence, then Next
image
Review the Installation Summary, if no problem, then Next
image
Installing
image
opt out the Run Quickstart then Done
image

Install RCU DB Schemas

In Welcome window, Next
image
Choose Create, then Next
image
Give the database connection information, then Next
image
After the check, then OK
image
Accept the default new Prefix DEV, opt-in the SOA and BPM Infrastructure, this will automatically opt-in Metadata Services under AS Common Schemas, then Next
image
After the check again, then OK
image
Give the password for all schemas, then Next
image
Review the Tablespaces, then Next
image
Because we do not have any tablespaces in previous review, so OK
image
Tablespaces created, then OK
image
Review the Summary, then Create
image
Repository created, then Close
image

Install SOA Suite

Give the JDK location under previous WebLogic Middleware Home
image
Accepted the default. You should have a group named oinstall already. Then OK
image
Need root privileges to run the createCentralInventory.sh
image
Logon as root and go to the directory previous dialog specified run the createCentralInventory.sh
image
Go back to the previous dialog, then OK
image
In Welcome screen, Next
image
Choose Skip Software Updates, then Next
image
Make sure the Prerequisite Checks are all passed, then Next
image
Specify the Oracle Middleware Home and accept the default name for Oracle Home Directory (this will be our DOMAIN_HOME), then Next
image
Accept the WebLogic Server as Application Server, then Next
image
Review the Installation Summary, then Install
image
Installing
image
Completed, then Next
image
Installation Complete, Finish
image

Configure SOA Suite

Under $DOMAIN_HOME/common/bin
./config.sh
image
Choose Create a new WebLogic domain, then Next
image
Check the following products, then Next
image
Give the Domain name, Domain location, and Application location, then Next
image
Give weblogic password, then Next
image
Choose Development Mode and Sun SDK, then Next
image
Check all the Component Schema, give the password (Created in RCU), and connection information, then Next
image
All the Component Schema tested, then Next
image
Check only Administration Server, then Next
image
Use default value for Administration Server, then Next
image
Review Configuration Summary then Create
image
Creating New Domain
image
Done
image

Install JDeveloper

In the Welcome window, Next
image
Choose Create a new Middleware Home, and give a new directory for JDeveloper, then Next
image
Choose Complete as Install Type, then Next
image
Confirm the directories are all right, then Next
image
Review the Installation Summary, then Next
image
JDeveloper installing...
image
uncheck the Run Quickstart, then Done
image

Install SOA Extension on JDeveloper

Choose Default Role when you first time run the JDeveloper, then OK
image
Depends on you want to report your usuage to Oracle or not, then OK
image
In menu Help > Check for Updates
image
In Welcome window, Next
image
Check Oracle Fusion Middleware Products and Official Oracle Extensions and Updates, then Next
image
Check Oracle BPM Studio 11g and Oracle SOA Composite Editor, then Next
image
The update is downloading...
image
Extension installed, Finish
image
Yes and restart the JDeveloper
image

Appendix

cd $DOMAIN_HOME/bin
./startWebLogic.sh to start the SOA Platform
We will see the SOA Platform is running and accepting requests to know the server is ready.
image
Browse yoursoaserverip:7001/console
image
Logon as weblogic and password you specified previously, then Login
image
We will see the server is ready, Yay!
image

Reference Oracle SOA Suite 11g Installations Document