Overview of Stat Administration
Stat Architecture and Components
Administrative Utilities
Windows Client / Web Browser
Stat Central Agent / App Web Server
Database Tier
Application Environments
Stat Administrator Responsibilities
Manage Stat Maintenance Tables
Administer Security
Manage the Stat Central Agent
Provide End-User Support
Perform Application Upgrades
Perform Database Maintenance
The Stat SYSTEM User Account
Standard Maintenance Windows
Buttons and Controls
The Record List
Field Types
Adding and Deleting Records
Using the Color Selection Dialog Box
Importing and Exporting Maintenance Tables
Stat INI Editor
Stat Security
The Database Tab
Encryption Key Update
Data Replicator
Table Dump Utility
PeopleSoft Object Mover Instruction Update Utility
Configuration Guide for New Installations
General Setting Information
Changing the STATLOGIN Password
Testing Connections
Editing Records
Deleting Records
Duplicating Records
Copying Record Values
Order of Appearance
Printing the Stat INI file
The Options Tab
Stat Security Layers
Defining User Classes
Editing User Class Rights
Defining Stat Users
General Maintenance Tables
Copying User Definitions
Resetting Passwords
The User Access Information Window
LDAP Connection Maintenance
Connection Manager
Service Domain Access Tab
PS Options Tab (PeopleSoft only)
User File Directories Tab
Queue Assignment Tab
Application Access Tab
Object Type Access Tab
Environment Access Tab
Pre/Post Migration User Parameters Tab
Synchronizing User Access Information
User Password Security Settings
System Maintenance
Service Domain-Specific Maintenance
General Tab
License Tab
Users Tab
Other Options Tab
Parameters Tab
DB Scripts Tab
CSR History Tab
Approvals Tab
Service Domain Maintenance
Department Maintenance
Issue Tracking Maintenance
Country Maintenance
Customer Maintenance
Object Type Maintenance
File Types
PeopleSoft Environment Connection Maintenance
File Types for Oracle Applications
Source File Locations
File Type User Directories
VCM Locations
File Templates
Setup Object Types for Oracle Applications
File Servers
File Path Syntax
Case Sensitivity and File Name Conversion
Server-Specific Pre/Post Migration Step Parameters
SFTP Public Key-Based Authentication
User Default Directories
Oracle Apps Base Directories
Testing File Locations, Servers, and Default Directory Locations
Oracle
Testing Environment Connections
Inactivating PeopleSoft Environments
Managing File Locations by Environment
PeopleSoft Options
Pre/Post Migration Steps Parameters
Oracle Applications Configuration
Oracle Applications Connection Maintenance
Setting Up User Connections
Setting Up Physical Object Lock Exclusions
Setting Up Migration Approval Lists
Copying PeopleSoft Environments
Testing Environment Connections
Defining Oracle Applications Servers
Start/Stop Oracle Applications Agents
Inactivating Oracle Applications Environments
Setting Up Migration and Patch Approval Lists
Updating Products per Environment
Copying Oracle Applications Environments
Generic Application Connection Maintenance
Testing Environment Connections
Inactivating Generic Application Environments
Managing Source File Locations by Environment
Setting Up Migration Approval Lists
Copying Generic Application Environments
Schema Object Parameters Maintenance
Data Object Maintenance
PeopleSoft Search Configurations
Creating Tables and Views
Stat Report Definition Maintenance
Version Control Management Connection Maintenance
Employee View Example (Pre PeopleTools Version 8.48)
Employee View Example (PeopleTools Version 8.48 and Higher)
Country View Example
Department View Example
Exclusions
Working With Service Domains
Activity Code Maintenance
Application Maintenance
Application Environment Maintenance
Auto Task Maintenance
Business Rule Maintenance
Configuring the Stat Central Agent
Defining Business Rules
CSR Log Topics Maintenance
CSR Priority Maintenance
CSR Type and Status Maintenance
Customer Priority Maintenance
Generic Application Migration Path Maintenance
Selecting a Trigger Event
Defining Rule Criteria
Defining Message Content
Defining a Distribution List
Defining a Command to Run
Resetting a Rule
Saving Rules
Disabling Rules
Copying Rules
Viewing Rule History
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
PeopleSoft Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Oracle Application Migration Path Maintenance
Migration Path Diagram
Defining Distribution Environments
Updating CSR Migration Paths with Additional Environments
Pre and Post Migration Steps
Release Management Maintenance
Template Maintenance
Queue Maintenance
Workflow Maintenance
Starting and Stopping the Stat Central Agent
Defining Agent Jobs
Email Configuration
Error Notification
Job Maintenance
Job Classes
Stat Central Agent Printers
Monitoring the Stat Central Agent
Check for Past Due Items
Email Reports and Print Reports
Log Off and Wait
PS Object Lock Sync
Purge Agent Event Tables
Purge Audit Tables
Purge Deleted Archive Sets
Purge Error Log Tables
Purge Migration Event Tables
Stat Central Agent Purge System-Generated Logs
Run Operating System Command
Unlock Locked CSRs
The Schedule Tab
The Error Notification Tab
Accessing the Job Monitor
Schedule Tab
Jobs Tab
Logs Tab
Filtering and Sorting
Showing Job and Log Details
Customizing the What's New Tab in Stat Web
Customizing Field Labels for the Stat Web Client
Configuring the Stat Central Agent for Email
Outbound Mail Configuration
Inbound Mail Configuration
Object Security
Default Values Tab
Special Processing Tab
Skip Processing
Undeliverable Processing
Info Request Processing
Adding a Parameter
Order of Processing
Removing or Editing a Parameter
Advanced Customer Identification and Tracking # Tabs
Regular Expressions
Regular Expression Examples
Adding a Regular Expression
Order of Processing
Removing or Editing a Regular Expression
Field-Specific Tabs
Reply Tabs
PeopleSoft Proprietary Object Security
PeopleSoft Object Security Setup Instructions
Frequently Asked Questions
File Object Security
Appendix: Sample Service Domain Configuration
Appendix: User Class Rights
Notes on User Class Rights
CSR Edit Rights
CSR Tabs Rights
CSR Tasks Rights
Generic Application Migration Management Rights
Generic Application Object Management Rights
Maintenance - File Object Rights
Maintenance - General Rights
Maintenance - Service Domain Rights
Oracle Apps Migration Rights
Oracle Apps Object Management Rights
Oracle Apps Patch Management Rights
PeopleSoft Migration Management Rights
PeopleSoft Object Management Rights
Project Rights
Security Rights
Stat Central Agent Rights
Tool Rights
Wizard Rights
Appendix: Creating a Staging Database
Appendix: Database Tuning
Appendix: Oracle Applications File Type Directory
Appendix: Ports and Firewalls
Appendix: REST Web Services API
Appendix: SOAP-Based Web Services API
Services and Exposed Methods
Appendix: Troubleshooting Chart
Login Service
Class Definitions
long connect( String userId, String password ) throws WSLoginFault;
void disconnect( long connectId );
CSR Service
Approval Service
Stat Database
Stat Central Agent
Stat Oracle Agent
Login/Connection
Administrative Utilities
CSRs
Stat Web
Archiving and Migrating
Printing
Miscellaneous
Appendix: stat.conf Configuration
Appendix: Custom Report Files
MSS SQL Server Database Tuning
MSS SQL Server is basically a self tuning system.
Be sure there is adequate space for Transaction logs based on your backup schedule
Run the following on a weekly basis:
Appendix: Oracle Applications File Type Directory
|
• |
$prod is used to represent the selected product |
|
• |
$prodTop is used to represent the directory for the selected product |
|
• |
$lang is used to represent the selected language. |
|
Consider following directories using first where file is found | |
|
Consider following directories using first where file is found | |
|
- $prodTop/reports/$lang/*.rdf if exists, otherwise $prodTop/reports/*.rdf | |
|
$prodTop/reports/$lang if exists, otherwise $prodTop/reports | |
|
$prodTop/reports/$lang if exists, otherwise $prodTop/reports | |
|
Consider following directories using first where file is found | |
|
XMLExporter is used to extract the xml file from MDS Repository. | |
|
XMLImporter is used to deploy the xml file to MDS Repository of target | |
|
FNDLoad is used to extract the data source from XDO_DS_DEFINITIONS table | |
|
FNDLoad is used to deploy the data source to XDO_DS_DEFINITIONS table of target environment | |
|
If $prodTop/patch/115/xdf directory exists and xdfcmp.pl is used to deploy the xdf file to the target environment | |
Appendix: Ports and Firewalls
Resolving port and firewall conflicts
Typical port and firewall conflicts include:
If you have port conflicts, the server will display one or more error messages, such as:
The Stat Central Agent utilizes a set of ports that are already defined.
These values are defined for a default port offset of zero which is set in a variable called jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. If there is a conflict situation or a second or third agent is necessary, you may change the jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. The value for offset is added to all the default values.
|
2 |
Open <STAT_HOME>\app\bin\standalone.conf.bat with Notepad or other text editor. For Stat Central Agent on Unix, you need to open the <STAT_HOME>/app/bin/standalone.conf file. |
|
3 |
Search for the setting: -Djboss.socket.binding.port-offset=0 |
|
4 |
Change the setting to a proper offset. For example, -Djboss.socket.binding.port-offset=10 |
The http port is the only port that needs to be opened on existing firewalls.
################################################################################
################################################################################
stat.db.jdbc_driver:oracle.jdbc.driver.OracleDriver
stat.db.server:<stat repository server name/ip> <-- Natted IP Address