Batch Processing

Create and Process Large Amounts of Data!

What you will learn

  •  App Engine Sections, Steps, and Actions
  •  SQL actions
  •  Libraries
  •  State record initialization
  •  Temporary tables (TAO)
  •  Trace files
  •  PeopleCode
  •  Process definitions
  •  Run control pages
  •  Action execution sequence
  •  Database commands (PL/SQL, etc.)
  •  State records (AET)
  •  Parallel processing
  •  Testing and debugging
  •  Performance tuning
  •  Set processing
  •  Run control records
  •  Security

Also Available as

WHO SHOULD ATTEND?

  • PeopleSoft Developers

System Requirements

This course includes plenty of hands-on activities. To be successful, we recommend keeping a PeopleSoft development, test, demo, or sandbox handy. If you don't have one, you may build your own laptop-hosted VirtualBox instance by following the instructions in the My Oracle Support document 1641843.2.

Duration

Students typically complete this material within 40 hours.

You will have access to the videos for 60 days after purchase and may keep the accompanying activity guide for life.

RECOMMENDED PREREQUISITES

Course curriculum

  • 1
    Introduction
    • © Copyright
    • 💡 Hints and Definitions
    • How to use this course
    • Introduction to App Engine
  • 2
    Creating the Sample Module
    • Creating the Sample Module
    • Activity: Create Fields
    • Activity: Create Records
    • Activity: Create Pages
    • Activity: Create Components
  • 3
    1. Application Engine
    • Chapter Overview
    • About App Engine
    • What is Application Engine?
    • Application Engine Features
    • Data Dictionary Integration
    • Meta-SQL Support
    • Effective-Dated Sections
    • Platform-Specific Sections
    • PeopleCode in Application Engine Programs
    • Program Restart Capability
    • Summary
  • 4
    2. Application Engine Structure
    • Chapter Overview
    • App Engine Review
    • Walkthrough 2-1: App Engine Review
    • Application Engine Components
    • Application Engine Program Execution
    • Creating an App Engine Program
    • Walkthrough 2-2: Creating an AE Program
    • Section Properties
    • Effective Dated Sections
    • Walkthrough 2-3: Sections with Different Effective Dates
    • Additional App Engine Properties
    • Section Execution Sequence
    • Steps and Step Properties
    • Actions
    • Program Properties
    • SQL-based App Engines
    • Activity 2-4: SQL-based App Engine
    • Summary
  • 5
    3. SQL, Sections, Logging
    • Chapter Overview
    • The SQL Action
    • Reuse Statement
    • Multiple Sections
    • Log Message
    • Log Message
    • Application Libraries
    • Application Libraries
    • Walkthrough 3-1: Application Library
    • Summary
  • 6
    4. State Records
    • Chapter Overview
    • State Records
    • The Purpose of State Records
    • State Record Characteristics
    • Reviewing an Existing State Record
    • Associating a State Record with an AE Program
    • %SELECT and %BIND
    • Creating and Using State Records
    • Walkthrough 4-1: Creating and Using a State Record
    • Summary
  • 7
    5. Testing and Debugging
    • Chapter Overview
    • Testing and Debugging
    • Application Engine Testing and Debugging
    • Process Monitor
    • Application Engine Trace
    • Walkthrough 5-1: Viewing the AE Trace File
    • App Engine Debugger
    • Application Engine Debugger
    • Restarting an App Engine Program
    • About Restartable App Engine Programs
    • Restarting an Application Engine Program
    • Summary
  • 8
    6. Do Select
    • Chapter Overview
    • Do Select
    • Do Select
    • Do Select Types
    • Select and Fetch
    • Row-by-Row Processing
    • Activity 6-1: Row-by-Row Processing
    • Review: Row-by-Row Processing
    • Tracing
    • Reselect and Restartable Settings
    • Reselect
    • Restartable
    • Programming for Restarts
    • Summary
  • 9
    7. Conditional Processing with SQL
    • Chapter Overview
    • Conditional Processing with SQL
    • Do Actions
    • Do When
    • Do While
    • Do Until
    • Using SQL for Conditional Logic
    • The Sequence and Interaction of Actions Within a Step
    • Summary
  • 10
    8. App Engine and PeopleCode
    • Chapter Overview
    • App Engine and PeopleCode
    • Using PeopleCode in App Engine
    • Using PeopleCode in Application Engine
    • The PeopleCode Editor
    • Referencing Fields in Application Engine PeopleCode
    • PeopleCode Variables
    • Conditional Execution in AE with If-Then Statements
    • Dynamic Section Calls
    • Walkthrough 8-1: PeopleCode
    • Review: Using PeopleCode in App Engine
    • Optimizing PeopleCode in App Engine
    • Activity 8-2: Improving Performance
    • Review: Optimizing PeopleCode in App Engine
    • Summary
  • 11
    9. Set Processing
    • Chapter Overview
    • Set Processing
    • Set Processing
    • Set Processing, Temporary Tables, and AE Programs
    • Comparing the Performance of Row-By-Row to Set Processing
    • Walkthrough 9-1: Set Processing
    • Review: Set Processing
    • Summary
  • 12
    10. Temporary Tables
    • Chapter Overview
    • Temporary Tables
    • Parallel Processing and Staging Tables
    • Temporary Table Record Definitions
    • Online Execution of AE Programs vs. Batch Mode
    • Walkthrough 10-1: Implementing Parallel Processing in AE Programs
    • Online Allocation of Temporary Tables vs. Batch Mode
    • Summary
  • 13
    11. Running App Engine Programs
    • Chapter Overview
    • Running an App Engine
    • Launching an AE Program from the Command Line
    • Online Execution of Application Engine Programs
    • Walkthrough 11-1: CallAppEngine
    • Launching an AE Program Using Process Scheduler
    • Run Control Record
    • Run Control Records and Pages: Reusing vs. Creating
    • The Component Definition
    • Process Definition
    • Granting User Security Access to AE Programs
    • Associating Process Groups with Permission Lists
    • Creating a Run Control Page
    • Activity 11-2: Creating a Run Control Page
    • Review: Creating a Run Control Page
    • Summary
  • 14
    Bonus
    • Component Interfaces
    • Fluid Run Control Pages
    • Final Q&A
  • 15
    Next Steps
    • Course Survey