Happy New Year 2020

Uncategorized
| Dec 31, 2019

I See Systems

Uncategorized
| Dec 23, 2019
Working in enterprise software has changed my perspective on the world around me... I see everything through more of a systemic lens.

My wife recently had knee replacement surgery.  World-renown surgeon performing the surgery.  But being done at his 2nd choice of hospitals due to limitations of our health insurance policy.  Good hospital, but not his hospital of choice.  Like everything else involving health care in the U.S., it's a money thing.

The (more...)

ASC 842 :Audit Procedures for Leases

Uncategorized
| Dec 20, 2019
The new Financial Accounting Standards Board (FASB) and international financial reporting standards (IFRS) lease accounting standards (ASC 842 and IFRS 16) will take effect in 2020 for private companies. The standards bring many leases onto the balance sheet and could significantly impact a business’ financial statements. Here is great post on Audit Procedures for Leases […]

Design Thinking in IT Development life cycle

Uncategorized
| Dec 12, 2019
Here is question from a reader Does integrate design thinking help into day to day operations of IT and Service Management ? Is there any frameworks or matured models of Design thinking embedded into development cycle? Design thinking at its very core is about understanding your customer’s needs better than they can ever articulate it […]

Teri Meri Prem Kahani Cover | Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Dec 9, 2019

My Son Dharun Performing at Improviser Music Studio

Teri Meri Prem Kahani Cover

DarkSide Cover | Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Dec 9, 2019
My Son Dharun Performing at Improviser Music Studio

DarkSide Cover

Practical Application Performance Tuning: An nVision Case Study

Uncategorized
| Dec 2, 2019
I gave this presentation at the UKOUG Techfest 19 conference.  It is closely based on a previous presentation about PeopleSoft nVision performance tuning, and uses the experience of a PeopleSoft project as a case study, so I am also posting here on my PeopleSoft blog.
This video was produced as a part of the preparation for this session.  The slide deck is also available on my website.

Learning about and understanding the (more...)

Believer | Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Nov 24, 2019

My Son Dharun Performing at Improviser Music Studio

Believer



Please subscribe to our channel Improviser Music Studio

Shawn Mendes – Treat You Better | Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Nov 19, 2019

My Son Dharun Performing at Improviser Music Studio

Shawn Mendes - Treat You Better



Please subscribe to our channel Improviser Music Studio

Tchaikovsky | Swan Lake Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Nov 19, 2019

My Son Dharun Performing at Improviser Music Studio

Tchaikovsky | Swan Lake



Please subscribe to our channel Improviser Music Studio

Despacito | Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Nov 19, 2019
My Son Dharun Performing at Improviser Music Studio

Despacito



Please subscribe to our channel Improviser Music Studio

Ekadantaya Vakratundaya Keyboard Performance | by Dharun at Improviser Music Studio

Uncategorized
| Nov 19, 2019

My Son Dharun Performing at Improviser Music Studio

Ekadantaya Vakratundaya 



Please subscribe to our channel Improviser Music Studio

EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load

Uncategorized
| Nov 17, 2019
EBS 12.2 ADOP Cycle Errors During Validation  Cannot open XML file for load

ADOP cycle will have validation errors in some cases.

*******FATAL ERROR*******
PROGRAM :
(/test/apps/CLONE/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPEvalSrvStatus.pl)
TIME    : Wed Nov 13 15:50:36 2019
FUNCTION: TXK::XML::load_doc [ Level 1 ]
MESSAGES:
error = Cannot open XML file for load
errorno = No such file or directory
file =
/test/apps/CLONE/fs_ne/EBSapps/log/adop/6/fs_clone_20191113_153822/CLONE_test/TXK_EVAL_fs_clone_Wed_Nov_13_15_49_52_2014/ctx_files/CLONE_test.xml

*******FATAL ERROR*******
PROGRAM :
(/test/apps/CLONE/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME    (more...)

nVision Bug in PeopleTools 8.55/8.56 Impacts Performance

Uncategorized
| Nov 12, 2019
I have recently come across an interesting bug in nVision that has a significant performance impact on nVision reports in particular and can impact the database as a whole.

Problem nVision SQL

This is an example of the problematic SQL generated by nVision.  The problem is that all of the SQL looks like this. There is never any group by clause, nor any grouping columns in the select clause in from of the SUM().
 (more...)

Which Version Number Corresponds Which PeopleTools Object?

Uncategorized
| Oct 15, 2019
Recently somebody asked me "Our “CRM” values in PSLOCK and PSVERSION are growing tremendously and we don’t know why. We will be opening a case with Oracle but … do you know what that “CRM” value is related to? We are not using the CRM product in our PeopleSoft installation."
There is some documentation on the Oracle Support website, but it is not exhaustive and may not be completely up to date.

Understanding PeopleTools Object Version Numbers

Uncategorized
| Oct 14, 2019
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.

Caching

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.

Uncategorized
| Oct 9, 2019
[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

Uncategorized
| Sep 30, 2019
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

Uncategorized
| Sep 27, 2019

Not All Endpoints Registered

crsctl stat res -t

 --------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_LSTNSOLTP .lsnr
     1        ONLINE  INTERMEDIATE orcl1           Not All Endpoints Registered,STABLE
ora.LISTENER_LSTNSOLTP .lsnr
     1        ONLINE  ONLINE       orcl2           STABLE
ora.LISTENER_LSTNSOLTP .lsnr
     1        ONLINE  ONLINE       orcl3           STABLE

"Not All Endpoints (more...)

What Looks Good To Me: Oracle OpenWorld 2019

Uncategorized
| Sep 11, 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...)