PeopleTools 8.54: Table/Index Partitioning

Partitioning in Oracle

Partitioning of table (and index) segments involves breaking them into several smaller segments where certain data values only occur in certain segments.  Thus if a query is looking for a certain data value it may be able to eliminate some partitions without having to scan them because by definition those values cannot occur in those partitions.  Thus saving logical and physical read, and improving performance.  This is called partition (more...)

PeopleTools 8.54: Global Temporary Tables

This is the third in a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

Database Feature Overview

Global Temporary tables were introduced in Oracle 8i.  They can be used where an application temporarily needs a working storage tables.  They are named
  • Global because the content is private
  • Temporary because the definition is permanent
Or if you prefer

PeopleTools 8.54: Materialized Views

This is the second in a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

Materialized Views in the Database

Snapshots were introduced in Oracle 7.  They were a way of building and maintaining a physical table to hold the results of a SQL query.  We are well used to a view being the results of a query, but here the (more...)

I’m Alex Lightstone and this is how I work

First up in the ‘How I work‘ series for 2015 is Alex Lightstone. For those in the UK PeopleSoft marketplace Alex should need no introduction, for everyone else though here’s a brief bio:

Alex spent the 2000’s at Oracle, initially supporting, and then as Product Support Manager for PeopleSoft Global Payroll. When he left Oracle in 2010 there was a battle for his services and we’re very grateful that he selected Cedar where he forms (more...)

PeopleTools 8.54: Descending Indexes are not supported

This is the first in a series of articles about new features and differences in PeopleTools 8.54 that will be of interest to the Oracle DBA.

"With PeopleTools 8.54, PeopleTools will no longer support descending indexes on the Oracle database platform" - PeopleTools 8.54 Release Notes

They have gone again!  Forgive the trip down memory lane, but I think it is worth reviewing their history.

PeopleTools 8.54 for the Oracle DBA

The UKOUG PeopleSoft Roadshow 2015 comes to London on 31st March 2015.  In a moment of enthusiasm, I offered to talk about PeopleTools 8.54 from the perspective of an Oracle DBA.

Since the presentation has been chosen, I am now doing some research.  I have picked out 7 topics that I want to talk about.  I will discuss how the feature has been implemented, and what I think are the (more...)

Anyone need remote help?

Does anyone know of any good contracts that would support mostly remote work?

I started this blog years ago with the idea that it would be a good place to search for work should I ever need it. I think the time has come to just ask to see if projects are available through this avenue. If you know of anything, I would love to speak with you. Would you mind commenting below or sending (more...)

Using RequireJS to Manage Dependencies

I have a handful of blog posts describing how to deal with JavaScript dependency conflicts such as multiple library inclusions, namespace conflicts, etc. These workarounds are necessary in portal environments that mash up content from various providers that may use the same libraries. On a portal (Interaction Hub) homepage, for example, you may have a Pagelet Wizard pagelet that uses the jQuery Cycle plugin as well as a Pagelet Wizard pagelet that uses jQuery UI. (more...)

Adding Watermarks to PeopleSoft fields

The Cedar tech team has recently discovered a great tweak to improve the end-user experience in PeopleSoft.

Many well designed websites use Watermark text to provide a visual hint to the user what they should put into a field. We felt that PS Self Service users would appreciate the enhancement.

screenshot

Head over to the Cedar Blog to find out more:

http://www.cedarconsulting.co.uk/news-details/February-2015-Adding-Watermarks-to-PeopleSoft-Fields/


Alliance 2015

I am looking forward to seeing everyone at the Alliance conference in Nashville next month. I was just reviewing my schedule and see lots of interesting technical sessions (as always). If you have room in your schedule, I invite you to attend my session on Tuesday, Mar 17, 2015 from 11:15 AM to 12:15 PM in Presidential D. The session is titled PeopleSoft PeopleTools Developer: Tips and Techniques. See you in a few weeks!

How to Open an Email Client with PeopleCode

When there's an email id displayed on a page, wouldn't it be cool for your users to be able click on it and have their email client (like Microsoft Outlook) open up a blank mail with the email id and subject line filled in? Here's how to do it in PeopleCode.

If You Want It, Here It Is

If you want it
Here it is, come and get it
Mmmm, make your mind up fast
If you want it
Anytime, I can give it
But you better hurry
Cause it may not last
    - From "Come And Get It", written by Sir Paul McCartney and originally recorded by Badfinger

I'm watching changes in the SaaS world...some people are keeping up with the changes, and some people are not.  The approach (more...)

The Year 2014 in Review

Once each year completes I try to do a run down of which posts have garnered the most attention during the last 12 months, both on this blog and on the PeopleSoft Weekly newsletter. Here are the most viewed stories from 2014.

PeopleSoft Weekly Newsletter

During 2014 the subscriber base grew from 602 to 914 (a net increase of just over 300), and this was despite being asked to remove over 50 subscribers when I left (more...)

Advantages of using REST-based Integrations in PeopleSoft

REST-based services support were introduced in PeopleTools 8.52, although you may also build your own REST services using IScripts in previous releases (*). With PeopleTools 8.52, Integration Broker includes support for REST services, enabling PeopleSoft to act as both a consumer and a provider.

What is REST?


There is plenty of documentation in the Web about REST, its characteristics and benefits. I personally find the tutorial published by Dr. Elkstein (http://rest. (more...)

ERROR – CLONE-20372 Server port validation failed

Alok and Shoaib pinged me about this error. This error is reported in logs when adcfgclone.pl is run for a R12.2.4 appsTier where the source and target instances are on same physical server.

SEVERE : Jan 27, 2015 3:40:09 PM - ERROR - CLONE-20372   Server port validation failed.
SEVERE : Jan 27, 2015 3:40:09 PM - CAUSE - CLONE-20372   Ports of following servers - oacore_server2(7256),forms_server2(7456),oafm_server2(7656),forms-c4ws_server2(7856),oaea_server1(6856) - are not available.
4:00 (more...)

EBS 12.2 Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 (Doc ID 1934471.1)

EBS 12.2 Essential Bundle Fixes for AD Delta 5 and TXK Delta 5 (Doc ID 1934471.1)

if any of the below features are interesting to your deployment then please review the doc and apply the essential bundle patches on 12.2.5 environment. Hope this helps to stabilize your environment.

Section 4: Features and Fixes in the Current Code level
The bundle fixes include implementation of the following AD and TXK features and fixes.

(more...)

Patch Now!

So two guys walk into a bar.  They're both talking like pirates and dressed like pirates.  The bartender asks...




No, wait, that's not the kind of patch we're talking about today.  Sorry, folks.  We're talking about a patch for your software...a fix or an update for software you already have in place.  Did you know Oracle puts out Critical Patch Updates ("CPU"s) for all their project on a regular basis?  You can read about (more...)

Enterprise Apps on SaaS

It's really, really early on a Monday morning as I write this:  "zero dark-thirty".  Some ideas just refuse to allow sleep until you share them.  So, while shivering in the pre-dawn cold, I offer the following for your consideration...

Picture if you will, just for a moment, the idea that your enterprise applications system is like an iceberg.  There are the system costs that you can see.  Then there are the costs below the water (more...)

ERROR: The following required ports are in use: 6801 : WLS OAEA Application Port

Anil pinged me today when his adop phase=fs_clone failed with this error message:

-----------------------------
ERROR: The following required ports are in use:
-----------------------------
6801 : WLS OAEA Application Port
Corrective Action: Free the listed ports and retry the adop operation.

Completed execution : ADOPValidations.java

====================================
Inside _validateETCHosts()...
====================================

This is a bug mentioned in the appendix of article: 

OAUG BI Publisher SIG

First off, if you are not familiar with the term SIG, it stands for Special Interest Group.  OAUG facilitates a number of SIGs to bring users together that share common or industries concerning certain Oracle products.

Unfortunately, the BI Publisher SIG has been offline for a number of years and has not been given the attention it needs to be a useful resource for members of OAUG.  Well… I’m getting the band back together and (more...)