As I was going through some of the sessions on the QUEST NORTHEAST CONFERENCE I noticed on of the presenters mentioning customizing Test environments Main PeopleSoft CSS PSSTYLEDEF so that the users are always able to distinguish between environments.
The solution that I have employ to solve this problem is to modify the PT_BRANDING:BrandingBase class to [...]
Entries Tagged as 'Tips'
What Environment Am I in?
July 10th, 2009 6 Comments
Tags: GUI · PeopleSoft · Tips
PeopleTools 8.50 Overview
June 12th, 2009 2 Comments
Here is a link to an excellent presentation from Oracle of PeopleTools 8.50 features. PeopleSoft is really going Web 2.0!
peoplesoft_workspace_and_pt850.swf (application/x-shockwave-flash Object)
Also please see our previous post about Tools 8.50 overview
Tags: PeopleTools · Tips
DB2 Escape characters in queries
February 18th, 2009 No Comments
Recently I had to use escape characters in DB2 queries and after looking through documentation here is a simple way to do this. You can define you escape character using
{escape ‘\’}
right after the statement your are trying to use it, here is a sample statement:
select oprid, oprdefndesc
from psoprdefn
where oprid like ‘%\_%’ {escape ‘\’}
.csharpcode, [...]
Getting Information about PeopleSoft Components from Database
June 3rd, 2008 No Comments
SQLs below have proved to be great while working behind the scenes and creating report about PeopleSoft customizations. These are quick ways to get behind the scenes and see the objects the way PeopleSoft sees it.
Getting fields and records for a page:
select OCCURSLEVEL as level ,FIELDNUM as taborder, LBLTEXT as label ,
RECNAME as record ,FIELDNAME [...]
Tags: PeopleSoft · SQL · Tips
DB2 Space Management
March 12th, 2008 No Comments
Here are some very useful utility SQLs that will allow you to understand your space usage, system and other useful stuff:
DB2 Space Usage & Status
1: — to find tablespace status, type , usage run following SQL
2: select substr(tablespace_name,1,20) Tablespace_name,
3: case t.TBSPACETYPE [...]
Non-Shared Temp Tables Cleanup
March 7th, 2008 No Comments
Some of the processes that depend on shared table instances , can experience a dramatic differences in performance, in case all of the instances available are being used, or remaining locked by some orphan or failed process. One way to resolve this problem is to go online and check if tables should be “released”. Here [...]
Tags: PeopleSoft · Performance · SQL · Tips
DB2 Scripts – Table Management
March 4th, 2008 No Comments
Here are a few more nice DB2 scripts that would save you time:
Get all tables in Table Space
– Get all tables in particular tablespaceselect SUBSTR(TABNAME,1,25) "TABNAME", SUBSTR(TABSCHEMA,1,15) "SCHEMA", NPAGES, CARD from syscat.tables where tbspace = ‘?’
Generate Grants for all tables in Table Space
– Genereating GRANTS SELECT ‘grant select on ‘ || tabname || ‘ to [...]
Loading ...
Oracle PeopleTools Blog