Setting Up Parallel Processing for Statements
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
Server Definition Page |
SERVERDEFN |
Define the maximum concurrent processes for Application Engine processes. See the product documentation for PeopleTools: Process Scheduler for more information. |
|
PARALLEL_AR_SBP |
Specify the exact number of parallel processes or partitions that you want for statements. |
|
|
Job Definition Page |
PRCSJOBDEFN |
Add additional Statements process definitions to run the AR_STMT multiprocess job. See the product documentation for PeopleTools: Process Scheduler for more information. |
|
Process Definition Page |
PRCSDEFN |
Add additional Statements process definitions if you need to run more than eight parallel processes. See the product documentation for PeopleTools: Process Scheduler for more information. |
PeopleSoft Receivables enables you to process multiple Statements processes in parallel to achieve higher performance. You initiate the processes using one run control and the process automatically divides the work between the number of partitions that you specify in your setup.
The Statements Preprocessor multiprocess job (ARSTMT) includes:
The Statement Parallel Preprocessor Application Engine process (AR_STMTPP).
The Statements - Parallel multiprocess job (AR_STMT).
The following diagram illustrates how the Statements Preprocessor Application Engine parallel processor processes four different statement jobs AR_STMT1, AR_STMT2, ARSTMT3, and AR_STMT4 at the same time and extracts data to prepare customer statements for each job.
Illustrates how the Statements Preprocessor Application Engine parallel processor processes four different statement jobs at the same time, and extracts data to prepare customer statements for each job
When you use the Process Monitor to check the status of the process, you view the status of the AR_STMTPP process and each process within the AR_STMT multiprocess job. The system does not indicate that the Statements Preprocessor multiprocess job (ARSTMT) is successful until each parallel process completes. The Job Message Log Summary page summarizes all the individual parallel process message log messages for the entire ARSTMT job.
Note: PeopleSoft Receivables also provides the Statements-Parallel/Prnt multiprocess job (STATEMNT), which runs the Statements Preprocessor multiprocess job (ARSTMT) and prints the Open Item Statement and the Balance Forward Statement.
AR_STMTPP Process
The AR_STMTPP process acts as a preprocessor for the Statements process and also:
Selects SetIDs and customers for processing.
Places the qualified data in temporary tables.
Partitions the data between the child processes.
Initiates the AR_STMT multiprocess job that starts child processes in parallel.
The distribution of the data among the child or parallel processes is based on the composition of the data and the number of parallel processes. The process attempts to spread the data volume evenly among the processors. The staging phase takes a little longer, but the overall processing time is faster because multiple children processes run concurrently. You should balance the decision of using parallel processing or single thread processing based on the volume of data and the hardware capacity to get the maximum benefit from this feature.
AR_STMT Multiprocess Job
The AR_STMT multiprocess job contains all of the Application Engine process definitions that you use for parallel processing, such as AR_STMT1. Each process definition calls the AR_STMTS Application Engine process, which actually extracts the data, prepares the statements, and performs table cleanup before the process ends.
PeopleSoft Receivables delivers eight process definitions—AR_STMT1 through AR_STMT8. If you want to run more than eight partitions of the Statements process at once, you must define additional process definitions. Use the AR_STMT1 process definition as an example.
The standard setup for the AR_STMT multiprocess job is to run a single threaded process that contains only the AR_STMT1 process definition. If you want to use parallel processing, you must assign additional process definitions to the job definition. You must also specify the number of partitions that your organization will use. You might have to experiment with the number of partitions that works for you. Oracle suggests that you assign just a couple of additional partitions and increase the number, if needed.
You might also have to override the server settings for your organization. By default, you can run up to three instances of a process at one time. If you want to run additional instances, you must change your configuration. If you also use parallel processing for the Payment Predictor (AR_PREDICT), Aging (AR_AGING), and Receivable Update (AR_UPDATE) processes, the maximum instances applies to those processes, as well. For example, if you want to run eight instances for the Receivables Update process and four for the Statements process, you must configure your server for eight instances.
Open the PSAdmin tool on your server to change the configuration settings.
To change the maximum instances:
Scroll to the section titled Values for config section – PSAESRV.
The section looks as follows:
Values for config section - PSAESRV.Max Instances = 3.Recycle Count=0Allowed Consec Service Failures=0.Change the value for Max Instances to the maximum number of parallel processes that you want to run at once.
Use the Server Definition page (SERVERDEFN) to define the maximum concurrent processes for Application Engine processes.
Navigation:
Field or Control |
Description |
|---|---|
Process Type and Max Concurrent |
For the Application Engine process type, enter the maximum number of parallel processes that you run at once. This figure must be the same as or greater than the maximum instances that you defined for PSAdmin. |
Use the AR Parallel Processing Options page (PARALLEL_AR_SBP) to specify the exact number of parallel processes or partitions that you want for statements.
Navigation:
Click the Parallel Processing Options link.
Field or Control |
Description |
|---|---|
Parallel Process and Maximum Partitions |
Enter the exact number of partitions or parallel processes that you want to run for the AR_STMT parallel process. |
Use the Job Definition page (PRCSJOBDEFN) to add additional Statements process definitions to run the AR_STMT multiprocess job.
Navigation:
This example illustrates the fields and controls on the Job Definition page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Run Mode |
Always select Parallel. |
Process Type and Process Name |
Enter Application Engine for the type and select from AR_STMT2 to AR_STMT8 for each separate partition or process that you want to run. If you define additional process definitions, select the name of the definitions that you added. Note: You must have the same number of rows in the process list as you enter in the Maximum Partitions field on the AR Parallel Processing Options page. |
Run Always On Warning and Run Always On Error |
You must select these check boxes. |
Use the Process Definition page (PRCSDEFN) to add additional Statements process definitions if you need to run more than eight parallel processes.
Navigation:
Complete the fields on this page and the other pages in the Process Definition component (PRCSDEFN) to match the AR_STMT1 process definition with two exceptions:
Use another name.
Use another description.
Use this format for the name: AR_STMT#, for example AR_STMT9.