摘要： The ReUse in Application Engine was brought to my attention by a great blog that I follow regularly. The original post can be found at http://peoplesofttipster.com/2007/07/31/reuse-in-app-engines/. ... 阅读全文

摘要： Deleting files sitting on a server using PeopleCode is one thing I'm sure you will be doing sometime during your PeopleSoft career. The code below should help you out and get you started! /*The path ... 阅读全文

摘要： SearchSave PeopleCode is performed after the user clicks the Search button or the Add button on the search page. User SearchSave to validate values entered in the search page fields. Place S... 阅读全文

摘要： This code should be helpful if you are trying to hide a grid column using PeopleCode To hide a column in a grid (using the Grid and GridColumn objects). You no longer must loop through every row in t... 阅读全文

摘要： Sometimes users click the "+" on the grid to enter data but end up clicking it more than once and getting some extra empty rows in the gird. The peopleCode to get rid of any extra empty grid rows when... 阅读全文

摘要： The PeopleCode below will show you how to call an Application Engine from PeopleCode. Some refer to this as “Real-Time Application Engine Processing.” For example, when a user save’s a page, you may w... 阅读全文

摘要： Here is a good sample of how to launch an SQR from within PeopleCode. You can use the peoplecode function called “ScheduleProcess”. Here is the example: &PROCESS_NAME = "SQRNAME"; &PROCESS_TYPE = "SQ... 阅读全文

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