tag:blogger.com,1999:blog-31281879081340587652011-11-27T15:34:25.236-08:00Another PeopleSoft Tech BlogPSoftTechGuynoreply@blogger.comBlogger111100tag:blogger.com,1999:blog-3128187908134058765.post-31839380932633400792008-08-22T14:22:00.000-07:002008-08-22T14:26:39.892-07:00

Since I wrote the article titled "Running Dynamic SQL Object in PeopleCode" I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. Suppose the requirements is to have a different prompt table depending on

PSoftTechGuynoreply@blogger.com0tag:blogger.com,1999:blog-3128187908134058765.post-52976561985907616302008-07-29T13:38:00.000-07:002008-07-31T10:00:23.629-07:00

Sometimes we to write program that are used for outbound processing, meaning creating files that will be read by other/external programs. Most of the times these files are enormous in size, because they are years or quarters or months worth of data. We need to create a program that are efficient in processing large amount of data. With these in mind, we think of App Engine because its used for

PSoftTechGuynoreply@blogger.com0tag:blogger.com,1999:blog-3128187908134058765.post-39430056288112952362008-06-24T13:38:00.000-07:002008-06-24T13:43:42.497-07:00

This is a request from a friend to post a sample code that calls SQR from PeopleCode.This can be applicable if you need your page or app engine to call an independent SQR process/report. The following example was done in App Engine PeopleCode;Local ProcessRequest &RQST;&sRunCntlId = "Test";&aProcessType = "SQR Report"; /*(or "SQR Process")*/&aProcessName = "MYSQRRPT";&dttmRunDateTime = %Datetime;

PSoftTechGuynoreply@blogger.com1tag:blogger.com,1999:blog-3128187908134058765.post-4516130522516791172008-06-23T13:00:00.000-07:002008-06-23T13:14:04.392-07:00

When coding page PeopleCode, developers uses function SQLExec once or twice, and even more than 10. It looks messy and sometimes you have to deal with lenghty SQL statements. What I have are codes taken from a delivered program that simplify large amount of SQLExec coding (I modified some of it according to my needs). Transfer all SQL statements from peoplecode to SQL objects and named it

PSoftTechGuynoreply@blogger.com0tag:blogger.com,1999:blog-3128187908134058765.post-19689220508314999882008-06-06T12:08:00.000-07:002008-06-23T10:33:03.076-07:00

This is more specific to Student Award Entry Component. Recently, I have a requirement to automate the cancellation of award in the Award Entry page (PeopleSoft Student Administration: Financial Aid). The approach was to make a Component Interface and run it thru App Engine as batch process. In the page there are 4 buttons and 2 of these buttons should be click to validate and post data in the

PSoftTechGuynoreply@blogger.com2tag:blogger.com,1999:blog-3128187908134058765.post-59619326111548712052008-06-02T14:29:00.000-07:002009-05-27T10:51:19.742-07:00

Now, who's up for some ice cream? Yes, you've heard me.. for me Word Document is like an ice cream at least compare to text (.txt) document. Did you know that you can create a formatted word document from PeopleSoft using App Engine/PeopleCode? Just like creating Excel Document (discuss in my previous post Creating MS EXCEL Using CreateObject in PeopleSoft) I used the CreateObject PeopleCode

PSoftTechGuynoreply@blogger.com1tag:blogger.com,1999:blog-3128187908134058765.post-62905217630581295462008-06-02T08:19:00.000-07:002009-05-27T10:51:10.156-07:00

Application Engine is great for batch processing, but it is not a reporting tool. Recently, our users requires every single AE to have a formatted output report, so my teammate came up with the solution that writes .txt file using writeline function. Its very simple, you just need to code it manually. Getting bored of the text file that comes out on my report, I look for some other ways to create

PSoftTechGuynoreply@blogger.com3tag:blogger.com,1999:blog-3128187908134058765.post-38067479165411126842008-05-31T11:12:00.000-07:002009-05-27T10:49:55.634-07:00

Haven't you notice that every posts up to this point are XML Publisher related? I just can get enough of this tools, i like discovering what this tool can do for me as a developer. If using Rowset Data Source in XMLP was too complicated for you, try using the PS Query as the Data Source. You don't need to create a code for sample data file and schema file because you can generate those files

PSoftTechGuynoreply@blogger.com3tag:blogger.com,1999:blog-3128187908134058765.post-75532148904961499472008-05-30T20:09:00.000-07:002009-05-27T10:49:32.895-07:00

Our understanding of XML Publisher are getting broader. There are a lot that you can do with this tool, I decided to incorporate the email functionality of PeopleSoft with the XML Publisher. How would you like if the batch that produced report output last night can be emailed to you automatically? I know a lot of people would love that!With our knowledge on how to code XMLP report, we will just

PSoftTechGuynoreply@blogger.com1tag:blogger.com,1999:blog-3128187908134058765.post-28971115080263323772008-05-30T08:55:00.000-07:002009-05-27T10:47:19.275-07:00

I hope you enjoy the first part XML Publisher Part 1!!! This time we will bring XML Publisher one step up. We will use Application Engine, PeopleCode and XMLP together to produce a nice looking batch report. The concept are like SQR, retrieving data from database via SQL SELECT, formating data and displaying data to a report usually in the form of PDF, CSV, etc. In order to retrieve data using

PSoftTechGuynoreply@blogger.com26tag:blogger.com,1999:blog-3128187908134058765.post-1409664262766936232008-05-30T05:46:00.000-07:002009-05-27T10:45:59.134-07:00

Probably y'all aware that the XML Publisher is the new reporting tools of PeopleSoft (version 8.9 and higher). I once read that this is the only reporting platform for Fusion Apps. The cool things about this are you only have single toolset, user can create their own layout, upgradable to Fusion, flexible, quick and easy. How does it work? By combining the Technical Task which is XML DataSource

PSoftTechGuynoreply@blogger.com0