Blog

Query Tip: Updating the Effective Dates of In-Tree Criteria

Created on Tuesday, 22 June 2010 18:24
Written by Larry Grey
  One limitation of PeopleSoft Query is that when you use "In Tree" criteria, the effective date of the tree is forever stored in that criteria. When reading through the release value proposition of PeopleTools 8.5, I was thinking that feature to dynamicall prompt tree-nodes at run-time was going to also address this limitation. Alas, that was not the case. Fortunately, through a little bit of PeopleCode, this can be rectified relatively easily. Cool. Show me the stuff I decided to implement this using application engine, since most organizations would want to update…

Read more...

Generating Query SQL from App Engine

Created on Wednesday, 16 June 2010 18:36
Written by Larry Grey
How often has your DBA wanted to be able to quickly get a set of files containing the SQL of commonly run queries? Perhaps you'd like to make sure you version that SQL to make sure that you can see how it changes over time. With a little PeopleCode, you can do this pretty easily. Take a look at what you can get when you version your query SQL. Pretty cool, right? Yeah... How'd you do it? Well, let me walk you through it one step at a time. Otherwise, the PeopleCode…

Read more...

The PeopleSoft/IBM backstory

Created on Tuesday, 06 April 2010 18:49
Written by Chris Heller
I was having some beers at Pleasaton's (in)famous Hopyard last night and the topic of IBM and PeopleSoft came up. Specifically in the context of the announcement at the last PeopleSoft Connect conference about how we (PeopleSoft) were going to start heavily using the IBM WebSphere technology stack. Since I also had a regular blog reader come up and harass me at the table about a lack of blog entries this year, I figured that this would be a good one to write-up. Besides, it's been awhile since we've …

Read more...

Java PeopleSoft

Created on Sunday, 21 February 2010 20:45
Written by Chris Heller
You already knew that Java was going to be an important skill for your PeopleSoft developers since its the underlying technology for Oracle Fusion, but now that Oracle owns Java, it's even more important. In support of that, we here at Grey Sparling have scheduled some webinars on using Java with your existing PeopleSoft applications. As is always the case with our webinars and conference presentations, these will be very hands on, demo-intensive sessions. Check our events page for which dates and times would work best for you. Labels: 2010, Java, webinar

Read more...

Diff/Merge Page in PeopleSoft Application Designer

Created on Friday, 01 January 2010 21:36
Written by Chris Heller
Visual page diff/merge was one of the cool new features added back in PeopleTools 8.48. Visual page diff/merge lets you see two instances of the same page definition side by side and step through the differences visually. It's a huge improvement over just seeing the page field attributes in the classic PeopleTools compare reports.We've recently added native support in our Version Control for PeopleSoft product to support this, but the last few people that we have shown our integration work to weren't even aware that Application Designer even had this functionality this at all. …

Read more...

News Archives

Recent Comments

Tags

2007 2008 2009 2010 drilling email events java mobile nvision openworld peoplecode process_scheduler products query reporting security support sysadmin telephony testing upgrade versioncontrol webinar

Get in Touch

This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

+1 925-217-1298 x 201

Oracle Partner

© 2011 Grey Sparling Solutions.
All rights reserved.