Lots of information about the configuration and operation of a PeopleSoft system is stored in the database. Of course, most of the application itself is stored in the PeopleTools tables, for example, there are also performance metrics, particularly about batch processes.
PS360 is a new tool that I am working on that will use just SQL scripts to extract that data to flat files, and package them up in a zip file so that (more...)
I have blogged
recently about the effectiveness of the Tree Performance options in improving the performance of nVision reports.
However, a consequence of the Tree Performance Access Method suppress join; use literal values
is that the resulting SQL in nVision will have a criteria for every leaf on each of the selected nodes on that tree.
There will be an equality condition for each single value leaf. I normally set Selector Options to Ranges of (more...)
BI Publisher exposes four public Web services which can be used to perform a variety of activities including running a report.
The screenshot below is of a simple SOA composite which calls the runReport() method on the ReportService Web service to run a report with parameters. While Oracle’s official documentation is sufficient enough to make this a trivial exercise but there are still a couple of points to remember which is why this blog post is here in (more...)
I just wanted to post a quick note with my schedule for Collaborate 2016. I will be presenting PeopleSoft Developer Tips and Techniques on April 13th at 9:15 AM in Reef C. My publisher assured me that I will have a box of books waiting for me at the conference and we plan to give them away at various sessions during the conference. Here are a couple of other sessions I recommend attending at Collaborate:
I recently recorded an interview with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast
. It is going to be spread over three episode. There is lots of other good stuff on the website and other episodes that are well worth listening to.
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.
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?
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...)
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...)
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.
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 (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf (more...)
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!"
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...)