2012年06月_WTK870424

10月 09月 07月 06月 05月 03月 02月 01月

转载 PeopleTools Cache Clearing Guide

There are 3 types of server Cache in PeopleSoftApplication Server CacheWeb Server CacheProcess Scheduler CacheThere is continued confusion on when and what cache should be cleared. This document

2012-06-17 11:07:23 849

转载 DB Link

You are here: Home /SQL Examples / DB LinkDB LinkTo Find a DB Link:SELECT * FROM DBA_DB_LINKS To use a DB Link, list the table name, the ‘@’ symbol and the DB Link nameSELECT NAME1 F

2012-06-14 22:10:42 639

转载 PeopleTools Tables (Where the MetaData is Stored)

';HomePeopleCode & PeopleToolsApplication Class BasicsDynamic Hyperlink & Hover TextEmail Using Application PackageFile AttachmentsPeopleTools Tables (Where the MetaData is Stored)Popu

2012-06-14 22:09:15 1459

转载 Peoplesoft Component interface HOWTO

Here is a tutorial explaining how you can create a function containing one Component INterface, and make use of it from any peolplecode.Following example takes the PO Receipt Component to make autom

2012-06-08 17:45:55 1022

转载 Xls XMLP Output opening in Browser, not Excel

I have an issue that I wouldn’t have thought I’m the first to encounter, but I can’t see any record online of others discussing it. The problem is as follows:I’ve written an XML Publisher report tha

2012-06-08 17:40:37 928

转载 XML Publisher and Out of Memory Errors

I’m getting a lot of comments on the XML Publisher posts about ‘Out of Memory’ errors. I’ve not experienced this myself so can’t give a fix or workaround, but wondered whether anyone else had hit this

2012-06-08 17:39:41 732

转载 Auto Login to PeopleSoft and App Designer

You can set up shortcuts to auto-logon to the PeopleSoft PIA and/or App Designer.I’m still in two minds whether to add this post or not, but there are some circumstances where this can save you a bi

2012-06-08 17:38:26 1424

转载 Using the PIA Welcome Message

The PIA Welcome message, or Portal Greeting is a pretty simple piece of functionality, but I’ve not seen it used on a single client site. For those that haven’t seen it before, it looks like this:

2012-06-08 17:38:10 1273

转载 Moving the Search Box

The other day I noticed a PeopleSoft environment with the Search box (the box that appears at the top of the left hand menu on the default home page) in the top right hand corner. It seems a far more

2012-06-08 17:37:38 1036

转载 Incrementing Counts in SQL

Fairly frequently (particularly during Data Migration when deriving new key values) you have to rank and number rows within a particular key value. For instance, Key1 may have three rows – and these s

2012-06-08 17:34:04 592

转载 Using WITH Clause to mimic App Engine Temp Tables

I've been working on an App Engine that makes use of Temp tables and uses the %Table meta-sql. It's sometimes difficult to debug your App Engine SQL because the data in the temp table gets deleted at

2012-06-08 17:33:12 657

转载 Most Recently Used

Most Recently UsedA new feature of PeopleTools 8.50 is the horizontal navigation menu that runs across the top of the screen below the header. It means the menu down the left hand side is no l

2012-06-08 17:31:25 1266

转载 Improving PeopleSoft with jQuery - Some Examples (Part 1)

I must thank Jim Marion for turning me on to jQuery. He has made various posts over the last 3 or 4 years about it (see here.) I've also sat in on one or 2 presentations he's made where he's mention

2012-06-08 17:30:03 902

转载 PeopleSoft Branding

Here's one way to change your PeopleSoft Portal Header from thisto something like thisPrefaceI was grateful I discovered @peoplesoftwiki's great post about PeopleSoft Branding. It meant

2012-06-08 17:28:56 854

转载 Improving PeopleSoft with jQuery - Some Examples (Part 2)

Making a Collapsible Data Area a Bit BetterHave you ever turned on the Collapsible Data Area property on a group box or grid? If you do, all you get on the page to expand or collapse your group box

2012-06-08 17:12:49 631

转载 Creating an entirely read-only user in PeopleSoft

On big projects it is quite likely that large numbers of developers have access to a many environments. Occasionally they can have access to environment which is quite important, for instance one that

2012-06-07 19:37:57 936

转载 Colour Schemes v2

A few years ago I put together a set of five alternate colour schemes for the PeopleSoft PIA and made them available for free download. The intention was that clients could use a colour for each envi

2012-06-07 19:30:09 727

转载 Installed 8.50 but still have the old look?

If you install PeopleTools 8.50 with an ‘old’ application (i.e. one that is prior to v9.1) then the UI you’ll see still looks very much like the one we’re used to. What’s happened to all of the new 8

2012-06-07 19:27:48 562

转载 GP BLOG

http://www.jreconsulting.co.uk/

2012-06-07 19:22:49 461

转载 jump to navigation Portal Greeting on Tools 8.50

I’ve posted before about using the Portal Greeting / PIA Welcome message to display something usefulhere. I’ve recently come to implement this on a client and discovered that the method I suggest

2012-06-07 19:14:20 606

转载 peoplesoft youtube

http://www.youtube.com/watch?v=rdreg8mTaTY&feature=list_related&playnext=1&list=SP3AFBFB9AC3A1AB6E

2012-06-07 19:10:25 453

转载 Error in Recruitment – Build Applicant Search February 3, 2011

Error in Recruitment – Build Applicant Search February 3, 2011 Posted by Tipster in PeopleTools, Recruitment, Troubleshooting, Verity. trackbackThis probably won’t help a great many pe

2012-06-07 18:38:45 666

转载 Changing the Favicon in PeopleSoft

A Favicon (short for favorites icon, also known as a shortcut icon, website icon, URL icon, or bookmark icon) is a small logo that appears next to the website URL in the browser address bar. This web

2012-06-07 18:00:57 553

转载 Changing the Favicon in PeopleSoft – The “How to”

Last week I posted a blog entry highlighting why I think adding a favicon to PeopleSoft can be a helpful visual aid for your users. This post walks through how I did it – note: I’ve only tested thi

2012-06-07 17:58:10 801

转载 Browser speed discrepancies

Whilst troubleshooting the performance of an environment recently I used the PeopleSoft Ping utility. I’m aware that it isn’t a flawless measure, but for a quick and dirty check it’s a useful aid.F

2012-06-07 17:02:10 592

转载 Deleting old User Profiles

Vanilla databases often contain 150-200 ‘example’ user profiles. While these can be useful to clone as a starting point early in an implementation, they’re frequently left dormant as the project conti

2012-06-07 16:06:11 500

转载 Using JavaScript in PeopleSoft: Creating your own dialog boxes

Using JavaScript in PeopleSoft: Creating your own dialog boxesIn previous posts, I've described how I have been using JavaScript to enhance our PeopleTools 8.49 application. I've covered c

2012-06-07 15:54:35 1002

转载 Using jQuery in PeopleSoft: Validating, Formatting and Totaling

Using jQuery in PeopleSoft: Validating, Formatting and TotalingIn my last entry, I introduced using JavaScript and, specifically, the jQuery library to enhance your PeopleSoft pages. Now we'

2012-06-07 15:53:07 647

转载 Using JavaScript in PeopleSoft: Proxy PeopleSoft Functions

Using JavaScript in PeopleSoft: Proxy PeopleSoft FunctionsIn my last post, I showed you how to do dynamic field level validations in JavaScript with the help of jQuery. In this post we'll

2012-06-07 15:51:47 1063

转载 Using jQuery in PeopleSoft: Introduction

At my company, management decisions have kept most of our PeopleSoft applications on PeopleTools versions prior to 8.50. So we haven't been able to take advantage of the new AJAX features that come wi

2012-06-07 15:49:28 727

转载 PeopleSoft and the Load Balancer

We are doing a PeopleSoft PeopleTools upgrade among with upgrading our server environment to a "high availability" configuration. In PeopleTools, we are upgrading from 8.43 to 8.48. Many "little" thin

2012-06-07 15:45:32 524

转载 Get Rid of Unwanted Save Warning

Get Rid of Unwanted Save WarningHave you ever had a component that gave you unwanted Save Warnings. I recently had to deal with this problem on a page that had a custom button that amo

2012-06-07 15:35:22 634

转载 Custom Buttons on Modal Pages

Custom Buttons on Modal PagesThere are lots of good reasons to use modal pages and components in PeopleSoft. However, one thing you sacrifice is control, especially if you use the delivere

2012-06-07 15:33:25 426

转载 Extracting Record and Field Metadata

Extracting Record and Field MetadataAs part of a data integration effort, I created a program - an Application Engine - to extract useful metadata for PeopleSoft record and field definitio

2012-06-07 15:28:16 482