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.username,
       s.program,
       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...)

HIUG Interact 2019 Conference Schedule

Tomorrow I fly to Orlando for the 2019 HIUG Interact conference. I'm almost packed. I wanted to share my schedule with anyone attending. As usual, we start the conference off right with a session Sunday afternoon.

The Old Bugaboo

So after a bit of a hiatus, I've decided it's time to get off my butt and start writing again...

Today I'm raising an old bugaboo, but I'm adding a new perspective.  The bugaboo? Customizing packaged software.  It's more expensive than either building your own apps from scratch or buying software off the shelve.  But you all already know that because we've previously hashed that out at length here.

On to the new perspective.  As (more...)

PeopleTools Table Reference Generator

Like many other PeopleSoft professionals, I spend a lot of time looking at the PeopleTools tables because they contain meta-data about the PeopleSoft application. Much of the application is stored in PeopleTools tables. Some provide information about the Data Model. Many of my utility scripts reference the PeopleTools tables, some of them update them too. Therefore, it is very helpful to be able to understand what is in these tables. In PeopleSoft for the Oracle (more...)

PS360 enhancement: Added report of DDL models

I have written several blogs and presentations recently about how and how not to collect statistics in PeopleSoft.
  • If you are going to continue to use DBMS_STATS in the DDL model then
  • Do not specify ESTIMATE_PERCENT because it disables the hash-based number-of-distinct-values calculation, forcing it to go back to the COUNT(DISTINCT ...) method that requires a sort, and may not produce accurate values because it only samples data.
  • (more...)

PeopleSoft Adminstrator Podcast: #184 – nVision Performance

I recorded a second podcast with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast, this time about nVision.

(10 May 2019) #184 – nVision Performance

You can listen to the podcast on psadmin.io, or subscribe with your favourite podcast player, or in iTunes.

Launching into the middle of a Fluid Navigation Collection

One of the greatest challenges to a successful Fluid deployment is Classic navigation and one of the most common solutions to this challenge is the Tile Wizard-based Navigation Collection. Tile Wizard-based navigation collections allow us to build business process-based navigation for our back-office users (back-office pages are primarily Classic). Let's say you have built some amazing Navigation Collections for your back-office users and now you want to drill from one collection or page to a (more...)

PeopleSoft Administrator Podcast: #183 – Effective Performance Monitoring

I recently recorded a podcast with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast, this time about instrumentation, monitoring the performance of PeopleSoft system, and Performance Monitor.  There is also just a little about cursor sharing.

(3 May 2019) #183 – Effective Performance Monitoring

You can listen to the podcast on psadmin.io, or subscribe with your favourite podcast player, or in iTunes.

Bits And Pieces

Lots of innovative change afoot in the Oracle HCM Cloud space, so I thought I'd catch y'all up on the more significant bits and pieces.

  • Enhanced Talent Profiles:  Oracle Recruiting Cloud ("ORC") and Oracle Learning Cloud ("OLC")customers must upgrade to Enhanced Talent Profiles as part of their 19A uptake.  See My Oracle Support Doc ID 2421964.1 "Upgrading Fusion Profile Management" for more info. This is a really cool upgrade for the ORC and (more...)