You are previewing PeopleSoft PeopleTools Tips & Techniques.
O'Reilly logo
PeopleSoft PeopleTools Tips & Techniques

Book Description

Advanced PeopleSoft PeopleTools Development Strategies

Maximize the efficiency and productivity of your PeopleSoft applications from Oracle using the proven methods and best practices in this Oracle Press guide. PeopleSoft PeopleTools Tips & Techniques lays out the benefits of each tactic along with implementation considerations, programming instructions, and reusable code samples. Construct powerful iScripts, build custom UIs, work with Java and Ajax, and integrate the latest Web 2.0 features. Test-driven development, application security, performance tuning, and debugging are also covered in this authoritative resource.

• Develop modular logic using PeopleSoft application classes

• Incorporate file attachment and approval workflow capabilities

• Add Web elements with PeopleCode iScripts and bookmarkets

• Enhance functionality using HTML, JavaScript, CSS, and Ajax

• Extend PeopleSoft Integration Broker through custom connctors

• Effectively merge Java with PeopleCode to create elegant solutions

• Use runtime loggers and tracers to test and tune applications

• Extend the PeopleSoft Web server with JSP, servlets, and filters

• Create Web-based mobile applications using Oracle JDeveloper

Table of Contents

  1. Cover Page
  2. PeopleSoft PeopleTools Tips & Techniques
  3. Copyright Page
  4. Contents
  5. Acknowledgments
  6. Introduction
  7. PART I Core PeopleTools Concepts
    1. 1 Application Classes
      1. Our First Application Class
        1. Creating an Application Package and Class
        2. Coding the Application Class
        3. Testing the Application Class Code
        4. Expanding the Application Class
      2. Inheritance
      3. Features of Application Classes
        1. Dynamic Execution
        2. Construction
        3. Stateful Objects
        4. Access Control
      4. Putting It All Together: The Logging Framework Example
        1. Log Levels
        2. The Logger Interface
        3. The Logger Classes
        4. Testing the Framework
        5. Dynamic Logger Configuration
        6. Factory Test Program
      5. Misuses of Application Classes
        1. Runtime Context-Sensitive Variables
        2. Indiscriminate Usage
      6. Conclusion
        1. Notes
    2. 2 The File Attachment API
      1. Adding Attachments to Transactions
        1. Investigating the Target Transaction
        2. Creating the Attachment Storage Record
        3. Adding the FILE_ATTACH_SBR Subrecord
        4. Adding Attachment Fields and to the Transaction Page
        5. Writing PeopleCode for the Attachment Buttons
        6. Customizing File Attachment Behavior
      2. Moving to Level 1
        1. Modifying the Page
        2. Adding the PeopleCode
      3. Adding Multiple Attachments per Transaction
      4. Processing Attachments
        1. Accessing Attachments
        2. Storing Attachments
      5. Implementing File Attachment Validation
        1. Filename Validation
        2. File Contents Validation
      6. Conclusion
    3. 3 Approval Workflow Engine
      1. Workflow-Enabling Transactions
        1. Creating Supporting Definitions
        2. Configuring the AWE Metadata
        3. Modifying the Transaction
        4. Testing the Approval
      2. Providing Custom Descriptions for the Approval Status Monitor
      3. Allowing Ad Hoc Access
      4. Creating an Event Handler Iterator
      5. Web Service-Enabling Approvals
      6. Conclusion
    4. 4 Pagelet Wizard
      1. Pagelets Defined
      2. Creating a Pagelet
      3. Components of a Pagelet Wizard Pagelet
      4. Pagelet Data Types
        1. Setup for the Custom Data Type Example
        2. Coding the Custom Data Type
        3. Registering the Data Type
        4. Creating a Test Pagelet
      5. Pagelet Transformers
      6. XSL Templates
      7. Display Formats
      8. Conclusion
        1. Notes
  8. PART II Extend the User Interface
    1. 5 Understanding and Creating iScripts
      1. iScripts Defined
      2. Our First iScript
        1. Coding the iScript
        2. Testing the iScript
        3. Modifying the iScript
      3. A Bookmarklet to Call an iScript
        1. Writing the SetTraceSQL iScript
        2. Creating a Bookmarklet
      4. Desktop Integration
        1. Creating an iScript to Serve Calendar Content
        2. Building a Parameter Cache
        3. Modifying the Transaction
      5. Serving File Attachments
      6. iScripts as Data Sources
        1. Flex Requirements
        2. Say Hello to Flex
        3. Direct Reports DisplayShelf
      7. Conclusion
        1. Notes
    2. 6 JavaScript for the PeopleSoft Developer
      1. A Static JavaScript Example
      2. A Dynamic Java Script Example
        1. Creating the Derived/Work Record for Dynamic HTML
        2. Adding PeopleCode for the HTML Area
        3. Creating an HTML Definition
      3. Inspecting People Soft’s User Interface with Firebug
        1. Using Firebug’s Console
        2. Using Firebug to Enhance the Trace Bookmarklet
      4. Styling an Element
      5. JavaScript Libraries
        1. Serving JavaScript Libraries
        2. Using jQuery
      6. Making Global User Interface Changes
        1. Identifying Common Definitions
        2. Minimizing the Impact
        3. Coding the Solution
      7. Using jQuery Plug-ins
        1. Thickbox
      8. WEBLIB_APT_JSL iScript Code
      9. Performance Issues
      10. Conclusion
        1. Notes
    3. 7 AJAX and People Soft
      1. Hello AJAX
        1. Creating the AJAX Request Handler
        2. Ajaxifying a Page
        3. Adding Animation
      2. Ajaxifying the Direct Reports DisplayShelf
        1. Modifying the Flex Source
        2. Modifying the Direct Reports Service
        3. Creating a New HTML AJAX Service
        4. Modifying the Container Page
      3. A Configurable User Interface
        1. Using a Metadata Repository
        2. Modifying the Bootstrap Code
        3. Testing the Custom Scripts Component
        4. Highlight Active Field Revisited
      4. Changing Search Operators
      5. Fiddler
      6. Conclusion
        1. Notes
    4. 8 Creating Custom Tools
      1. The Toolbar Button Metadata Repository
        1. Setting Up the Repository Tables
        2. Creating the Toolbar Maintenance Page
        3. Defining the Toolbar’s HTML
      2. Attaching the Toolbar to Pages
        1. Defining a Custom Script for the Toolbar
        2. Adding the Trace Toolbar Button
      3. Modifying the Bootstrap Code
        1. Separating Common Code from Bootstrap Code
        2. Adding New URL-Generation Functions
        3. Writing the New Common Code
      4. Launching Another Component
        1. Creating an iScript to Get CREF Information
        2. Adding the Edit CREF Toolbar Button
      5. Viewing Query Results
        1. Creating a Query to Get a Page’s Permission Lists
        2. Adding the Query Toolbar Button
      6. Leaving the Portal
      7. Conclusion
  9. PART III Java
    1. 9 Extending PeopleCode with Java
      1. Java Overview
        1. Why Java?
        2. Why Not C++ or .NET or ...?
        3. Java and PeopleCode 101
        4. Java Strings
        5. Java Arrays
        6. Java Collections
      2. Writing a Meta-HTML Processor
        1. Implementing %Image
        2. Implementing %JavaScript
        3. Implementing %GenerateQueryContentURL
        4. Complete Code for the Meta-HTML Processor
      3. Using Third-Party Libraries
        1. Apache Commons
        2. Apache Velocity
        3. Using JSON
      4. Conclusion
        1. Notes
    2. 10 A Logging Framework for PeopleCode
      1. Investigating Problems
      2. Delivered Logging Tools
      3. The log4j Java Logging Framework
        1. Hello log4j
        2. Tracing log4j
        3. Configuring log4j
        4. Improving Logging Performance
        5. Avoiding Logger Reconfiguration
        6. Using log4j in the Process Scheduler
      4. An Integrated Logging Framework
        1. Creating the Level Class
        2. Creating the Logger Class
        3. The LogManager Class
        4. log4j Metadata
        5. Testing APT_LOG4J
      5. Conclusion
        1. Notes
    3. 11 Writing Your Own Java
      1. Your Java Build Environment
      2. Your First Java Class
        1. Creating the Source Files
        2. Deploying Java
        3. Creating the Test Program
      3. Using PeopleCode Objects in Java
        1. Configuring Your Development Environment
        2. Using PeopleCode System Variables
        3. Accessing Data
      4. PeopleSoft Database log4j Appender
        1. Creating the PL/SQL Autonomous Transaction
        2. Writing the Java
        3. Testing the Appender
        4. Static Configuration
      5. PeopleSoft Database Velocity Template Data Source
        1. Creating the Template Metadata Repository
        2. Creating the Velocity Repository Java Class
        3. Testing the PSDBResourceLoader
      6. Multithreading
      7. Conclusion
        1. Notes
    4. 12 Creating Real-Time Integrations
      1. Integration Technologies
      2. Setting Up for Database Integration
      3. Creating a Custom JDBC Target Connector
        1. Creating the JDBCTargetConnector Class
        2. Predeployment Testing
        3. Deploying the Connector
      4. Configuring Integrations
        1. Configuring the Gateway
        2. Creating a Node
        3. Transforming Messages
        4. Creating a Routing
      5. Testing the Integrated Connector
      6. Troubleshooting Custom Connectors
      7. Conclusion
        1. Notes
    5. 13 Java on the Web Server
      1. Extending the PeopleSoft Web Server with JSP
      2. Using Servlet Filters
        1. Investigating iScript Caching Behavior
        2. Creating an HTTP Header Servlet Filter
        3. Testing the Servlet Filter
        4. Deploying the Servlet Filter
      3. Conclusion
        1. Notes
    6. 14 Creating Mobile Applications for PeopleSoft
      1. Providing Web Services
        1. Enabling a Component Interface as a Web Service
        2. Testing the WSDL URL
      2. Going Mobile with JDeveloper
        1. Creating a Fusion Web Application
        2. Creating the Data Control
        3. Creating the View
        4. Designing the Search Page
        5. Testing the Search Page
        6. Shortening the Application’s URL
      3. Requiring Authentication
      4. Conclusion
        1. Notes
  10. PART IV Best Practices
    1. 15 Test-Driven Development
      1. Introduction to Test-Driven Development
        1. The TDD Approach
        2. Some TDD Lingo
      2. A TDD Framework
      3. Test Driving the Meta-HTML Processor
        1. Writing a Test
        2. Running the Test
        3. Making the Test Pass
        4. Running the Test Again
        5. Refactoring
        6. Repeating the Cycle
      4. Conclusion
        1. Notes
    2. 16 PeopleCode Language Arts
      1. Composition over Inheritance
      2. Façades
      3. Factories
      4. Inversion of Control
      5. Enumerated Types
      6. Language Diversity
        1. Notes
  11. Index