VirtualBox Appliances for PeopleSoft on VMWare ESXi (bis)

Written in April last year, my procedure to move the Peoplesoft appliance to VMWare ESXi – see here – seems to be broken since image #6… My test was on image #3…
One of the reader found its own way and kindly shared experience, you can find here how to work around.

Right now we are on image #8, the first one ever on Peopletools 8.54. Time to have a shot.

1. I decided (more...)

CIFS performance problem

Today we encountered some performance problems at our customer site. After checking with the customer it seemed that especially the CIFS shares were having problems. At first CIFS was getting slower until the shares were not even accessible anymore. Restarting the CIFS on the filer did solve the problem for a few minutes, but within half an hour the the problems were back again.  Checking the /

My lucky find for ORA-01720: Grant Option Does Not Exist.

Strangest thing happened the other day during a customer upgrade.  Our automated scripts were in the process of creating a view and I received the error:

ORA-01720: Grant Option Does Not Exist.

OK…..  I get it…  BUT…. I didn’t even execute a GRANT statement!?  I was just executing a CREATE OR REPLACE VIEW…. what gives?

Doing some searching online, I didn’t find too much that fit my issue.  Everyone was getting (more...)

Peopletools 8.54 client silent installation

Digging around the last Oracle VM appliance HCM92008 (based on Peopletools 8.54.01), I just discovered a file with a nice name.
Check at /opt/oracle/psft/pt/tools/setup/Client/Disk1/resp_file_client.txt
Does this mean we can install Peopletools client in silent mode ? Well, probably not so easily in fact. According to the documentation, it’s still not supported : “Note. Only the command line options listed in this documentation are supported for PeopleSoft installation. Note that the use of (more...)

Nobody Bunts With Two Strikes

Once upon a time, I coached a young women's fast pitch softball team.  Big adventure, as most of my coaching experience is with baseball, and I really enjoyed it.  One game, the opposing team's catcher was hitting with two outs and two strikes.  I shouted out to my team to stop covering the bunt - nobody bunts with two strikes (because a foul ball off a bunt attempt is strike three).  So my team's infield (more...)

OpenWorld 2014

OpenWorld is only a couple of weeks away. As always, this promises to be an outstanding conference. Whether your focus is functional or technical, OpenWorld has a lot of PeopleSoft sessions. The Focus on PeopleSoft OpenWorld document contains a good list of PeopleSoft focused sessions and events. I look forward to seeing you at OpenWorld this year. Here are some of the places and times where you can find me:

Monday

Demo Grounds: PeopleSoft User (more...)

OpenWorld – Absorb and Adapt

It's September.  Which means the marketing and sales nirvana that is Oracle OpenWorld is upon us.

OOW is a big show...one person simply cannot take it all in.  You have to "pick your spots".

In the spirit of my previous blog post, my focus at OOW this year is on absorbing and adapting.  I'm up to my eyeballs in a new market with Higher Education, and I'm still learning about those customers.  So that's (more...)

Who is using this index?


Or, to put it another way, I want to change or drop this index, who and what will I impact?

The Challenge 

The problem that I am going to outline is certainly not exclusive to PeopleSoft, but I am going to illustrate it with examples from PeopleSoft. I often find tables with far more indexes than are good for them.
  • The Application Designer tool makes it very easy for developers to add indexes to (more...)

adopreports utility in R12.2

I discovered a utility in R12.2 when I was looking for the directory of adop :

which adop
$NE_BASE/EBSapps/appl/ad/bin/adop

cd $NE_BASE/EBSapps/appl/ad/bin/
$ ls
adop  adopreports

Curious I executed adopreports
$ adopreports

Enter the APPS username: apps
Enter the APPS Password:



    Online Patching Diagnostic Reports Main Menu
    --------------------------------------------

    1.  Run edition reports
    2.  Patch edition reports
    3.  Other generic reports
    4.  Exit

    Enter your (more...)

To Hint or not to hint (Application Engine), that is the question

Over the years Oracle has provided a number of plan stability technologies to control how SQL statements are executed.  At the risk of over simplification, Outlines (deprecated in 11g), Profiles, Baselines and Patches work by injecting a set of hints into a SQL statement at parse time.  There is quite a lot of advice from Oracle to use these technologies to fix errant execution plans rather than hint the application.  I think (more...)

Mobile Apps for Oracle E-Business Suite

First-rate announcement from Oracle through Steven Chan Blog for Mobile Apps strategy on Oracle eBusiness Suite.  With the rapid advent of social media and our behavior to see everything on smart phones. We as users of Oracle eBusiness suite started feeling old fashioned with the release of Oracle Fusion Applications where everything was coming for [...]

The post Mobile Apps for Oracle E-Business Suite appeared first on ORAERP.COM - Blogs.

Adapt – Learn New Things

Nothing lasts forever.  Sand-piles crumble.  Companies rise and fall.  Relationships change.  Markets come and go.  It’s just the nature of things.  Adapt or die.  Personally, I like this feature of life…can’t imagine anything worse than stagnation.  There’s nothing better to me than exploring and learning new things.

As Oracle continues their push into cloud-based enterprise applications, we’re seeing some of that fundamental change play out in the (more...)

Up and Running with HCM 9.2 on PT 8.54 via PUM "Demo Image"

Yes, you read that correctly. PUM is the new demo image. According to MOS Doc ID 1464619.1 "As of HCM 9.2.006, the PeopleSoft Image and PeopleSoft Demo Image have been combined into one PeopleSoft Update Image. You can use the PeopleSoft Update Image for both your patching and demonstration purposes." If you are current on your PUM images, you probably already knew that. If you are like me, however, and haven't (more...)

PeopleSoft HCM PUM Image with PeopleTools 8.54

I just noticed that the HCM PUM image is now available on PeopleSoft support.  You can download it for the HCM updates, but you can also take a peak at what PeopleTools 8.54 looks like.  Here’s the link:   PeopleSoft Update Image HCM 9.2.008

Resources

Share

Accessing Database Photos from Query Access Service

I have been working with the PeopleTools 8.54 REST Query Access Services. I would absolutely LOVE them if they returned JSON instead of XML. With a little help from x2js I am able to work around this "shortcoming." One specific challenge I faced was accessing image data. For example, with PeopleSoft query I can see who has photos in PS_EMPL_PHOTO, but I can't see the actual uploaded photo. With a little help (more...)

Oracle E-Business Suite 12.2.4 is Now Available!

Oracle E-Business Suite 12.2.4 Helps Organizations Further Optimize Business Processes, Reduce Costs, and Respond to Changing Market Conditions. This Release includes and focus on customer-driven enhancements across virtually all functional areas and new cloud integrations Also, this Release Update Pack (RUP) for the EBS 12.2 release codeline includes new features as well as statutory and [...]

Blame It On The Drugs

Bronchitis.  I catch it a lot.  Rotten experience.  It's like an invisible elephant is sitting on your chest.  And the drugs are mind-numbing.  Got it now.  Shivering under a blanket in 90 degree weather.  But, it'll pass.  And, in the meantime, if I write something weird...well, let's blame it on the drugs, OK?

Had a chat with a dear old friend this week.  Middle-manager for a Fortune 500 corporation.  Big Oracle customer.  Lots of (more...)

PeopleTools 8.54 Upgrade now Available

Today Matthew Haavisto of the PeopleTools strategy team announced that the PeopleTools 8.54 upgrade is now available. Visit the PeopleSoft Technology Blog to learn more.

PeopleTools 8.54.01 Exalogic OVM Template

I ran across this announcement on Oracle’s blogs about the new PeopleTools 8.54 OVM Template.  The problem is that I don’t have Oracle VM and don’t really want to delve into messing with it at the moment.  Virtualbox works better for my playing around.  It turns out that it wasn’t too hard to get this running in Virtualbox.

So, here are my notes…

To start, I downloaded the machine.  It came in 4 zip (more...)

Peoplesoft stops certification on Sybase and Informix

Due to a low number of customers using Sybase and Informix, Peoplesoft team recently decided to stop supporting their products on these databases, please see MOS note Oracle Modifies Supported Platforms for PeopleSoft (Doc ID 1915316.1)
According to the note, the Peoplesoft application 9.1 will be the terminal release for these databases. However, you’ll still be able to go for Peopletools 8.54, it will be the last supported.
Anyway, most likely better (more...)