WTK870424-CSDN博客

转载 Sequence Number Allocation in PeopleSoft

In PeopleSoft for the Oracle DBA Chapter 8 (p168-170) in a section called Sequence Numbers and Concurrency I discuss the implications of how this is done in HR8.4 as a part of the save time processi

2011-12-21 23:03:55 842

转载 XLATTABLE /PSXLATITEM and PSXLATDEFN

XLATTABLE /PSXLATITEM and PSXLATDEFN – are the PeopleSoft translation tables, XLATTABLE is used to store translate values in PeoleTools versions prior to 8.4x, while PSXLATDEFN and PSXLATITEM contain

2011-12-20 23:18:19 722

转载 PSACCESSPRFL

PSACCESSPRFL – is a fundamental table used by the system to sign on and validate an operator’s id account and it stores the Access Id and its password.This table is used together with PSOPRDEFN,PSSTAT

2011-12-20 23:17:18 611

转载 PS_MESSAGE_CATALOG

PS_MESSAGE_CATALOG – this table is used as a catalog, to keep the messages that appear in the Message Log, PIA error/warning messages ,etc., their corresponding message set number and the message numb

2011-12-20 23:15:42 1832

转载 PS_CDM_LIST

PS_CDM_LIST table – is used by the distribution agent and the changing of the DISTSTATUS of a certain job instance will stop the distribution agent from trying to post the corresponding process.Thi

2011-12-20 23:14:26 531

转载 PSPRCSRQST and PSPRCSQUE

PSPRCSRQST and PSPRCSQUE tables – when a user submits a process request to the Process Scheduler a corresponding record will be inserted in the PSPRCSRQST (Process Request) table and afterwards replic

2011-12-20 23:10:51 632

转载 Resolving unique constraint violations in PeopleSoft processes

Anyonewho has supported PeopleSoft applications long enough is all too familiar withthe dreaded ORA-0805 error, a unique constraint violation. That error mostfrequently occurs when a process tries to

2011-12-20 22:54:31 573

转载 Row Level Locking in the PeopleTools Component Processor

Row Level Locking in the PeopleTools Component ProcessorMy apologies in advance, but this entry is a bit of a rant. It is one of those things in PeopleSoft about which you do nothing, but i

2011-12-19 23:03:14 560

转载 PeopleSoft error report: Error: Data Integrity Error

PeopleSoft error report: Error: Data Integrity Error is usually caused by the corruption of some cache files of the PeopleSoft Application Server/s. The most common resolution is , therefore, to clear

2011-12-19 22:51:22 688

转载 Integration Broker “Application Message Instance Error” are not sent correctly

If you have noticed that the Integration Broker notification messages are not recieved by all intended users you may want to check the following aspects:To start with, one must underline the fact th

2011-12-19 22:50:43 924

转载 Query security script

—Oracle sql script to determine the access groups and trees a user has access toselect DISTINCT A.ACCESS_GROUP,A.TREE_NAME, B.OPRCLASS FROM PS_SCRTY_ACC_GRP A, PSOPRCLS B WHERE OPRID = ‘YourOPRID’ A

2011-12-19 22:47:13 455

转载 Query uses advanced features that you don’t have access to

If you encounter the following message when trying to Edit or Run a specific query from Reporting Tools>Query>Query Manager:Query “QUERY_NAME” uses advanced features that you don’t have acess to.Y

2011-12-19 22:46:09 743

转载 Process Scheduler monitoring useful script

SELECT S.SERVERNAME, X.XLATSHORTNAME,X.FIELDVALUE,cast(S.MAXCPU as varchar2(3))||’%’ MAXCPU,cast(S.PRCSDISKSPACE as varchar2(15))||’ MB’ PRCS_DISK_SPACE,TO_CHAR(S.LASTUPDDTTM,’DD-MM-YYYY HH:MI:SS’)LAS

2011-12-19 22:44:21 419

转载 Navigation access in Portal for permission lists/operators in PeopleTools >= 8.40

—Oracle Sql—The Peoplesoft Navigation menus, PS menus and components a specific user can accessSELECT DISTINCT Dev.PATH MENU_PATH, Dev.portal_objname PORTAL_OBJECT, Dev.PORTAL_URI_SEG2 PS_COMPONEN

2011-12-19 22:39:06 492

转载 PS_SEC_BU_OPR Script

—Oracle Sql—grant “NewOPRID” user rights to the same BUs as “CloneOPRID” user has access toINSERT INTO PS_SEC_BU_OPR (OPRID, BUSINESS_UNIT) SELECT ‘NewOPRID’, BUS FROM (SELECT DISTINCT BUSINESS_UN

2011-12-19 22:38:24 848

转载 PSACCESSLOG scripts

—Oracle Sql—Number of users connected to the environment per day /’2009-08-16′SELECT COUNT(Num) Users_Number FROM ( SELECT count(A.OPRID) AS NumFROM PSACCESSLOG AWHERE TO_CHAR(((A.LOGINDTTM

2011-12-19 22:36:35 530

转载 RunAeAsync parameter data validation failed

The following error appears in the Process Scheduler Log: RunAeAsync parameter data validation failed.Solution:This situation may occur for an Application Engine for which a trace info has been se

2011-12-19 22:34:38 1316

转载 PS_AETEMPTBLMGR

PS_AETEMPTBLMGR – is the table that stores references (AE_APPLID) to the temporary PeopleSoft tables (_TAO,_TMP) used when running a specific Application Engine. The table contains, also, the process

2011-12-19 22:33:35 404

转载 Version Check Audits-Exception(s) found, Manger-xxx Version check of table xxxDEFN against PSVERSION

When running the SQR Report SYSAUDIT from the sample Processes(PT=8.4xx) one might encounter the following error:Version Check Audits-Exception(s) Found, Manager- OBJECTTYPENAME (eg:RDM,UPM,etc.) Ve

2011-12-19 22:32:09 590

转载 Temporary Table processing failure during allocation phase

Usually,when an application engine is run it inserts a record corresponding to the RunControl Id and the process instance in the PS_AERUNCONTROL and a record in thePS_AETEMPTBLMGR if a temporary table

2011-12-19 22:27:41 1851

转载 PSSTATUS

PSSTATUS – contains useful PeopleSoft information such as the PeopleSoft environment database OWNERID (eg:SYSTEM,SYSADM,sa ,etc. ),the PeopleTools release version (TOOLSREL), the LASTREFRESHDTTM colu

2011-12-19 22:25:08 607

转载 Single quotes, among other characters that are not supported in PeopleTools Run Control Ids

As specified in the PeopleSoft Process Scheduler PeopleBook (PeopleSoft Process Scheduler > Submitting and Scheduling Process Requests > Understanding Run Control IDs, Chapter 3, page 12) and as

2011-12-19 22:22:39 537

转载 PS_AERUNCONTROL

PS_ARUNCONTROL – is used to record temporary information onPeopleSoft running processes that are restart enabled. When a processes endedin success the corresponding record in PS_AERUNCONTROL is delete

2011-12-19 22:21:51 702

转载 Do You Need More Temporary Table Instances?

Do You Need More Temporary Table Instances? When an Application Engine loads a program prior to execution, it attempts to allocate an instance of each temporary record specified in the program

2011-12-19 20:59:32 548

转载 Unlocking Temporary Table Instances from Deleted Process Requests

Unlocking Temporary Table Instances from Deleted Process RequestsIn a previous blog entry, I discussed how to detect whether an Application Engine process had run out of non-shared Tempora

2011-12-19 20:55:55 510

转载 PeopleSoft Security Logging

This question came up during the recent application security audit – how does PeopleSoft track user sign in attempts and locations.Aside from the obvious PSOPRDEFN table there is PSACCESSLOG – thi

2011-12-16 17:16:52 601

转载 WSDL to Component Interface Faults

Component Interfaces is one of the coolest features in PeopleSoft from a technology point of view. The folks in Pleasanton either had great deal of prescience (or were extremely lucky) when they desig

2011-12-16 17:14:47 566

转载 PeopleSoft VMware Support

I am a huge fan of VMware and have been using it since some version long ago before the company was acquired by EMC. I use it as an integral part of my day-to-day activities and actively promote its u

2011-12-16 17:13:24 620

转载 Custom Search Match Fields

Search/Match is an extremely powerful feature in PeopleSoft. Unfortunately, the delivered functionality is restricted to matching on only a few fields and PeopleSoft provides little to no information

2011-12-16 17:11:55 774

转载 Considerations when calling Java from PeopleCode

When developing custom or extended functionality in PeopleSoft it is useful to consider invoking Java objects to supplement functionality available in PeopleCode.PeopleSoft applications are able to

2011-12-16 16:58:31 633

转载 Adding Custom CREF Images to Folders

Adding Custom CREF Images to FoldersHave you ever noticed that some links have a custom image in the navigation likethis?It is very easy to reference an existing image in the PeopleTools database.

2011-12-16 14:33:59 408

转载 Find Portal CREF in Navigation

Find Portal CREF in NavigationHere is a quick way to find where a component shows up in the portal navigation for a given component. In this example, we are going to find the navigation for the JOB_

2011-12-16 14:33:53 514

转载 Deleting Portal User favorites

Deleting Portal User favoritesHere is a SQL that will delete user portal favorites. You may need this if a user has favorited a component that does not exist or that you no longer want them to favor

2011-12-16 14:33:47 396

转载 A Better Run Control Page Standard

A Better Run Control Page StandardRun control pages can be hard for users to comprehend. When a user looks at a run control page they may ask:What is this process and what are the ramifications

2011-12-16 14:33:39 413

转载 PeopleTools Tables

PeopleTools TablesList of Key PeopleTools TablesProjectsPSPROJECTDEFN – Project header table PSPROJECTITEM – Definitions in the projectFieldsPSDBFIELD – Fields in the systemPSXLATITEM –

2011-12-16 14:33:31 600

转载 Force a CREF Open in a New Window

Force a CREF Open in a New WindowHere is a quick tip to make a portal Content Reference (CREF) open in a new window. This might be used for linking to an external or intranet site that is not part o

2011-12-15 23:08:24 535

转载 Useful PIA Servlet Directives

Useful PIA Servlet DirectivesThere are several “hidden” PIA servlet commands that can be used to perform several key actions when maintaining aPIA webserver. The “pwd” parameter comes from the cus

2011-12-15 23:07:07 334

转载 How to get files to show up in the Process Monitor/Report Repository

How to get files to show up in the Process Monitor/Report RepositoryA common problem for SQR and application engine developers is how to make files generated inSQR and Application Engine accessibl

2011-12-15 23:06:05 782

转载 Unique Constraint Error on PS_MESSAGE_LOG

Unique Constraint Error on PS_MESSAGE_LOGIf you are getting a unique constraint error on PS_MESSAGE_LOG in the process monitor like this:ORA-00001: unique constraint (SYSADM.PS_MESSAGE_LOG) violat

2011-12-15 23:04:02 1003

转载 Reset Password from back end

Reset Password from back endHere is a DMS script that needs to be run in “bootstrap” mode (sa orsysadmin user) where you can reset a PeopleTools user password from the back end.set log c:\temp\dm.

2011-12-15 22:58:17 424