2008 年 8月 11 日随笔档案 - Kevin's Blogy

Find Navigation of Page from Component Name

摘要： Many times we came across situation where we have Page name but we dont know the navigation for this page in Portal. Following SQL makes the job easy for us. Execute the following SQL in Database. SE... 阅读全文

posted @ 2008-08-11 17:03 Kevin's Blogy 阅读(256) 评论(0) 推荐(0)

Oracle Group By Grouping Sets

摘要： So, what if you are only interested in totals. Well, Oracle does provide an extension to the GROUP BY clause called GROUPING SETS that you can use to generate summary information at the level you choo... 阅读全文

posted @ 2008-08-11 16:28 Kevin's Blogy 阅读(684) 评论(0) 推荐(0)

Oracle Group By ROLLUP-SubTotal

摘要： At normal time, you may want to have the subtotal for each region over all months, along with the total for all regions, or you may want the subtotal for each month over all regions, along with the to... 阅读全文

posted @ 2008-08-11 16:23 Kevin's Blogy 阅读(997) 评论(0) 推荐(0)

PeopleSoft PeopleTools Meta-Tables

摘要： This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel f... 阅读全文

posted @ 2008-08-11 15:59 Kevin's Blogy 阅读(994) 评论(0) 推荐(0)

Security Tables

摘要： PSOPRDEFN - UserIds created. PSCLASSDEFN - Permission List definition. PSROLEDEFN - Role Definition table PSAUTHITEM - Menus, Components and Pages attached to a permission list. PSROLEUSER - Contains ... 阅读全文

posted @ 2008-08-11 15:57 Kevin's Blogy 阅读(217) 评论(0) 推荐(0)

Unlock PeopleSoft Objects All at Once

摘要： Change control is used in Application Designer to lock definitions and track history changes for each object. Change control can be activated through Application Designer using Tools > Change Control ... 阅读全文

posted @ 2008-08-11 15:26 Kevin's Blogy 阅读(237) 评论(0) 推荐(0)

Migration: Find Duplicate Objects in Application Desinger Projects

摘要： 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... 阅读全文

posted @ 2008-08-11 15:21 Kevin's Blogy 阅读(262) 评论(0) 推荐(0)

Trace Application Engine Processes Using Process Definitions

摘要： In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file. Navigate to th... 阅读全文

posted @ 2008-08-11 15:18 Kevin's Blogy 阅读(273) 评论(0) 推荐(0)

Dynamic View and Drop Down Menu

摘要： This was kind of interesting to figure out. What I was going after is the following. I had a drop down box on a page that shows some Business Units. The values however need to be dynamic and change de... 阅读全文

posted @ 2008-08-11 15:13 Kevin's Blogy 阅读(313) 评论(0) 推荐(0)

Decode()函数使用技巧

摘要： decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)该函数的含义如下：IF 条件=值1 THEN　　　　RETURN(翻译值1)ELSIF 条件=值2 THEN　　　　RETURN(翻译值2)　　　　......ELSIF 条件=值n THEN　　　　RETURN(翻译值n)ELSE　　　　RETURN(缺省值)END IF· 使用方法：1、比较大小sele... 阅读全文

posted @ 2008-08-11 13:50 Kevin's Blogy 阅读(390) 评论(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. Fucntion s... 阅读全文

posted @ 2008-08-11 09:23 Kevin's Blogy 阅读(430) 评论(0) 推荐(0)

2008年8月11日