Application Eninge AET table initialization

I see this in one AE:

They are initialized earlier in the AE this way. Basically it uses the %Select to select the data into these AET table fields. Also notice how it uses the %Bind to pass the parameters in the query.

PeopleSoft Navigations

URL maintenance
PeopleTools --> Utility --> Administration --> URLs.

Message Catelog
PeopleTools --> Utility --> Administration --> Message Catelog.

Application Engine error

If you see this error when running an Application Engine:

Warning: Application Engine Request is not active -- processing suspended

You need to run this in the database to clear it up:

--- Here xxxxx is the OPRID

SELECT * FROM PS_AEREQUESTTBL WHERE OPRID = 'xxxxx';

--- From the result above, determine which one to remove, and the run the

--- following to remove the entry. (Be sure to add more criteria if needed)

DELETE FROM PS_AEREQUESTTBL WHERE OPRID = 'xxxxx';

PeopleCode Events

PeopleSoft provides a few PeopleCode events which are fired at different times.

Event	Description
SearchInit	PeopleCode performs before the search dialog box displays.
SearchSave	Used after the operator clicks OK in the search record dialog box.
RowSelect	Used to filter out rows of data.
PreBuild	Used to hide and unhide the pages.
FieldDefault	Set defaults for fields without a value.
FieldFormula	Fired after FieldDefault completes successfully. This is mostly used to store function definitions.
RowInit	Used to initialize the rows.
PostBuild	Fired after all the component build events have performed.
Activate	Fired every time the page is activated.
FieldEdit
FieldChange
RowDelete
SaveEdit
SavePreChange
SavePostChange
RowInsert
WorkFlow
PrePopup

More to come....

Run a PeopleSoft process

To run a PeopleSoft process, go to

PeopleTools --> Process Scheduler --> System Process Requests

It will ask you for Run Control ID, if you don't have one, you can create a new one; if you have one, you can search and locate it. It will then bring you to

Now click "Run" and it will bring you to the page that lists all the processes available there. Choose the one you want to run and go to the bottom of the page and click OK to run it.

It will bring you back to the previous page, where now you can go to the "Process Monitor" which sits right before the "Run" button.

[[ Screen shot ]]

The page will show all the processes associated with this user. You should find the process you just ran there. To view detail information, click the "Details" link of the process. It will bring you to the detail page where you can check more information, such as Message Log, Parameters, Log/Trace.

Emulate a user in PeopleSoft

When you log in as yourself, you usually are associated with your own EMPLID, which is specified in the PSOPRDEFN table.

[[Insert screen shoot]]

To emulate another user, you can go to

PeopleTools --> Securities --> User Profiles --> User Profiles

Locate your profile, then go to the ID tab, pull down dropdown ID Type, and choose Employee (assuming that's what you want). Then in the Employee Attribute Value field, enter/look up the employee you would like to emulate.

You may be getting a warning at this moment:

This is normal, because we are using someone else's ID here.


Log out and log back in, PeopleSoft will be using that employee ID to load data.

Note, PeopleSoft still uses your own roles/permissions, not those of the employee!!

Running SQR

The basic command to run an SQR is:

sqr nameofsqr.sqr userid/password -printer:lp