The next profile in our ‘How I Work‘ series is Sasank Vemana. Sasank burst onto the PeopleSoft blogging scene in 2014 with his Sasank’s PeopleSoft Log site, and has been adding entries at a ferocious pace since. He is probably best known for his series of posts on altering the PeopleSoft branding to make it match a corporate palette, as well as configuration and code changes related to UI/UX.
I met Sasank at (more...)
Lately I have had to install Weblogic 12.1 and OHS 12.1 on a Linux server in silent mode.
Somehow, there was very small space left on the default temporary filesystem /tmp.
I was having to find a way to install within the non-default /tmp.
Not so simple to find the option in the command line, that's why this article as a note for myself, maybe it also can help others.
Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses. Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers. I have collected that advice in to a document that I have recently published on my website (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf (more...)
HEUG Alliance is next week. I hope you are registered. I know this will be a fun and informative conference (as always). I am scheduled for two sessions at Alliance:
- PeopleSoft Developer: Tips and Techniques on Monday at 3:30 PM in room 6B/C and
- PeopleSoft Meet the Experts on Tuesday at 10:15 AM in room 307/308 table 2.
When I'm not in sessions, you will find me in the demo grounds. Stop by and say "Hello!"
I have recently spent far too much time in far too many conversations in which the terms "cloud" and "SaaS" are used interchangeably. Let's be clear: the two terms are not interchangeable as they describe very different concepts.
Cloud. There are many definitions out there. Marketers and sales people. Engineers. Industry analysts. The National Institute of Standard and Technology.
Frankly, most of those definitions are either wrong, or they're technically accurate while thoroughly useless. (more...)
The BI Publisher SIG is gearing up for Collaborate 2016 in April and is looking for volunteers to share their experiences, tricks, tips, challenges, etc… with fellow users during our meeting in Las Vegas on Monday April 11th. Do you have a story to tell? Want to showcase a challenge? Want to brag about an accomplishment? We would love to have YOU, the actual user spend 10-15 minutes sharing your experiences/stories with (more...)
There are some performance improvements that require physical storage options to be set on tables or indexes.
One particular technique that I will take as an example for this article is index compression. A good example in PeopleSoft is the tree node table, PSTREENODE. It drives many security and hierarchical queries. It is not updated very frequently, only as new trees are brought on. Many of the indexes are good candidates for compression. Oracle can (more...)
A long time I was not really active on eBS, a long time I was not blogging anymore.
I just want to document my R12.2 adventures.
One was that the fast formula text is now stored in a clob column, gone is the long column. Finally. Our Documentool for Payroll supports this little change already for a while.
Value set security. I was not able anymore to enter values for a value set. Reading
For a procedure (or function) in a package, you can assign default values only in the package specifications without assigning them in the package body:
SQL> CREATE OR REPLACE PACKAGE test_default_pkg AS
PROCEDURE set_global (p_num IN NUMBER DEFAULT 1);
Package TEST_DEFAULT_PKG compiled
SQL> SHOW ERRORS;
SQL> CREATE OR REPLACE PACKAGE BODY test_default_pkg AS
PROCEDURE set_global (p_num IN NUMBER) AS
Package body TEST_DEFAULT_PKG compiled
SQL> SHOW ERRORS;
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
PeopleSoft Tipster Blog
So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.
Amazingly, the (more...)
Next up in our ‘How I Work‘ series is Dan Iverson. Dan – together with partner-in-crime Kyle – runs the PSAdmin.io blog. If you’re a PeopleSoft administrator and connected to the Internet then there’s no doubt that you’ll have heard of their blog as they’re really prolific and have posted some great content. Clearly blogging wasn’t enough however, and there is now the PeopleSoft Administrator PodCast which is ~45 minutes of topical awesomeness. I (more...)
Happy New Year! No predictions from me for 2016...we've all seen how poorly that works out. No resolutions either (although I may open a fitness gym called "Resolutions"...the place converts into a bar at the end of January). Instead, I simply leave you with the wisdom of Dr. Seuss; something to consider as you kick off the new year.
The Zode In The Road
Did I ever tell you about the young (more...)