Oracle AppsUnlimited – Building your Own Machine on IaaS

To enable Oracle EBS on cloud and to install a fresh EBS Instance of your own choice then you will have to create a image. This image can be build using Oracle Linux (x86, 64-bit) releases 6.4 and 6.6 with kernel 2.6.36 or later.

High Level Steps

  • Source the ISO from E-Delivery
  • Using Oracle Virtual Box create the VM
  • Install Oracle Linux in the VM
  • Add/Enable Sudo to OPC user and (more...)

Oracle AppsUnlimited – Oracle E-Business Suite Meets Oracle Cloud

Oracle Cloud Infrastructure as a Service (IaaS) is now powered to run Oracle E-Business Suite. Does that interest you ? I am exited to be part of the apps unlimited team and let me share what I have explored. 

Apps Unlimited offers two ways  of running EBS , start fresh or migrate. Depending on customer choice and business requirement either of the options can be chosen. Some of benefits of running EBS on Cloud are quick (more...)

Presenting in Collaborate 2016

I am presenting in OAUG Collaborate 2016 about our experiences with running E-Business Suite on Engineered Systems - Exadata, Exalogic, ZFS and PCA.  Session Details:

Please attend, if you are coming to OAUG Collaborate.

PeopleSoft on the Oracle Cloud – what does it mean?

There have been a few announcements over the last couple of weeks about the Oracle Public Cloud. But what does it actually mean for the PeopleSoft community?

What is Oracle Public Cloud?PeopleSoft in the Oracle Cloud

The Oracle Public Cloud is Oracle’s competitor to the Infrastructure as a Service (IaaS) providers that have swiftly risen to create a whole industry that didn’t exist 10 years ago. Because they’re the market leader (by far) everyone automatically thinks of Amazon, however (more...)

I’m Sasank Vemana and this is how I work

The next profile in our ‘How I Work‘ series is Sasank Vemana. Sasank burst onto the PeopleSoft blogging scene in 2014 with his Sasank’s PeopleSoft Log site, and has been adding entries at a ferocious pace since. He is probably best known for his series of posts on altering the PeopleSoft branding to make it match a corporate palette, as well as configuration and code changes related to UI/UX.

I met Sasank at (more...)

Using Generic Templates to Send Emails

Weblogic and Oracle HTTP Server install with /tmp

Lately I have had to install Weblogic 12.1 and OHS 12.1 on a Linux server in silent mode.
Somehow, there was very small space left on the default temporary filesystem /tmp.
I was having to find a way to install within the non-default /tmp.

Not so simple to find the option in the command line, that's why this article as a note for myself, maybe it also can help others.

Weblogic 12.1. (more...)

nVision Performance Tuning: General Principles

Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses.  Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers.  I have collected that advice in to a document that I have recently published on my website ( Tuning.Generic.pdf (more...)

Alliance 2016

HEUG Alliance is next week. I hope you are registered. I know this will be a fun and informative conference (as always). I am scheduled for two sessions at Alliance:

  • PeopleSoft Developer: Tips and Techniques on Monday at 3:30 PM in room 6B/C and
  • PeopleSoft Meet the Experts on Tuesday at 10:15 AM in room 307/308 table 2.

When I'm not in sessions, you will find me in the demo grounds. Stop by and say "Hello!"

Knowing Your Cloud From Your SaaS

I have recently spent far too much time in far too many conversations in which the terms "cloud" and "SaaS" are used interchangeably.  Let's be clear:  the two terms are not interchangeable as they describe very different concepts.

Cloud.  There are many definitions out there.  Marketers and sales people.  Engineers.  Industry analysts. The National Institute of Standard and Technology.  Frankly, most of those definitions are either wrong, or they're technically accurate while thoroughly useless. (more...)

What Is This COE Thing?

Since joining Oracle, I've heard this same question repeatedly:  "This Oracle HCM Cloud Center Of Excellence team you've joined...what do they do?"  So I thought I'd attempt to answer that question here in the hopes that people may get some benefit from it.

Be aware that you can search the web and find many definitions regarding a Center of Excellence is and what it does.  Forget that stuff, most of it does not (more...)

Oracle Application Builder Cloud Service(ABCS)

Oracle Application Builder Cloud Service(ABCS) is generally available now.

ABCS is an all-in-one box: software development and database in one service.
Oracle ABCS provides a platform to not only create mobile and web applications in the cloud, but also deploy and host them in a cloud environment.

Development happens in a web browser on a intuitive way by drag&drop objects in a visual environment.

Have a BI Publisher Story to Tell?

The BI Publisher SIG is gearing up for Collaborate 2016 in April and is looking for volunteers to share their experiences, tricks, tips, challenges, etc… with fellow users during our meeting in Las Vegas on Monday April 11th.  Do you have a story to tell?  Want to showcase a challenge?  Want to brag about an accomplishment?   We would love to have YOU, the actual user spend 10-15 minutes sharing your experiences/stories with (more...)

Implementing Index Compression (and other Physical Storage Options) via Application Designer

There are some performance improvements that require physical storage options to be set on tables or indexes.
One particular technique that I will take as an example for this article is index compression.  A good example in PeopleSoft is the tree node table, PSTREENODE.  It drives many security and hierarchical queries.  It is not updated very frequently, only as new trees are brought on.  Many of the indexes are good candidates for compression.  Oracle can (more...)


A long time I was not really active on eBS, a long time I was not blogging anymore. I just want to document my R12.2 adventures. One was that the fast formula text is now stored in a clob column, gone is the long column. Finally. Our Documentool for Payroll supports this little change already for a while. Value set security. I was not able anymore to enter values for a value set. Reading

Default parameter values in package subprograms

For a procedure (or function) in a package, you can assign default values only in the package specifications without assigning them in the package body:

PROCEDURE set_global (p_num IN NUMBER DEFAULT 1);

Package TEST_DEFAULT_PKG compiled

No errors.
PROCEDURE set_global (p_num IN NUMBER) AS

Package body TEST_DEFAULT_PKG compiled


Pareto Rocks!

I'm a big fan of Vifredo Pareto's work.  He observed the world around him and developed some very simple concepts to explain what he observed.  Pareto was ahead of his time.

Some of Dr. Pareto's work is based on the Pareto Principle:  the idea that 80% of effects come from 20% of causes.  In the real world, we continually see examples of the Pareto Principle.

I've been conducting one of my informal surveys (more...)

Looking back at the Oracle Forms 12c event organized by Contribute(28/01/2016)

The title of the Contribute event/seminar was "Oracle Forms 12c: Built to last".
Indeed, Forms is built to last.  It has been around for over 20 years and it's added to Oracle Fusion Middleware 12c, which is supported until 2023.

Oracle Forms is still running at a lot of Belgian companies looking at the turnout.


Topics were:

What PeopleSoft content was popular in 2015?

The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.

PeopleSoft Tipster Blog

So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.

Amazingly, the (more...)

I’m Dan Iverson and this is how I work

Next up in our ‘How I Work‘ series is Dan Iverson. Dan – together with partner-in-crime Kyle – runs the blog. If you’re a PeopleSoft administrator and connected to the Internet then there’s no doubt that you’ll have heard of their blog as they’re really prolific and have posted some great content. Clearly blogging wasn’t enough however, and there is now the PeopleSoft Administrator PodCast which is ~45 minutes of topical awesomeness. I (more...)