What, Me Worry?

“What, me worry?” – Alfred E. Neuman

It seems like we have some nervousness settling into the U.S. economy.  The Dow Jones Industrial Average is down a few percentage points over the past few months.  Facebook, Apple and Google shares (three-fourths of the FANG indicator for the tech market) are all taking a bit of a beating.  We’re watching the process of Treasury Yields inverting, indicating concerns about the long-term debt market.  Folks (more...)

Security: The PeopleSoft Social Threat Vector

In the old Mission Impossible television series from the '60s and '70s, a team of expert agents socially engineer an incredible swindle to catch a bad guy, elicit a confession, release a hostage, etc. These deceptions often included room reconstructions, elaborate disguises, rerouted telephone calls, fake news broadcasts, etc. The con had to be so good the prey had no clue. If it weren't for the regular cut-aways to "reality," viewers wouldn't be able to (more...)

One stone – 2 birds

We are upgrading Oracle Apex behind our hr/payroll popay.net solution, and in the mean time we are looking into minimizing network bandwidth.  The last years we were rolling out many modules within popay.net, like learning, performance management, time management, etc. That focus left us on an older version of Apex. Now time to go to Apex 18.. Our solution uses a few Apex plugins. One is a

Listen To The Music – OOW 2018

Don't you feeling it growin', day by day
People gettin' ready for the new
Some are happy, some are sad
Oh, we got to let the music play
          - From The Doobie Brothers "Listen To The Music"


So it's Oracle OpenWorld time again.,, can you hear the music playing?  It really kicked off last Thursday, but the event really starts peaking today (Oct. 22nd) through Thursday.  Gazillions of people descending (more...)

Steal Percentage on the Virtual Machine

Recently have been working with a customer who was running high workload on virtual machine. After a complete review , DBAs have identified the database is running non optimized codes/sql/programs. During high peak load we observed very high Steal %

Image result for Steal Percentage Top

In a virtual environment, CPU cycles are shared across virtual machines on the server. If your virtual machine displays a high %st in top (steal time), this means CPU cycles are being taken away from (more...)

ADOPValidations EBS 12.2

ADOPValidations_detailed.log reported a warning message for one of the critical error "Cross Reference"

ValidateFSConfigFilesForCrossRef:
        [WARNING]: Found invalid cross references in FS config files.

cross reference is nothing but having incorrect values in the context file of EBS 12.2

for example : run file system context file having path of patch file system 


$ echo $CONTEXT_FILE
/prod/inst/fs1/inst/apps/PROD_node1/appl/admin/PROD_node1.xml

$ grep -i fs2 /prod/inst/fs1/inst/apps/PROD_node1/appl/admin/PROD_node1.xml
          (more...)

Golden Gate moving from Classic to Integrated

Golden Gate moving from Classic to Integrated was an option taken in one of our project to have better performance. A lot of effort was put to convert all the extract and replicate to Integrated mode and some optimization parameters were used but still there were not a significant performance improvement.

Then I took a different route to examine the AWR and ASH for the replicate processes. Wow our friend INDEXES. Since we were dealing (more...)

Canada Alliance 2018

Calling all Canadian Higher Education and Government customers! Canada Alliance is next month and boasts a great lineup of speakers and sessions. JSMPROS will host two pre-conference workshops Monday prior to the main conference. Please bring a laptop if you wish to participate. Please note: space is limited.

  • Configure, Don't Customize! PeopleSoft Page and Field Configurator Monday, November 12 from 10:00 AM–12:30 PM in Coast Hotel: Acadia Room
  • Advanced Query Monday, November 12 from 1:30 (more...)

Alliance Down Under 2018 Workshops

Today marks the 30 day countdown to Alliance Down Under, an incredible opportunity for Oracle customers to network, share experiences, and learn more about Oracle products. On Monday and Tuesday, November 5 - 6, I am partnering with Presence of IT to deliver several pre-conference workshops at Alliance Down Under. For more details and to register, please visit the Alliance Down Under pre-conference workshop page. Workshops available:

  • Building better-than-breadcrumbs navigation
  • Configure, Don’t Customize! Event Mapping (more...)

Live Three-day Fluid Training Event in Seattle Dec 4

Are you interested in learning PeopleTools Fluid? Have you already taken a Fluid training course, but still don't feel comfortable with Fluid? Please join us in beautiful downtown Seattle from December 4th through the 6th to learn all about PeopleTools Fluid. Our curriculum starts with Fluid navigation, works its way into Fluid page construction, and finishes with advanced topics such as site-specific CSS3, JavaScript, and event mapping. This course is packed with best practices and (more...)

Adding a Tablespace to a PUM

Somehow I misplaced or mistyped the SYS password on the last PUM install that I did. I learned a few things as a result…

Oracle is using Container Database technology. It made things a little challenging.

I should have been able to connect with:

sqlplus SYS@HR92U092 as sysdba

Inspecting the environment, it looks like the database name is CDHCM.

[oracle2@ps ~]$ ps -ef | grep pmon
oracle2   3691     1  0 Sep26 ?        00:00:40 ora_pmon_CDBHCM
oracle2  32310  (more...)

OpenWorld 2018

With just over a month until OpenWorld, it is time to finalize travel reservations and surf the content catalog. As always, the session catalog is loaded with great sessions from all of our favorite presenters: psadmin.io, Presence of IT, SpearMC, Cedar UK (Graham Smith), Oracle, Smart ERP and so on. I am definitely looking forward to hearing from customers and partners at the panel sessions on this year's agenda. If you have room on (more...)

How Not to Collect Optimizer Statistics in an Application Engine Program

I was told about a PeopleSoft customer experiencing an Oracle error when collecting statistics during an Application Engine.
ORA-06533: Subscript beyond count 
ORA-06512: at "SYS.DBMS_STATS", line 36873
It is possibly a manifestation of a database bug. The workaround was not to use AUTO_SAMPLE_SIZE, so instead, this customer initially coded an explicit call to DBMS_STATS.GATHER_TABLE_STATS with a specific sample size.
This blog is not about the bug, but how to manage the (more...)

Ya Gotta Water The Garden

With his love
And his carin'
He puts his life
Into beauty sharin'
And his children
Are his flowers
There to give us peace
In quiet hours

And I'll do anything I got to do
Cut my hair and shine my shoes
And keep on singin' the blues
If I can stay here in Johnny's garden

                         - From "Johnny's Garden" by Stephen Stills


(more...)

Yamaha’s PSR-E463 – A truly awesome Keyboard to have

Though I am a beginner in this instrument, still I would like to recommend others to go with this keyboard.

Yamaha's PSR-E463 makes a perfect first keyboard for students, a solid educational tool for classrooms, and a fun, lightweight travel instrument and composition tool for professionals. Each of the E463's 61 full-sized, organ-style keys provides good resistance with a quick response that's suited for playing dynamic string pads to quick brass lines and synth leads. (more...)

I’m Brad Carlson and this is how I work

This week we’re featuring another of the mainstays from the PSAdmin.io slack community  – Brad Carlson. He is a regular in the community and another member of the seemingly endless ‘PeopleSoft Minnesota Mafia’. Brad is a frequent guest on their PodCast talking about his IB Monitor tool and discussing the highly efficient application of CPU patches. I’m thrilled that he has added his profile to our ‘How I Work‘ series.

bridge

 

Name: (more...)

PeopleTools Client with Wine

One of the shortcommings to using Ubuntu Linux as my main OS is not being able to run Application Designer. Using Wine, I am now able to run it on my laptop. If you were to translate the Ubuntu specific commands over to Oracle Linux and install an XWindows desktop on the PUM, you could get App Designer running there, too.

Installing Wine

I installed Wine with these commands.

sudo apt-get install --install-recommends wine
sudo  (more...)

101 Ways to Process JSON with PeopleCode

... well... maybe not 101 ways, but there are several!

There is a lot of justified buzz around JSON. Many of us want to (or must) generate and parse JSON with PeopleSoft. Does PeopleSoft support JSON? Yes, actually. The Documents module can generate and parse JSON. Unfortunately, many of us find the Documents module's structure too restrictive. The following is a list of several alternatives available to PeopleSoft developers:

Managing Cost-Based Optimizer Statistics for PeopleSoft

I gave this presentation to UKOUG PeopleSoft Roadshow 2018

PeopleSoft presents some special challenges when it comes to collecting and maintaining the object statistics use the cost-based optimizer.

I have previously written and blogged on this subject.  This presentation focuses exclusively on the Oracle database and draws together the various concepts into a single consistent picture and makes clear recommendations for Oracle 12c that will help you work with the cost-based optimizer, rather than (more...)

Using PeopleCode to Read (and process) Binary Excel Files

At HIUG Interact last week, a member asked one of my favorite questions:

"Does anyone know how to read binary Microsoft Excel files from PeopleSoft?"

Nearly 15 years ago my AP manager asked me the same question, but phrased it a little differently:

"We receive invoices as Excel spreadsheets. Can you convert them into AP vouchers in PeopleSoft?"

Of course my answer was "YES!" How? Well... that was the challenge. I started (more...)