Peoplesoft EPM Planning and Budgeting Implementation Work Performed

Peoplesoft EPM Planning and Budgeting Implementation Work Performed - Functional and Technical.

Oracle WebLogic Server Administration Work Performed

Oracle WebLogic Server Administration Work Performed

• Configure WebLogic Server's authentication provider
• Deploy applications to WebLogic Server
• Backup and restore a WebLogic Server domain
• Create a WebLogic Server domain
• Configure and monitor WebLogic Server
• Configure WebLogic Server database resources
• Create and configure a WebLogic Server cluster
• Install WebLogic Server

WebLogic Server Overview

• Defining WebLogic Server Terms
• Listing WebLogic Server Tools
• Basic WebLogic Server Architecture

Installing and Patching WebLogic Server

• Determining Supported Configurations
• Installing WebLogic Server
• Applying a Patch to WebLogic Server

Creating Domains

• Domain Configuration
• Creating a Domain with the Configuration Wizard
• Configuring Domain Resources While Creating a Domain
• Moving a Domain to Another Computer

Starting Servers

• Starting and Stopping Server with Standard Scripts
• Dealing with Startup Problems
• Customizing Standard Start Scripts

The Administration Console

• Accessing the Administration Console
• Creating and Configuring Servers by using the Admin Console

Configuring JDBC

• Configuring JDBC Generic Data Sources
• Configuring GridLink Data Sources
• Performing Basic Data Source Connection Pool Tuning

Monitoring a Domain

• Configuring and Accessing Server Logs
• Enabling Debugging Output
• Monitoring Server Health and Performance
• Monitoring JDBC Data Sources
• Viewing Diagnostic Charts by using the Monitoring Dashboard

Node Manager

• WebLogic Server Node Manager Utility
• Configuring WebLogic Server Machines
• Setting Up and Configuring Node Manager
• Starting WebLogic Server through Node Manager

Deploying Applications

• Deploying Applications to WebLogic Server
• Testing Deployed Applications
• Monitoring Deployed Applications
• Stress Testing WebLogic Server

Clusters

• Planning for a WebLogic Server Cluster
• Creating and Configuring a WebLogic Server Cluster
• Creating and Configuring a WebLogic Server Dynamic Cluster
• Configuring Oracle HTTP Server as a WebLogic Server Cluster Proxy
• Debugging Cluster Errors

Transactions

• WebLogic Server Transaction Architecture
• Configuring a Database as the Persistent Store for WebLogic Server Transactions

WebLogic Server Security

• WebLogic Server Security Architecture
• Configuring an External LDAP Product as the WebLogic Server Authentication Provider

Backing Up and Restoring a Domain

• Backing Up a WebLogic Server Domain
• Restoring a WebLogic Server Domain

Oracle BI System Administration Work Performed

Oracle BI System Administration Work Performed

• Enable usage tracking to track queries and database usage, and improve query performance
• Identify Oracle BI system administration tasks
• Oracle BI system logical architecture
• Identify Oracle BI Java components and Oracle BI system component
• Identify the system administration tools that are available for managing Oracle BI
• Centrally manage Oracle BI components using Fusion Middleware Control
• Centrally manage Oracle BI Java components using the Oracle WebLogic Server Administration Console
• Stop and start Oracle BI components
• Vertically and horizontally scale Oracle BI components
• Set up security to authenticate users and assign appropriate permissions and privileges
• Apply cache management techniques to maintain and enhance query performance
• Set up query logging for testing and debugging
• Deploy Oracle BI for high availability
• Diagnose and resolve issues in Oracle BI using diagnostic log files

Oracle BI System Administration 

• Oracle BI System Administration 
• Oracle BI System Logical Architecture
• Identifying Oracle BI Java Components
• Identifying Oracle BI System Components.
• Identifying Oracle BI System Administration Tools

Managing Oracle Business Intelligence

• Using Fusion Middleware (FMW) Control to Centrally Manage Oracle BI System Components
• Using Oracle WebLogic Server Administration Console to Centrally Manage Oracle BI Java Components

Configuring the Oracle BI System

• Using Fusion Middleware Control to Configure Oracle BI
• Using the Oracle BI Systems Management API to Update Oracle BI Configuration Settings
• Using a Text Editor to Configure Oracle BI
• Using the Fusion Middleware Control MBean Browser to Update Configuration Settings
• Locating Oracle BI Configuration Files

Starting and Stopping Oracle BI

• Starting Oracle Business Intelligence
• Using Fusion Middleware Control to Manage Oracle BI System Components
• Using Oracle WebLogic Server Administration Console to Control Managed Servers
• Using OPMN to Manage Oracle BI System Components

Scaling an Oracle BI Deployment

• Performing an Enterprise Install for New Installations
• Performing an Enterprise Install to Scale Out Existing Installations
• Setting Up Shared Files and Directories
• Setting Up Global Cache
• Using Fusion Middleware Control to Scale System Components
• Validating That Your System Has Been Scaled Correctly

Deploying Oracle BI For High Availability

• Using FMW Control to Identify Single Points of Failure
• Using FMW Control to Configure Primary and Secondary Servers
• Exploring the Oracle BI Cluster Server Startup Process
• Using the Cluster Manager
• Troubleshooting an Oracle BI Clustered Environment

Managing Performance Tuning and Query Caching

• Using FMW Control to View Performance Metrics
• Using FMW Control to Disallow Repository Updates
• Using FMW Control to Set User Session Log-Off Period
• Using FMW Control to Set Performance Configuration Options
• Using FMW Control to Configure Caching
• Using Cache Manager
• Seeding the Cache

Diagnosing and Resolving Issues in Oracle BI

• Locating Diagnostic Log and Configuration Files
• Enabling Query Logging for a User
• Managing the Query Log

Managing Usage Tracking

• Setting Up a Usage Tracking Business Model
• Enabling and Testing Usage Tracking

Oracle BI Security

• Exploring Default Security Settings
• Creating Users and Groups
• Creating Application Roles
• Setting Up Repository Object Permissions
• Setting Up Row-Level Security (Data Filters)
• Setting Up Row-Level Security in the Database
• Setting Query Limits
• Setting Up Presentation Object Permissions and System Privileges

PeopleSoft Integration Work Performed

PeopleSoft Integration Work Performed

• PeopleSoft integration technologies
• Configure PeopleSoft Integration Broker
• Send and receive service operations using PeopleSoft Integration Broker
• Create integrations requiring transformations, translations, and filtering
• Integrate data with PeopleSoft and third-party systems using component interfaces
• Provide and consume web services with third-party systems
• Test service operations and create IB Generic feeds

 Technology Overview

• PeopleSoft Integration Technologies
• Web Services
• PeopleSoft Integration Broker
• Services and Service Operations
• Component Interfaces

PeopleSoft Integration Broker Architecture

• PeopleSoft Integration Broker Architecture
• PeopleSoft Integration Gateway
• Connectors
• Gateway Services
• Integration Engine
• Explaining the Flow of Inbound Requests to PeopleSoft Integration Broker
• Explaining the Flow of Outbound Requests from PeopleSoft Integration Broker

Configuring PeopleSoft Integration Broker

• PeopleSoft Integration Broker Configuration
• Nodes
• Renaming Local Nodes
• Creating Remote PeopleSoft Nodes
• Configuring Integration Gateway Properties
• Setting Service Configuration

Creating Messages

• Services and Service Operations
• Messages
• Creating Rowset-based Messages
• Describing Rowset-based Message Schema
• Modifying Rowset-based Message Schema
• Creating Nonrowset-based Messages

Creating Message Parts and Containers

• Message Parts
• Creating Part Rowset Messages
• Reusing Rowset-Based Message Parts
• Creating Container Messages

Creating Asynchronous Service Operations

• Adding Service Operations
• Creating and Configuring Queues
• Securing Service Operations
• Adding Routings

Sending and Receiving Asynchronous Service Operations

• Sending and Receiving Asynchronous Service Operations
• Publishing Asynchronous Service Operations
• Working with Rowsets in Service Operations
• Populating Attribute Values for Container Messages
• Application Classes
• Implementing INotificationHandler
• Adding Handlers
• Other Operation Types

Using Service Utilities

• Service Utilities
• Administering Services
• Using the Handler Tester
• Using Service Operation Tester
• Building and Validating Service Schemas

Monitoring Asynchronous Service Operations

• Service Operations Monitor and Statuses
• Monitoring Asynchronous Services
• Testing FILEOUTPUT Connector
• Administering Service Operations
• Logging Service Operation Transactions
• Setting up Error Notification
• Archiving Monitor Data

Creating Synchronous Service Operations

• Creating Synchronous Service Operations
• Synchronous Service Operation Events
• Implementing IRequestHandler
• Using Custom Faults
• Monitoring Synchronous Services

Applying Transformations

• Installing and Configuring JDeveloper
• Transformation Programs
• Creating an Application Engine Transform Program
• Using the Oracle XSL Mapper
• Testing Transform Programs in PeopleSoft Pure Internet Architecture
• Adding Transformation to a Routing
• Versioning Service Operations

Applying Data Translations Using Codesets

• Data Translation
• Codesets
• Creating a Codeset Group
• Creating Codesets
• Creating Codeset Values
• Writing a Transform Program for Data Translation

Creating and Testing Component Interfaces

• PeopleSoft Component Interfaces
• PeopleSoft Component Interface Architecture
• Elements of a Component Interface Definition
• Creating Applications that Use Component Interfaces
• Creating Component Interfaces
• Setting Component Interface Security
• Testing Component Interfaces

Implementing Component Interfaces

• Component Interface Instantiation
• Adding Component Interface PeopleCode to an Application
• Modifying Component Interface PeopleCode

Working with Component Interface Collections

• Component Interface Collections
• Writing PeopleCode for Component Interface Collections
• Working with Effective-Dated Data

Enabling Component Interfaces as Services

• Component Interfaces as Services
• Service Enabling a Component Interface
• Generated Service Operations
• Changing Component Interfaces

Providing and Consuming Web Services

• Integrating with Third-Party Systems
• Providing Web Services
• Integrating with BPEL where PeopleSoft is the Provider
• Consuming Web Services
• Integrating with BPEL where PeopleSoft is the Consumer
• Securing Web Services

Testing Service Operations

• Send Master Utility
• Identifying the Send Master Project Types
• Creating an Integration Broker Project
• Testing SOAP Messages
• Testing Service Operations Using soapUI

Using IB Generic Message Feeds

• IB Generic Message Feeds
• Publishing IB Generic Message Feeds
• Viewing, Editing and Deleting Feeds

PeopleSoft EPM Core Technical Work Performed

PeopleSoft EPM Core Technical Work Performed

• EPM architecture
• Create Warehouse Business Units
• Create EPM metadata
• Create trees
• ETL in EPM
• Use DataStage Administrator
• Use DataStage Designer
• Use DataStage Director
• Set up EPM security
• Create models and scenarios
• Create and use EPM jobstreams
• Use Allocation Manager
• Use Data Mapper

• EPM solution

  • ETL process in EPM
  • Operational Warehouse - Staging
  • Operational Warehouse - Enriched
  • Multidimensional Warehouse
  • PeopleSoft EPM Warehouses and Reporting
  • PeopleSoft EPM Analytical Applications - Financial
  • EPM PeopleBooks

  ETL Overview

  • IBM WebSphere DataStage Server and Client Components
  • IBM WebSphere DataStage Terminology
  • DataStage Administrator, Designer, and Director
  • Other DataStage Components
  • ETL Load Strategies in EPM
  • Error Handling in ETL Jobs
  • Loading Source Data into Operational Warehouse - Staging (OWS) Tables

  Using DataStage Administrator

  Using DataStage Designer

  • DataStage Designer
  • Managing Repository Objects
  • Analyzing Repository Object Usage
  • Importing and Exporting Repository Components
  • Working with Table Definitions
  • Building DataStage Jobs
  • Compiling and Running Jobs
  • Editing Job Properties

  Using DataStage Director

  EPM Business Rules Setup

  • EPM Business Rule Setup
  • Defining EPM Sources
  • Defining Country and State Data
  • Accounting Calendars Setup
  • Unit of Measure Setup
  • Multi-Currency Setup and Currency Conversion Rules
  • Defining Dimensions

  Defining Warehouse Business Units

  • Warehouse Business Units
  • Creating Warehouse Business Units

  Resolving Dimension Collisions

  • Using the Business Unit Creation Wizard
  • Defining Collision Maps

  Working with Trees

  • PeopleSoft Trees
  • Tree Utilities

  Working with Metadata for the OWE and Analytical Applications

  • Metadata for the EPM Analytical Applications
  • Defining Record Metadata
  • Defining TableMap Metadata
  • Defining DataMap Metadata
  • Defining Filters, Constraints, and Expressions
  • Defining Metadata for the Profit Manager Tool
  • Defining Rule Metadata for Models

  Working with Models and Scenarios

  • Models and Scenarios
  • How Models Are Used in EPM Applications
  • Models and Scenarios

  Working with Jobstreams

  • Jobstreams
  • Defining and Running Jobstreams

  Using Data Enrichment Tools

  • Allocation Manager
  • Setting Up Allocation Manager Rules
  • Setting Up Allocation Manager Rule Sets
  • Defining Fixed Dimensions
  • Running Allocation Manager

  Using Data Mapper

  • Data Mapper
  • Defining Data Mapper Rule Sets
  • Defining Data Mapper Rule Groups
  • Defining Data Mapper Values

  Using EPM Security

  • EPM Security
  • Understanding EPM Security
  • Setting Up Security by User
  • Setting Up Security by Role
  • Setting Up Metric-Level Security
  • Using Security APIs
  • Using LDAP Security Data

  Loading the Multidimensional Warehouse, EPM Warehouses, and Reporting

  • Loading Data Into the MDW
  • Describing the EPM Warehouses
  • Using Oracle OBIEE to Report on Data Stored in EPM Warehouses

  Using ETL-Based Tree Processing for the Multidimensional Warehouse

PeopleSoft Applications Administration Work Performed

PEOPLESOFT APPLICATIONS ADMINISTRATION

Technology Overview
•    PeopleSoft PeopleTools, PeopleSoft applications
•    PeopleTools and Applications implementation
•    PeopleSoft PeopleTools in PeopleBooks

PeopleSoft Architecture
•    Multi-tier processing
•    PeopleSoft Pure Internet Architecture
•    PeopleSoft databases
•    PeopleSoft servers
•    PeopleSoft clients
•    Designing a configuration for an application

Installing the PeopleSoft Environment
•    Preparing for the installation of the PeopleSoft environment
•    Describing PeopleSoft installation tools
•    Building a PeopleTools installation
•    Setting up installation workstations
•    Testing an installation and planning for future changes

Installing PeopleSoft Databases
•    Preparing for database installation
•    Database creation steps
•    Determining what databases to install
•    Running the database configuration wizard
•    Creating databases using Data Mover and other PeopleTools
•    Performing post database installation testing

Installing Tuxedo and Jolt
•    Middleware - Installing Tuxedo
•    Removing and upgrading Tuxedo

Creating and Configuring Application Server Domains
•    Application server domains
•    Domain server processes and functions
•    Specialized domains
•    PS_HOME and PS_CFG_HOME
•    Creating an initial domain configuration
•    Automating domain startup and shutdown
•    Testing a domain
•    Configuring a search server domain

Administering Application Servers
•    Troubleshooting common domain boot problems
•    Administering the domain and viewing status
•    Using PSADMIN to reconfigure a domain
•    Setting individual process parameters

Administering the Web Server
•    Web server elements
•    Web server installation
•    Locating and identifying web server files
•    Interpreting various web server configuration files and  determining web server behavior

Installing and Configuring PeopleSoft Internet Architecture
•    Installing the PeopleSoft Internet Architecture
•    Using the web server administrative console
•    Configuring the browser connection
•    Locating and modifying web server configuration files to change web server behavior
•    Installing multiple PeopleSoft applications
•    Using load balancing and fail-over features in PeopleSoft applications

Examining the Batch Environment
•    Identifying batch components
•    Batch process flow
•    Determining batch server locations

Setting Up and Configuring the Batch Environment
•    Creating batch servers
•    Modifying batch server configuration settings
•    Starting and stopping the Process Scheduler
•    Creating a new Process Scheduler server definition

Configuring Report Distribution and Monitoring the Batch Environment
•    Launching processes
•    Using the Process Monitor
•    Report Manager
•    Configuring the report purge process
•    Automated report distribution

Managing and Troubleshooting an Implementation
•    PeopleSoft troubleshooting tools
•    Examining PeopleSoft server log files
•    Listing troubleshooting tools available after installation

Setting Up the Environment Management Framework
•    Environment Management Framework (EMF) architecture
•    Installing and configuring the Environment Management agent components
•    Using the Environment Management clients with the EMF

Using PeopleSoft Performance Tools
•    Performance Monitor architecture
•    Activating a self-monitoring Performance Monitor system
•    Accessing Performance Monitor information
•    Using PeopleSoft Ping (PSPING)

Tuning an Implementation
•    Defining tuning layers
•    Evaluating application server settings to improve performance
•    Creating dedicated Integration Broker servers
•    Tuning a batch environment
•    Load balancing with the Master Scheduler

Installing and Configuring PeopleBooks
•    Installing PeopleBooks
•    Configuring access to PeopleBooks