摘要：
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 阅读全文
摘要：
Open the following defination and changed them.1. NEW_PS_LOGO (Image Type) - To change the logo.2. PORTAL_UNI_HEADER_NS4X (Html Type) - Change logo name on mouse over.3. PORTAL_UNI_HEARDER_NNS (Html Type)4. PT_BRANDING (Application Package Type) - Deals to manipulate homepage and portal look.Note:Do 阅读全文
摘要：
Portal RegistryEach portal is defined by a portal registry.A portal registry has a tree-like structure in which content references are organized, classified, and registered.A portal registry contains folders and content references.In the portal registry, folders organize content references into a mu 阅读全文
摘要：
Steps to configure and get Reports in Report manager.1. Enable getting Reports in Report Manager.2. Add New Folders.3. Get new files to Process Monitor.4. Assign/Create required Permission Lists/Roles to Users.5. Configure the process.6. Create a new run control id.7. Run it.8. Verify it.For any rep 阅读全文
摘要：
The Rowset class contains two methods that can be used to show and hide all rows:ShowAllRows()HideAllRows()You can use these two methods to show or hide a grid on a page associated wtih a particular rowset.Simply make sure that the grid uses the main record that your rowset refers to, then refer to 阅读全文
摘要：
If you ever need to create a view that selects all fields from a particular record, then you should be using the%SelectAllmeta-sql construct.Why? Because%SelectAlluses the underlying record definition to select the fields - so it will always return all fields from the underlying record, even if that 阅读全文
摘要：
If you are trying to set the value of a field through PeopleCode and that field happens to beNAMEthen you will experience the following error when using the shortcutRowset(Row).Record.Field.Value approach:&rsExample(1).DERIVED.NAME.Value = "This will error";Gives the following error wh 阅读全文
摘要：
A blunt, but useful method for debugging PeopleCode is to use the inbuilt "Error" function to stop processing and provide a message.Something as simple as this can be a valuable debugging tool at times:Error "The value of variable x=" | &x;Most people use message box (or the 阅读全文
摘要：
The Case-When-Exists expression in Oracle is really handy. Here's an example of how to use it in a sub-select to return a status. This SQL checks for a match between thePS_PERSONandPSOPRDEFNrecords to determine the person status. The idea is that if the operator is not inPS_PERSONthen they are n 阅读全文
摘要：
Use theSearchClear()method which is part of the Field class to clear search values on a particular search key field. This is how you canresetsearch parameters specified by a user when they press theReturn to Searchbutton.You can call this using the shortcut notation:RECORD.FIELD.SearchClear();Or you 阅读全文
摘要：
I find that you often need to create and manipulate standalone rowsets. Sometimes you can get the data for your standalone rowset from the database using theFillmethod, however sometimes you'll want to copy from existing rowsets. This is where theCopyTomethod comes in handy.However there is one 阅读全文