Understanding PeopleTools Object Version Numbers

I was recently asked a question about PeopleSoft version numbers, but before I address that directly, I think it would be useful to explain what is their general purpose.


The PeopleSoft data model and application are mostly stored in the database in PeopleTools tables.  These tables are queried as the application executes.  For example, when you open a component, the component and pages, including all the PeopleCode, the definition of any records (more...)

EBS 12.2 APPL_TOP Only Clone – ERRORMSG: Invalid APPS database user credentials.

[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_testebsop3app01/appl/admin/SATURN_testebsop3app01.xml

Appl_top only clone might result in the below error

START: Instantiate the txkWfClone.sql...
instantiate file:
   source : /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/admin/template/txkWfClone.sql
   dest   : /u01/install/APPS/fs1/inst/apps/SATURN_testebsop3app01/admin/install/txkWfClone.sql
Adding execute permission to : /u01/install/APPS/fs1/inst/apps/SATURN_testebsop3app01/admin/install/txkWfClone.sql

END: Instantiated txkWfClone.sql...

START: Executing /u01/install/APPS/fs1/inst/apps/SATURN_testebsop3app01/admin/install/txkWfClone.sh -nopromptmsg
txkWfClone.sh exited with status 1
ERROR: txkWfClone.sh execution failed, exit code 1
[oracle@testebsop3app01 clone_10091511]$

if you scroll up the logs you (more...)

Changing Up On BYOT

So if you're tired of the same old story, 
Oh, turn some pages
I will be here when you are ready
To roll with the changes, yeah, yeah

                  - From REO Speedwagon's "Roll With The Changes"

It's a bit of a milestone for my employment with Oracle today.  For the past 7 or so years, I've been a "Bring Your Own Toolbox" (aka "BYOT") kind of (more...)

Not All Endpoints Registered

Not All Endpoints Registered

crsctl stat res -t

Cluster Resources
     1        ONLINE  INTERMEDIATE orcl1           Not All Endpoints Registered,STABLE
     1        ONLINE  ONLINE       orcl2           STABLE
     1        ONLINE  ONLINE       orcl3           STABLE

"Not All Endpoints (more...)

What Looks Good To Me: Oracle OpenWorld 2019

As I write this, we're a week away from Oracle OpenWorld 2019.  And, as always at OOW, there are a flood of sessions, events and gatherings that compete for your attention.  So I thought I'd share some thoughts on what looks good to me.  Keep in mind that my current focus is Oracle HCM Cloud Applications, so I'll be limiting my shared thoughts to that subject area.

Needless to say, the executive keynotes and the (more...)

OpenWorld 2019: I’m Speaking!

Are you ready for OpenWorld 2019? Have you built your schedule? If not, I suggest you get right on it! The best sessions are standing room only. If you don't build your schedule, then you have to wait outside each session until the last few minutes, whereas preregistered attendees walk right in, taking the best seats.

As you plan your PeopleSoft-focused trip to OpenWorld, I recommend starting with Rebekah Jackson's OpenWorld Preview video:

Next, visit (more...)

Changing the Search Page Operator Version 2

In 2011, just after PeopleTools 8.50 released, I wrote the post Changing the Search Page Operator. In that post, I demonstrated how to Monkey Patch PeopleSoft to do something you can't do with core PeopleTools: change the default advanced search page operator from Begins With to Between. A lot has changed since I wrote that initial post:

  • PeopleSoft switched from net.ContentLoader to net2.ContentLoader,
  • PeopleSoft released Branding System Options, which supports global JavaScript (more...)

Realizing potentials is mark of a great company

You should also take an extra look at the people who 'may not be ready,' and analyze them on the basis of their ambition, reputation, and passion for your business." An interesting read on what makes for inspring leader Hire Leaders for What They Can Do, Not What They Have Done

Oracle EBS 12.2.9 is Available….

Oracle E-Business Suite 12.2.9 is available now! Release 12.2.9 is a suite-wide patch that offers new features and enhancements, and provides regular updates. These improvements are geared towards further increasing efficiency, supporting modern business workflows, and providing a more intuitive user interface. Release 12.2.x customers can apply 12.2.9 directly to their environments. EBS 12.2.9 is […]

New Admin Pages

As you all know, I've been deep into the new mobile responsive Newsfeed UX for Oracle HCM Cloud since last year.  And, like most everything else in a continuous service delivery model, new features and functionality have been rolling out incremental with each new update.  And the latest update, 19C, continues that trend.

One of the big changes in 19C is the uplift of administrative pages (aka professional landing pages) to the Newsfeed UX look (more...)

Announcing Fluid 3!

At jsmpros, we teach Fluid training courses several times a month. PeopleTools Fluid is by far our most popular course. Through our Fluid 1 and 2 courses, we teach an incredible amount of material including:

  • Fluid navigation,
  • Fluid page development strategies,
  • Oracle-delivered style classes and layout
  • External CSS libraries,
  • Fluid grid layouts
  • Fluid Group Boxes
  • Dynamic Tiles
  • Responsive and adaptive mobile design concepts, etc.

The feedback from our Fluid 1 and 2 series is overwhelmingly (more...)

PeopleSoft UI Showcase

While commuting this morning I listened to Dan & Kyle’s podcast with Matthew Haavisto and they discussed that fact that the Fluid UI has been around for a while (since Tools 8.54, which was more than 5 years ago). It struck me that most clients will have adopted Fluid by now and branding is getting easier so there should be lots of good examples out there.

My mind drifted back to the company I (more...)

Oracle EBS 12.2 – ADOP ad_zd_prep.create_patch_service exact fetch returns more than requested number of rows

Oracle EBS 12.2 - ADOP ad_zd_prep.create_patch_service exact fetch returns more than requested number of rows

Please note , if you get ADOP issues on PROD please read the logs and understand the problem before executing any commands.

SQL> exec ad_zd_prep.create_patch_service;
BEGIN ad_zd_prep.create_patch_service; END;

ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.AD_ZD_PREP", line 342
ORA-06512: at "APPS.AD_ZD_PREP", line 378
ORA-06512: (more...)

Oracle EBS 12.2 – ADOP ad_zd_prep.create_patch_service exceptions

Oracle EBS 12.2 - ADOP ad_zd_prep.create_patch_service exceptions

Please note , if you get ADOP issues on PROD please read the logs and understand the problem before executing any commands.

There are cases where you might have to create a patch service manually. So usually after cloning or fresh install , add node , mass patching , upgrade this crazy error will pop up.

SQL> exec ad_zd_prep.create_patch_service;
BEGIN ad_zd_prep.create_patch_service; END;

ERROR (more...)

Oracle EBS 12.2 – ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running

ADOP patching on a downtime mode with [ERROR]     Patch service  is not exist or running

Please note , if you get ADOP issues on PROD please read the logs and understand the problem before executing any commands.

When applying adop patches on a downtime mode you might see an error that the patch service is not existing or running. Please note NOT all patches are meant to be applied to a downtime mode so (more...)

adop phase=cleanup fails with "library cache pin" waits

adop phase=cleanup fails with "library cache pin" waits

When running cleanup action in adop , it hung for ever.

Lets dig deeper to see the problem

SQL> SELECT s.sid,
       s.module from v$session s where module like '%AD_ZD%';

2313 APPS       perl@pwercd01vn074 (TNS V1-V3)                   AD_ZD                (more...)

The End Is Here

A little different from our usual fare here...

I'm a Mac user.  Switched from Windows to OS X several years ago and never looked back.  As time has passed, Apple has fallen behind on hardware design.  There's no question that the Microsoft Surface line surpasses the MacBook line in terms of hardware elegance and utility.  But I just can't bring myself to leave a rock solid operating system and run it back to Windows as (more...)

I’m Kyle Benson and this is how I work

I’ve not blogged on this site for a while so it takes a special post to break the hiatus. I’m delighted to finally be able to share the “How I Work” entry for Kyle Benson, one half of the all-conquering PSAdmin.io duo. Kyle and Dan are super-busy, splitting their time between PeopleSoft consulting and the PSAdmin.io slack community, their Podcast, their conference and their website.  I’m thrilled that he has (more...)

Adding a Fluid WorkCenter to a Navigation Collection

Oracle has done an outstanding job converting Classic Self-service to Fluid to promote the modern, mobile user experience. But what about back-office functionality? We certainly can't predict the future, but it seems that back-office transactions will remain Classic for a very long time. Rather than change the appearance of the back-office user experience, I believe our best strategy is to build back-office, business process-based navigation. Our users don't seem excited about the NavBar and Navigator (more...)

PeopleSoft ReConnect 2019

It is about two weeks until PeopleSoft ReConnect, and definitely time to build your schedule. I'm looking forward to a great conference with partners such as Appsian, psadmin.io, SpearMC, Presence of IT, Gideon Taylor, PS Web Solutions, New Resources Consulting, Oracle, and colleagues such as Sasank Vemana. There are so many great sessions available. I personally have several overlapping sessions on my agenda. In fact, I am (more...)