Blog

: Created on Monday, 23 August 2010 17:52; Written by Chris Heller

One of the projects that we have hosted on Code.GreySparling is a very cool way to work with PeopleSoft Component Interfaces. If you do any sort of testing or data loading or Component Interface development with PeopleSoft applications, then this is for you. What's a Component Interface? For those that haven't worked with Component Interfaces before, they provide programmatic access to PeopleSoft components and are used extensively within PeopleSoft applications as well as providing the underlying mechanisms for PeopleSoft Web Services. When you see Oracle Fusion in action at OpenWorld this year and…

Comments (2)

: Created on Saturday, 21 August 2010 17:59; Written by Chris Heller

Dave Kurtz has a nice writeup over at OakTable.net on using App Engine meta-sql to add hints to dynamically generated SQL. I missed it when it was first published back in March, but it just came in handy for me. Thanks Dave! Labels: 2010, AppEngine, Performance, sql

Add your comment

: Created on Friday, 24 July 2009 17:48; Written by Larry Grey

System Availability. This is a very important topic, that has received a lot of attention, especially in the area of handling system failover, redundancy, and disaster recovery. This is obviously and important topic, but for most organizations, represents the smallest fraction of system outages with their PeopleSoft applications. It is the planned outages where an organization needs to kick people off the system to perform system administration functions that represents the majority of downtime for most PeopleSoft environments, and the one area that we will discuss in more detail…

Add your comment

: Created on Friday, 09 July 2010 18:02; Written by Larry Grey

This is an update to our Editing Enhancements for PeopleCode and SQR blog entry, and was covered in one of our recent webinars for learning to be an expert in PeopleSoft. One of the things you'll notice if you go through a PeopleCode trace is that there's way too much detail if you're trying to learn what's going on under the covers. We've found that if you can navigate to the page you want to learn about, turn on tracing, perform a few actions, and then review the trace, you'll pick it up a lot…

Comments (7)

: Created on Thursday, 24 June 2010 18:14; Written by Larry Grey

One of the biggest challenges of end-users is to figure out where the data they want to query against resides. This is yet another tip from our "Advanced Query Tips and Techniques" webinar. By combining the PeopleCode Query Classes with knowledge of the PeopleTools tables underlying the component definition, you can provide a page that allows queries to be easily created. Getting the Records to put in the Query Probably the most important part of this is to figure out what records are in a component (and then subsequently weeding out the extraneous…

Add your comment

Page 9 of 52

News Archives

► 2012
- ► February
  - • 06 - Operational Excellence in PeopleSoft Self Service Video Available
- ► January
  - • 30 - What's New in PeopleTools 8.52 - Video Available
  - • 23 - Getting Started in PeopleSoft Mobile YouTube Video
  - • 12 - JQuery Mobile test lab
  - • 11 - UK and EU customer visits
  - • 09 - Drilling URLs and Pagelet WIzard
► 2011
- ► December
  - • 29 - Mobile Implementation Considerations for PeopleSoft
- ► September
  - • 16 - HEUG forum post from TCU about our Mobile solution
  - • 08 - BI Publisher versus PeopleSoft XML Publisher
  - • 08 - Best Practices in XML Publisher Reporting
  - • 05 - Advanced nVision tips and techniques
  - • 05 - Best Practices in implementing PeopleSoft Self Service
  - • 05 - The Lane County Single Signon Story
  - • 05 - Taming Change - The University of Western Ontario's change management journey
  - • 04 - Amazon.com redesigns its website around mobile
- ► July
  - • 09 - Featured Vendor - Illinois Technology Association
  - • 24 - Kerberos tickets at login time on Mac OS X
  - • 29 - Mobile for PeopleSoft
- ► June
- ► May
  - • 26 - Chicago Office Opens
  - • 26 - HIUG Interact conference 2011
- ► March
  - • 04 - Navigation Changes in PeopleTools 8.51
  - • 10 - Powerpoint from Development Best Practices Webinar
  - • 21 - PS/nVision is not configured properly on this workstation
  - • 23 - HEUG Alliance 2011
  - • 23 - PeopleSoft Test Framework Tables
- ► February
  - • 01 - QVC Chooses Grey Sparling for Version Control
  - • 02 - Grey Sparling is Hiring - Solutions Architect
  - • 23 - Oracle Customer Advisory Board meeting
► 2010
- ► October
  - • 01 - PeopleSoft Testing Framework - Supply Chain (Inventory, Purchasing, Procurement, and Payables)
  - • 13 - Introducing Automatic URL Shortening for your PeopleSoft URLs (automatic bit.ly or TinyURL for PeopleSoft)
- ► September
  - • 03 - Tuxedo Listening on Multiple IP addresses
  - • 10 - PeopleTools 8.51 Initial Impressions
  - • 14 - Your security options are set improperly. Please contact your security administrator.
  - • 20 - Advanced PeopleSoft Security Audit - OpenWorld 2010
  - • 20 - PeopleSoft Enterprise Release 9.1 Adoption and Roadmap
- ► August
  - • 21 - Adding Hints to Dynamically Generated App Engine SQL
  - • 23 - PeopleSoft Component Interface Testing Tools
- ► July
  - • 09 - Syntax Highlighting for PeopleSoft SQL Traces
- ► June
- ► April
  - • 06 - The PeopleSoft/IBM backstory
- ► March
  - • 10 - Please don't mirror the site every 5 seconds
- ► February
  - • 21 - Java PeopleSoft
- ► January
  - • 01 - Diff/Merge Page in PeopleSoft Application Designer
► 2009
- ► December
  - • 10 - Related Content Feature in PeopleTools 8.5
- ► November
  - • 08 - Application Designer on Linux
- ► October
  - • 12 - OpenWorld 09 - PeopleSoft Upgrades - A Customer's Perspective
  - • 12 - OpenWorld 09 - PeopleSoft 9.1 Overview / Keynote
  - • 13 - OpenWorld 09 - Oracle Enterprise Manager with PeopleSoft
  - • 13 - OpenWorld 09 PeopleSoft 9.1 Financials Overview
  - • 13 - OpenWorld 09 PeopleTools 8.5 Customer Perspective
  - • 25 - In Depth - PeopleTools 8.50 RSS Feed Publishing Framework
- ► September
  - • 21 - PeopleTools 8.50 RSS Feed Publishing Framework
- ► August
  - • 04 - PeopleTools on Vista
  - • 05 - Sun Continuous Integration Server (aka Hudson
  - • 10 - Oracle JDeveloper 11gR1 with PeopleSoft
  - • 11 - Oracle JDeveloper 11gR1 with PeopleSoft - part 2
  - • 24 - Protecting PeopleSoft against "Real-Time" Secure ID Snatching
  - • 27 - Figuring out where your Financial Data came from
- ► July
  - • 08 - Using PeopleSoft Performance Monitor
  - • 24 - Increasing System Availability with PeopleSoft
- ► June
  - • 28 - Security Issues With PeopleSoft Production Refreshes
  - • 22 - Automating Forced Windows Logout for Kiosks
- ► May
  - • 02 - PeopleSoft Test Automation
  - • 10 - Functional Testing of PeopleSoft Applications
  - • 19 - PeopleCode Unicode Variable Names
  - • 29 - Multiple field nPlosion for Peoplesoft nVision
- ► April
  - • 02 - Testing PeopleSoft LDAP integration with Active Directory
  - • 02 - New Webinars Posted
  - • 02 - Getting more from MetaLink (soon to be "My Oracle Support")
  - • 15 - PeopleTools Patches
  - • 25 - IBM's Oracle emulation
  - • 26 - Issues with Dynamic Roles in PeopleSoft
  - • 29 - Oracle VM Templates for PeopleSoft Now Available
- ► March
  - • 03 - PeopleCode Editor Shortcuts
  - • 10 - Emailing Scheduled PS/Query Results
  - • 10 - Version Control for PeopleSoft demo
  - • 17 - Una historia de PeopleTools
  - • 21 - ActiveDirectory and PeopleCode integration
  - • 25 - Introducing Code.GreySparling.com
- ► February
  - • 03 - Remote access to PSADMIN
  - • 04 - One time passwords
  - • 05 - Keystroke loggers
  - • 07 - Fixing PeopleSoft Workflow Email Notifications
  - • 07 - Charles Phillips named to economic recovery board
  - • 15 - Out of Available Memory error running Application Engine
  - • 20 - Grey Sparling "PeopleSoft Experts" Webinar Series
  - • 23 - New Webinar: Social Networking with your PeopleSoft Application
  - • 23 - New Webinar: Advanced Troubleshooting for your PeopleSoft Environment
  - • 23 - New Webinar: Meet the Experts Virtual Open Roundtable
  - • 23 - New Webinar: What you should know about the PeopleSoft Ecosystem
- ► January
  - • 22 - Which PeopleSoft system am I working in?
  - • 26 - Taking control of your build files
► 2008
- ► November
  - • 14 - Overlapping Text in PeopleSoft and Safari 3.x
- ► September
  - • 04 - Initial Testing with PeopleSoft using the Chrome browser
  - • 06 - One in a million
  - • 11 - Workday slowly following the PeopleSoft path
  - • 15 - Helping our friends in the Financial Services Industry
  - • 22 - LDAP Query Syntax Tips
  - • 28 - OpenWorld Wrap-up
- ► August
  - • 01 - Getting better Control of your reports.
  - • 09 - Oracle Virtual Machine Templates
  - • 19 - Correction on 2007 Open World session writeup
- ► July
  - • 06 - PeopleSoft IVR Integration the easy way
  - • 07 - PeopleSoft telephony two factor authentication
  - • 08 - nVision using Queries intricacies
  - • 11 - Tightening Data Security in your PeopleSoft Environment
  - • 21 - OpenWorld sessions from Oracle Mix voting winners announced
- ► May
  - • 20 - 2008 PHRUG Wrap-Up
- ► April
  - • 09 - Reporting against multiple Setids in PeopleSoft
  - • 11 - Firewall Product as Savior
  - • 13 - Collaborate 2008
  - • 15 - International Rollouts of PeopleSoft - Do's and Don'ts
  - • 15 - Strengthening Data Privacy in PeopleSoft
  - • 23 - Enterprise RSS Day
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 2 - E40790- PeopleSoft Executive Update with Doris Wong
- ► March
  - • 28 - Setting Report Retention Limits dynamically for Report Manager
  - • 07 - Grey Sparling 2008 Spring Events
  - • 14 - Can you use Winter or Node-Oriented Trees in GL?
  - • 13 - Baby steps with Reporting against PeopleSoft
  - • 12 - Code Escrow 2.0
  - • 17 - Links not Automatically Opening a Page
  - • 20 - Creating a Shortcut to Opening a Query in Windows Query
  - • 26 - Client/Server Single Signon for PeopleSoft
- ► February
  - • 14 - Using Instant Messaging to Enrich PeopleSoft
  - • 19 - Ramifications of Annoying your co-workers in a call center...
  - • 29 - Using Flash for End-User Training
- ► January
  - • 09 - Silly Blog Games
  - • 09 - Upgrading to Fusion
  - • 24 - Helpdesk support in the middle ages
► 2007
- ► December
  - • 05 - "More Advanced Reporting Tips and Techniques for PeopleSofft Enterprise" powerpoint
- ► November
- ► October
  - • 08 - What does SAP's Acquisition of Business Objects Mean?
  - • 10 - Opening up a Performance or Development Document from a URL
  - • 11 - Re-Posted yesterday's item.
  - • 12 - BEA acquisition impact for PeopleSoft customers?
  - • 23 - Looks like someone didn't implement workflow for approving vendor payment changes.
  - • 25 - A Better Way to Manage PeopleSoft Windows Services
- ► September
  - • 21 - Creating Optional Parameters for a PeopleSoft page
  - • 21 - Drilling Deeper into PeopleSoft Pages
  - • 24 - Code to Drill to any Chartfield Combination on Journal Entry Page
  - • 25 - Insatiable Application Classes
  - • 26 - Security Zone Management in Internet Explorer
- ► July
  - • 09 - Grey Sparling Excel Add-in for PeopleSoft
  - • 19 - The Good, Bad, and Ugly of our Niche...Part 1
  - • 23 - The Good, Bad, and Ugly of our Niche... Part 2
  - • 26 - The Good, Bad, and Ugly of our Niche... Part 3
- ► June
  - • 04 - Upcoming Events
- ► May
  - • 13 - History of Tree Manager
  - • 14 - Advanced VBA Hooks in nVision
  - • 15 - Post-processing Query output in Excel
  - • 24 - A Brief History of PeopleTools 9
- ► March
  - • 16 - Query and nVision Reporting in Student Admin
  - • 16 - Financials Objects for Drilling Demos
  - • 16 - Alliance Conference 2007 Wrap-Up
  - • 20 - Alliance 2007 Session Evaluations
- ► January
  - • 02 - Grey Sparling 2006 In Review
  - • 09 - Query and nVision Reporting in HCM
  - • 10 - Flash Demo of HCM ReportingFlash Demo of HCM Reporting
  - • 12 - January through March Grey Sparling Events
► 2006
- ► November
  - • 23 - Advanced Run Control Techniques for Process Scheduler
- ► October
  - • 27 - Oracle Open World 2006 Wrap-Up
  - • 18 - Query Drilling URL Feature in PeopleTools 8.5 Review
- ► September
  - • 11 - Financial Transparency Tool
  - • 15 - Report Manager Performance
  - • 19 - Little known work-around for many nVision bugs...
  - • 21 - Desktop Single Signon for PeopleSoft
  - • 29 - Open World Update - Session Popularity
- ► August
  - • 03 - Managing Processing Time Limits
  - • 04 - Presenting at Oracle OpenWorld 2006
  - • 08 - Drag and Drop stopped working in Tree Manager?!?!
  - • 13 - Associating database connections with PeopleSoft users
  - • 14 - IE August Update Crashes PeopleSoft
  - • 21 - PS/nVision and Other Reporting Techniques Presentation
  - • 23 - Application Designer Index Management tip
  - • 25 - Hiding the PeopleSoft Pagebar in all component
  - • 30 - Determing the PeopleSoft Portlet URL
  - • 30 - Passing additional parameters to PeopleSoft pages
  - • 30 - Java and PeopleCode Tips and Tricks - Part 3
- ► July
  - • 12 - New Tool for PeopleSoft Application Developer Productivity
  - • 27 - Grey Sparling Experts coming to a city near you!!!
- ► June
  - • 09 - Oracle 12 Applications User Interface
  - • 18 - Fixing PeopleSoft Copy-URL for Firefox
  - • 20 - PeopleCode and C Integration
  - • 23 - Oracle-PeopleSoft Bloggers
- ► May
  - • 04 - App Designer 3 tier login from the command line
  - • 08 - Deeper dive explanation of Siebel Analytics by Mark Rittman
  - • 13 - Application Engine Development Tips
  - • 18 - nVision with Query Prompts
  - • 18 - Little known Row Level Security hook
  - • 22 - Fixing Report Manager
- ► April
  - • 05 - Enhancing the PeopleSoft for Administrators
  - • 20 - nVision Drilling Performance and Latency
  - • 27 - PeopleSoft Single Signon
  - • 29 - nVision and Siebel Analytics
- ► March
  - • 03 - nVision Power Drilling (Pages, Queries, Drilldown Layouts, and more)
  - • 16 - nVision and Fusion
  - • 23 - Darth Ellison vs Jedi ABAP
  - • 23 - Java and PeopleCode Tips and Tricks - Part 2
- ► February
- ► January
  - • 06 - Using PS/nVision to print your trees.
  - • 06 - Using Styles and nVision
  - • 09 - Follow-on to styles and nVision
  - • 18 - Integrating GoogleTalk with PeopleSoft
  - • 19 - Dynamic PeopleSoft Security Based on Login
  - • 23 - PeopleSoft Version Control
► 2005
- ► December
  - • 27 - How Chartfields are identified in GL
  - • 27 - Materialized Views and Row Level Security
- ► November
  - • 01 - October Update
  - • 11 - Filtering nVision for date and quarter
- ► October
  - • 14 - Understanding Row Level Security
  - • 16 - Why You Should Avoid PeopleCode For Row Level Security
- ► September
  - • 16 - Handling Rogue Queries in PS/Query
  - • 20 - Using Cube Manager to solve data merging issues
  - • 29 - Drilling to other content in nVision
  - • 29 - Hierarchical Reporting in nVision
- ► August
  - • 01 - nVision hanging problem
  - • 02 - Field Level Security in PS/Query
  - • 03 - Magic with Content Cells
  - • 04 - Accessing data from two different database instances
  - • 08 - PeopleSoft Trivia - the source control rule...
  - • 12 - Inside PeopleSoft trees - or - Photosynthesis at PeopleSoft
  - • 19 - Report Distribution with 3rd party solutions...
  - • 22 - Organizing reports in Report Manager prior to Tools 8.4
  - • 23 - Meet the Experts
  - • 26 - Improving the drilling usability in nVision
  - • 31 - Understanding Setids and Business Units
- ► July
  - • 20 - Doing Ledger-based nVision reporting in EPM
  - • 21 - To Customize or not to Customize, that is the question...
  - • 22 - Tricking PeopleSoft to do what you want - Part 1
  - • 23 - NorCalPRUG Meeting Notes -- Morning
  - • 25 - NorCalPRUG Meeting Notes -- PS/nVision vs. e.Spreadsheet
  - • 25 - Strategic Structure Alignment, Part 1
  - • 25 - NorCalPRUG Meeting Notes -- Technical Roundtable Notes
  - • 25 - Knowledge Networks versus Organization Structures
  - • 26 - nVision performance tuning
  - • 28 - Embedding Macros into nVision reports
  - • 29 - Training PS/Query to do new tricks...

Blog

PeopleSoft Component Interface Testing Tools

Adding Hints to Dynamically Generated App Engine SQL

Increasing System Availability with PeopleSoft

Syntax Highlighting for PeopleSoft SQL Traces

Query Tip of the day: Creating a Query from a PeopleSoft Component Name

News Archives

Recent Comments

Tags