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