PeopleTools Grid Controls and Subpages

I had the situation today where I needed to change the column header in a grid on a subpage via PeopleCode. I tried adding the following to the PageActivate PeopleCode on the subpage:

GetGrid(Page.PS_Subpage, "GridName").ColumnName.Label = "MyNewColumnName";

I kept receiving an error that the grid could not be found on the page. I thought that was interesting, double-checked my code to verify that I didn't have any typos and tried again. Same error. It then occurred to me that maybe the processor doesn't interpret subpages as a different page object. I changed my code to reference the page that was hosting the subpage...

GetGrid(Page.PS_HostPage, "GridName(from subpage)").ColumnName.Label = "MyNewColumnName";

... and my code started working.

We still have the 8.46 toolset, so this might not be an issue with newer versions of PeopleTools.

PeopleTools: How-To rename table names on a page via SQL

I have frequently run into the situation when cloning a page where you want to rename a table on a page, but want to keep all field properties the same (ie, custom label, fieldname, etc.). In PeopleTools, when you change the record name on a field, all of the properties get wiped out, so you end up doing a lot of unnecessary cutting and pasting to reset all of the properties. A better way of doing this is to just update the page record directly via SQL:

update pspnlfield set recname = :newrec where pnlname = :pagename and recname = oldrec;

CommunityOne 2008 Recap

This was one of the best conferences I have ever attended. I am very interested in open-source software (for a myriad of reasons) and this conference was almost completely about open-source. The keynote from Ian Murdock covered both the business and philosophical aspects of open-source software. I found the keynote very enlightening and enjoyable. If you would like to watch the videos from the opening keynote, they are available here.

At best, I consider myself a Netbeans n00b, so all of the Netbeans sessions were really cool and very informative. I haven't seen all of the bells and whistles of Netbeans. We went to several of the Netbeans sessions.

I also attended sessions on OpenESB/BPEL,Ubuntu and Web Services with Glassfish. All very cool to see what is possible with all of this open source software that is available.

I was telling John Wa (other author on this blog) that I got the same feeling of excitement from this conference I used to get while I was in college, going to big shows like Comdex. You see all of the possibilities and it inspires and excites you, making you want to get home and try some of it out. I well definitely make every attempt to attend next year.

Best Practice Center: PeopleSoft and Oracle Fusion Middleware

Here is a link to a site that Oracle recently brought up regarding best practices for integrating PeopleSoft and Oracle Fusion Middleware:

http://www.oracle.com/technology/tech/fmw4apps/peoplesoft/index.html?msgid=6476729

Saving images out of an ODF (OpenOffice) Document

We recently had the need to extract some images out of a functional specification document that we received. In OpenOffice, when you right-click on an image, there is no option to "Save Image to File". In order to pull the images of the document, you need to save the document in the ODF (native OpenOffice) format. Open your favorite decompression tool (7-zip is our fav) and open the ODF file. When you open the file in your decompression tool, you will notice several folders, one of which is "Images". This is the folder that stores all of your images from your document.

Pre-JavaOne 2008 Conference: CommunityOne

Gary, John and I are heading up to San Francisco on Monday for the CommunityOne conference. I plan on blogging more about it Tuesday when we get back to the office. If you are planning on attending, drop a comment on this post.

PeopleTools 8.46 and Microsoft Windows Vista SP1

As luck would have it, my Windows XP drive took a dive earlier this week. Rather than wasting a lot of time figuring out what the problem is, I thought it would be better to put my Windows Vista drive back into my laptop and keep working. I built a disk image of Windows Vista Enterprise a couple of months ago, but switched back to Windows XP around the end of January (for no reason... really...). With all of the recent hoopla about Service Pack 1 for Windows Vista, I thought it was a good time to give it another shot. I loaded the drive back into the laptop, fired it up, got all of the Windows Updates (20+), all of my open-source software was updated (Notepad++, Firefox, WinMerge, Tortoise SVN, Filezilla all had multiple releases since the end of January) and then I did Service Pack 1. It loaded without error, though the suggested load time message from Microsoft of an hour plus was more like 2 hours plus.

We are still running PeopleTools 8.46 here and yes, I know 8.46 is not officially supported by Oracle on Windows Vista. That being said, I haven't run into any problems running 8.46 on Vista. There are the occasional crashes, which aren't any more or less frequent than they are in Windows XP. One thing I have noticed though since Vista SP1 is that the PeopleSoft Query window in two-tier (I am old-school and like the two-tier query interface) keeps crashing with a "Out Of Memory" error. I have checked each time and I still have about 900 megs of physical memory left, but the error is still showing up.

Not that this is a huge issue, just wanted to document it somewhere. I might be the only person on the planet trying to write a query on PeopleTools 8.46 in two-tier mode on Windows Vista SP1. If there is someone else out there with the same issue, you are not alone... ;-)

Jonathan Coulton

This is quasi-technical.

I am sure I am late to the party on this (as usual) but Yahoo ran a story on Monday about Jonathan Coulton that caught my eye. Interesting story about him that I won't rehash here. I went to his site and listened to a couple of his tunes. Very entertaining. If you are a developer, check out the "Code Monkey" tune.

Oracle Mix Idea

Good morning and Happy New Year (I can say that in this late February post as I am the first person from our team to post in 2008). Last week I posted an idea on Oracle Mix (a very cool new Oracle site brought to you by the geniuses at Oracle Appslab) regarding converting Application Designer to a Java-based tool. App Designer is currently a Win32 app, requiring MS Windows. I would love to tell you I had great, altruistic means for the post, but truth be told, I just want to run App Designer in Linux. And I am sure that I am not the only one. I am sure there are several kindred spirits out there running Mac and Linux boxes that have at one time or another also wished App Designer was cross-platform.

IMHO, making App Designer platform independent is a good business move. Having an IDE where the customer can decide what platform they want to run it on is a good thing. A company that is not necessarily a Windows shop wouldn't have to sink the extra cash on a virtualization solution or purchase unnecessary extra machines.

Anyway, my $02. If you want to vote on my Mix idea, the url is: https://mix.oracle.com/ideas/18401-make-peoplesoft-application-designer-java-based-and-platform-independent

Thunderbird IMAP and attachment issues

We setup the scanner portion of our office printer/scanner/fax machine today. Upon scanning, the printer/scanner/fax images the document, saves it as a PDF and emails out to whomever you picked to send the image to. I received the PDF in my email in my client of choice, Thunderbird (version 2.0.0.9 (20071031) using IMAP) and when attempting to open it, received the following error message from Adobe Acrobat reader:

"The was an error opening this document. The file is damaged and could not be repaired"

I downloaded an alternative Win32 PDF reader, Foxit Reader, and gave that a shot, only to receive a similar message. I contacted a colleague who also received the test message to find out she was able to open the PDF with no issues using Outlook. With that info, I went to my webmail client and was able to open the PDF file with no issue. So the problem was with Thunderbird.

After a quick Google search, I found several postings from other folks with a similar predicament, mostly from attempting to hook Thunderbird to the new released Gmail IMAP ports. I came across the following nugget of information which immediately corrected my problem....

Original source thread

In the "about:config" section of Thunderbird (Tools > Options > Advanced > Config Editor) look for the "mail.imap.fetch_by_chunks" and " mail.server.default.fetch_by_chunks" values and set them to "False".

Mozillazine gives some more information about what this value actually does here

Oracle Mix

Saw on the Oracle AppsLab blog a reference to Oracle Mix. I signed right up because I like the direction Oracle is taking with trying to encourage and foster a tighter sense of community among itself and its users. I am hoping this is one step closer to creating an environment where the community (especially on the apps side) can share and contribute projects openly (i.e., sourceforge).

So if you are interested, invite me to join your group in the Mix.

http://mix.oracle.com

OpenWorld 2007 - Day 0

Great day for a drive to San Francisco. Joe took me detour past the old Oracle headquarters in Belmont on Davis Drive where he used to work.

Check-in was a breeze cause we are alum. Oracle doesn't give out much swag at all, go we got the usual book bag, notepad, umbrella and various adverts.

We made it to the keynote at 5:45PM to hear Larry recount the history of Oracle. He even showed a pic of the old offices in Belmont (the ones we toured earlier in the day). Some of the ex-cast of Saturday Night Live (Kevin Nealon, Darrell Hammond, and I can't remember the other one) where there to add some humor to the mix.

The reception after the keynote had the usual food and drink.

Up tomorrow...

08:30-10:15 - Keynote Charles Phillips
11:00-12:00 - Intro to Oracle BI Publisher
12:30-13:30 - Oracle SOA Suite Best Practices
14:00-14:45 - Keynote ?
15:15-16:15 - Highlights of Agile PLM
16:45-17:45 - Ready, Set, XML - Using Oracle XML Data
18:00-19:00 - Keynote ?
19:30- - OTN Night