摘要：
Select PeopleTools, Utilities, Debug, Trace SQL to access the Trace SQL page.You use this page to change the SQL tracing options while you're online. Your Configuration Manager settings are not affected:Trace SQL StatementSelect to show the SQL statement.Trace SQL BindSelect to show bind values 阅读全文
摘要：
Using the PeopleTools Test Utilities PageSelectselectPeopleTools,then selectUtilities,then selectDebug,then selectPeopleTools Test Utilitiesto access the PeopleTools Test Utilities page:Image: PeopleTools Test UtilitiesThis example illustrates the fields and controls on the PeopleTools Test Utilitie 阅读全文
摘要：
Configuring PeopleCode TraceSelect PeopleTools, Utilities, Debug, Trace PeopleCode to access the Trace PeopleCode page.You use this page to change the PeopleCode tracing options while online. This page does not affect trace options that are set in PeopleSoft Configuration Manager. Use Trace PeopleCo 阅读全文
摘要：
If you are seeing messages like this in your message log when running a process through the process scheduler and distributing the information via email:SMTP sendMail failed (server yourserver.com:25). Cannot send email to example@test.comFailed to connect to the SMTP server at :25It indicates that 阅读全文
摘要：
Oracle临时表可以说是提高数据库处理性能的好方法，在没有必要存储时，只存储在Oracle临时表空间中。希望本文能对大家有所帮助。1 、前言Oracle Logo目前所有使用 Oracle 作为数据库支撑平台的应用，大部分数据量比较庞大的系统，即表的数据量一般情况下都是在百万级以上的数据量。当然在 Oracle 中创建分区是一种不错的选择，但是当你发现你的应用有多张表关联的时候，并且这些表大部分都是比较庞大，而你关联的时候发现其中的某一张或者某几张表关联之后得到的结果集非常小并且查询得到这个结果集的速度非常快，那么这个时候我考虑在 Oracle 中创建“临时表”。我对临时表的理解：在 Ora 阅读全文
摘要：
1、初始化连接。App Server从配置文件中获得connect ID和user ID进行数据库初始化连接。2、查询数据库中与安全相关的表信息connect ID被验证以后，AppServer查询PeopleTools的相关表（PSOPRDEFN，PSACCESSPRFL,PSSTATUS）,从这些表中AppServer能够获得user ID和password，symbolic ID，access ID和access password。AppServer获得这些信息后就断开数据库连接。3、App Server使用access ID重新连接数据库系统验证access ID有效以后，App Se 阅读全文
摘要：
SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.SELECTd.oprid,d.oprdefndesc,c.roleuser,a.rolename,a.classid,b.classdefndescFROMpsroleclass a,psclassdefn b,psroleuser c,psoprdefn dWHEREa.classid=b.classidANDc.rolename=a.rolenameANDd. 阅读全文
摘要：
In aprevious postI showed you how to know what Roles are assigned to a specific user. But here is how you find out what Users are assigned to a specific Role.SELECTC.OPRID, C.OPRDEFNDESC, A.ROLENAME, A.DESCR FROMPSROLEDEFN A, PSROLEUSER B, PSOPRDEFN C WHEREB.ROLENAME=A.ROLENAME ANDC.OPRID=B.ROLEUSER 阅读全文
摘要：
Here is a query that I often use to lookup Roles assigned to a specific PeopleSoft user.At run time, replace :1 with OPRID your are looking for OR user name (partial search also works).SELECTC.OPRID,C.OPRDEFNDESC,A.ROLENAME,A.DESCRFROMPSROLEDEFN A,PSROLEUSER B,PSOPRDEFN CWHEREB.ROLENAME=A.ROLENAMEAN 阅读全文
摘要：
1) Run the below SQL to get the content reference name for your componentSELECTPORTAL_NAME, PORTAL_OBJNAMEASCONTENT_REFERENCE, PORTAL_LABEL, PORTAL_URI_SEG1ASMENU, PORTAL_URI_SEG2ASCOMPONENT, PORTAL_URI_SEG3ASMARKET FROMpsprsmdefn WHEREPORTAL_NAME='EMPLOYEE' ANDPORTAL_URI_SEG2=:1;-- Replace 阅读全文