摘要：
1. Component Permission List Query:This query identify the permission lists and its description associated with component.SELECT menu.menuname, compdfn.pnlgrpname, auth.classid permission_list,CLASS.classdefndesc permission_descFROM psauthitem auth,psmenudefn menu,psmenuitem menuitm,pspnlgroup comp, 阅读全文
摘要：
The sql will identify duplicate objects in different application designer projects to eliminate duplicate work by developers.You will find the SQL very handy during the analysis phase of a peoplesoft upgrade project. You1st need to identify your projects and run compare and report through applicatio 阅读全文
摘要：
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 阅读全文
摘要：
ProjectsPSPROJECTDEFN — Project header tablePSPROJECTITEM — Definitions in the projectFieldsPSDBFIELD — Fields in the systemPSXLATITEM — Translate ValuesRecordsPSRECDEFN — Record header tablePSRECFIELD — Fields in the record (subrecords not expanded)PSRECFIELDALL — Fields in the record (subrecords e 阅读全文
摘要：
Oracle模糊查询应该如何实现呢？下面就教您一个实现Oracle模糊查询的方法，如果您在Oracle模糊查询方面遇到问题，不妨一看。在Where子句中，可以对datetime、char、varchar字段类型的列用Like子句配合通配符选取那些“很像...”的数据记录，以下是可使用的通配符：% 零或者多个字符_ 单一任何字符（下划线）\ 特殊字符[] 在某一范围内的字符，如[0-9]或者[aeth][^] 不在某范围内的字符，如[^0-9]或者[^aeth]其中关于条件，SQL提供了四种匹配模式：1，%：表示任意0个或多个字符。可匹配任意类型和长度的字符，有些情况下若是中文，请使用两个百分号 阅读全文
摘要：
#方法一：使用 not in ,容易理解,效率低 ~执行时间为：1.395秒~SELECT COUNT(1) FROM ecs_goods WHERE ecs_goods.goods_id NOT IN (SELECT ecs_member_price.goods_id FROM ecs_member_price);#方法二：使用 left join...on... , "B.IDisnull" 表示左连接之后在B.ID 字段为 null的记录 ~执行时间：0.739秒~SELECT COUNT(1) FROM ecs_goods LEFT JOIN ecs_member_ 阅读全文
摘要：
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 阅读全文
摘要：
今天主要分析下oracle服务进程如何处理用户进程的请求oracle服务进程如何处理用户进程的请求服务器进程在完成用户进程的请求过程中，主要完成如下7个任务：0.sql语句的解析1.数据块的读入db buffer2.记日志3.为事务建立回滚段4.本事务修改数据块5.放入dirty list6.用户commit或rollback0.sql语句的解析下面要讲oracle服务器进程如可处理用户进程的请求，当一用户进程提交一个sql时：update temp set a=a*2；首先oracle服务器进程从用户进程把信息接收到后，在PGA中就要此进程分配所需内存，存储相关的信息，如在会话内存存储相关的 阅读全文
摘要：
oracle更新语法：1.一般语法 update tab set col = .... [where ...] =后可以有子查询，但是必须对于tab的每一列返回唯一一行与之对应，where是需要更新的表，部分更新必须加，否则相关子查询的更新会把没有匹配的更新为null,如update tab a set a.col=(select b.col from b where a.id=b.id) where exists (select 1 from b where a.id=b.id) 类似地写了多遍2.改进语法mergemerge into tabusing (表|视图|子查询等)--子查询需要 阅读全文
摘要：
PeopleSoft Excel to CI is an Excel based utility delivered by PeopleSoft to import data from an Excel spreadsheet into PeopleSoft records. Since it uses a Component Interface (CI), all validations are done on the data being uploaded.Excel to CI uses macros in Excel extensively. So the macro security 阅读全文
摘要：
This FAQ is to assist in troubleshooting problems you might have while creating and programming PeopleCode with component interfaces.Remember the most important tip with component interfaces:Component Interfaces mimic component logic.Errors in the component will be replicated in the component interf 阅读全文
摘要：
在APP Engine的运行机制中，默认是从Main Section开始，根据内在的Step排列，从上往下执行的。这种机制能满足我们大多数的工作，但是面对比较复杂的逻辑时，顺序执行就会显得有些苍白无力，这时我们就可以在peoplecode中根据我们的逻辑需求，动态调用section来满足我们的逻辑了。 在我们的AppEngine中，有如下几个Section,在Main Section中，添加If Else逻辑，即如果有银行账户，则用银行打款（call GIRO_CHK Section）的方式，否则就用支票付款(Call CXP_CHK Section)的方式。 首先，在该Applicati.. 阅读全文
摘要：
由于临时表涉及到实例，所以在取临时表名的时候要用meta-sql：%table()。本以为%table()只能在SQL 类型的ACTION中使用，其实这是错的，在peoplecode action中要使用临时表名是，例如SQLEXEC()中： SQLExec("SELECT EMPLID,KL_PUNCH_TIME,KL_ATDN_MCHN_NUM FROM %table(KL_PNCH_TMP)")，直接在引号中使用即可，AE在执行的时候，会自动识别meta-SQL，并转换，同理%bind（）也是一样的。 阅读全文
摘要：
昨天在RUN一个process的时候，发现一直重复出错，tracefile信息也没有什么有意义的提示，仔细研究了一下，发现原来是在第一次出错以后，系统把出错信息记录在PS_AERUNCONTROL了，这样当下次用同样的ID和同样的Control ID运行的时候，他会重这个表里面去比较，因而总是得到同样的出错信息。要解决这个问题，只需要将这个表的相应记录删除就可以了。 在db2中执行一下sql语句：delete from PS_AERUNCONTROL where oprid='MyID' and run_cntl_id=‘MyCntlID’ 重新执行该process，即可运行正 阅读全文
摘要：
After reading thisarticleabout how the PSAESRV process scheduler service was failing due to someone setting trace options on an application engine process but using override instead of append in the parameter list, I thought it might be a good idea to write a query that checks all process definition 阅读全文
摘要：
Exit(0) – Terminates thecurrentPeopleCodeActionin application engine.Exit(1) – Terminates thecurrent Stepin application engine. 阅读全文
摘要：
If you get the following messaging stating that you areNot Authorized to run process typefollowed by the process type (e.g. application engine, SQR, COBOL etc) it means that your user profile does not have a permission list that has access to the process group for the relevant process definition.For 阅读全文
摘要：
%ProcessInstance - To get the PROCESS_INSTANCE%OperatorId - To get the Operator Id i.e UserId%RUNCONTROL - To get the RuncontrolId 阅读全文
摘要：
With SQR, you were always limited to writing CSV files, unless you had some sort of overpriced third party app you could call.Well, with App Engine (and more specifically using a PeopleCode action in App Engine) you can create Excel files via the Microsoft Excel COM object, as long as the process sc 阅读全文
摘要：
This article gives a quick overview of the structure of the PS_HOME directory on a typical PeopleSoft file server. Noteyoursmay be slightly different! There are some folders that I'm not really sure about. If you you know what they might be for, please add your comments.Directoriesappserv- appli 阅读全文