随笔分类 -  application designer

7 Steps to Setup A Record Level Audit in PeopleSoft
摘要：Record level AuditingAs the name suggests, record level auditing is the auditing mechanism enforced on aRecord. To set up record level auditing, follow the steps below.1. Choose the Record Not all records in PeopleSoft need auditing. When there is such a business requirement, choose the record(s) th 阅读全文
posted @ 2013-10-26 17:48 Bryan chen 阅读(492) 评论(0) 推荐(0)
Field Auditing
摘要：There are two types of delivered auditing in PeopleSoft:Field level auditingRecord level auditingField level auditing tracks changes to one or more fields on a PeopleSoft record and stores the results in the deliveredPSAUDITtable.Like record level auditing, field level auditing only applies to data 阅读全文
posted @ 2013-10-26 17:17 Bryan chen 阅读(243) 评论(0) 推荐(0)
Copying Fields to a new Record
摘要：This is a time saving tip for application designer. If you are creating a new record definition and you want all or most of the fields from an existing record, you can simply open the existing record, select the fields you want and drag them over to your new record as shown in the screenshot below.H 阅读全文
posted @ 2013-10-26 16:36 Bryan chen 阅读(160) 评论(0) 推荐(0)
Target Operator ID has No Access to Upgrade
摘要：If you are attempting to migrate a project between environments through application designer you might get a message saying:Target Operator ID has 'No Access' to Upgrade. (62,14)In the explain text, it states that:In order to access the target database, your target Operator ID must have ' 阅读全文
posted @ 2013-10-26 16:35 Bryan chen 阅读(317) 评论(0) 推荐(0)
Application Designer Security
摘要：This wiki page covers how to manage and restrict Application Designer security through permission lists.The first thing to do is identify all permission lists that provide access to theAPPLICATION_DESIGNERmenu using the following query:selectdistinctCLASSIDfromPSAUTHITEMwhereMENUNAME='APPLICATIO 阅读全文
posted @ 2013-10-26 16:34 Bryan chen 阅读(206) 评论(0) 推荐(0)
Data Being Added Conflicts with Existing Data
摘要：While developing a page with multiple scrolls levels, and especially when using a grid, you may get the errorData being added conflicts with existing data. (18,2).This suggests a problem with the key structures in the tables in your lower scroll levels.For example, you may have a parent record at sc 阅读全文
posted @ 2013-10-26 16:32 Bryan chen 阅读(379) 评论(0) 推荐(0)
PeopleSoft登录流程
摘要：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 阅读全文
posted @ 2013-10-24 14:42 Bryan chen 阅读(653) 评论(0) 推荐(0)
请注意designer中的NAME field
摘要：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 阅读全文
posted @ 2013-10-24 13:54 Bryan chen 阅读(221) 评论(0) 推荐(0)
subpage和secondary page的区别
摘要：Hi, Can you tell me the differences between subpage and secondary page and when to use which ? I need to display about 100 fields of our custom interface record on 4 different pages or tabs (I want the look just like the page with 3 tabs of "Workforce Admin > Personal Info > Biographical 阅读全文
posted @ 2013-10-24 13:36 Bryan chen 阅读(1046) 评论(0) 推荐(0)
PeopleSoft Related Language Records
摘要：As we all know, PeopleSoft is capable of maintaining application data in multiple languages within the same database. This feature is driven by special records called Related Language Records that store language sensitive information in all required languages other than the base language of the syst 阅读全文
posted @ 2013-10-24 13:27 Bryan chen 阅读(349) 评论(0) 推荐(0)
设置field的背景颜色以及对stylesheet的理解
摘要：今天遇到一个需求：在做页面输入验证的时候，如果用户没有输入某个项，那么这个项显示为红色，一直没头绪，也找peoplebook，发现field有一个style的方法，后来又在谷歌上找，终于找到了方法： Just to check, did you include custom stylesheet in PSSTYLEDEF? That is a key step in order to use any custom style sheet in PeopleCode or anywhere in app designer. This is what I did (a similar requi 阅读全文
posted @ 2013-10-24 13:24 Bryan chen 阅读(8052) 评论(0) 推荐(0)
What is the difference between differed processing mode and interactive mode?
摘要：Every time you access and navigate through the fields on a page in PeopleSoft there are events such as Field Edit, Field Insert, etc... that get triggered.For example if I am on a page and enter a letter in a numeric field, the field edit peoplecode can fire (to check if the value is valid) when I t 阅读全文
posted @ 2013-10-24 13:14 Bryan chen 阅读(1105) 评论(0) 推荐(0)
Hide a Subpage Using PeopleCode
摘要：There was a question asked on the forum on how to hid a subpage. There is no Peoplecode function to hide a subpage directly, BUT one way around that is putting the subpage in a group box and hid the group box instead. Hiding the group box will end up hiding your sub pageMake sure to follow the follo 阅读全文
posted @ 2013-10-24 13:10 Bryan chen 阅读(1573) 评论(0) 推荐(0)
Check Box Select/Deselect All on Grid
摘要：The below function is to be used on a grid with multiple check boxes. Place the code behind a FieldChange event and users will have the option to Select or Deselect grid rows all at once.Function selectAllRows(&rs As Rowset) Local number&i; Local Row&row;For&i=1To&rs.ActiveRowCou 阅读全文
posted @ 2013-10-24 13:07 Bryan chen 阅读(479) 评论(0) 推荐(0)