Go to primary content
Oracle® Retail Predictive Application Server Cloud Edition Administration Guide
Release 22.2.401.0
F72005-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

7 Batch Administration

This chapter addresses the following batch administration tasks:

Application-Specific Batch Tasks

The application-configured batch tasks are a set of tasks that help the administrator perform routine batch processing operations, either in a recurring schedule (such as nightly and/or weekly) or loading and exporting a predefined set of data and hierarchies. These tasks are found in the Online Administration Tools as Configured Batch Tasks.

Each task in turn calls one or more batch services to do the required tasks. The catalog of available batch services to configure is listed and described in the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide.

. Some tasks require data files (such as measure/fact load files or hierarchy/dimension load files) as input. These files must be uploaded via Object Storage before the tasks are scheduled. Some tasks export files from the application's data store. Those files are copied to the Object Storage location, and Administrators can download these exported files. For more information, see "Uploading and Downloading Data Files."

The following table shows the list of Online Admin task entries available for running or scheduling the application-configured batch tasks. Note that these are only a selection of the configured task types available. Any that are not directly available here may be run by executing the Batch Task Group of which they are a part.

Configured Batch Tasks
Run Batch Task Group
Run Batch Measure Load Group
Run Batch Measure Export Group
Run Batch Calc Group

Run Batch Task Group

This task is used to schedule a predefined set of batch tasks in a sequential order. The batch control file batch_exec_list.txt defines the steps in the specific order that will be executed during batch task execution. This task is typically used to schedule a daily or weekly batch. If any task aborts, a log is created and the process terminates. This task has the option to restart from the last failed service rather than running all the completed services again.

Depending on the type of application implementation, the Run Batch Task Group task can either be extended (see the application-specific Implementation Guides) or completely customized (see RPASCE Implementation Guide), via the batch_exec_list.txt control file. For more details about the list of internal services this task can call and how to change the order of services to this task, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide.

Run Batch Measure Load Group

This task is used to load a predefined set of measures grouped as a measure set in the batch control file batch_loadmeas_list.txt. All required data files must be uploaded to the Object Storage location before scheduling this task. For more information, see "Uploading and Downloading Data Files." If no file is present to load a particular measure in that measure set, it will be logged as not found and skipped. This process will only load the data into those measures and will not run any subsequent calculations. (If follow-on operations such as calculations or workbook refreshes are desired, then the Batch Task Group must be used, rather than the Measure Load Group.)

The Run Batch Measure Load Group task can be customized to load different sets of measures by making changes to the batch control file. For information about changing the batch control files and how to upload them, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide.

Run Batch Measure Export Group

This task exports a predefined set of measure data into flat files. The set of measures to be exported are defined in the batch control file batch_exportmeas_list.txt. This set of exported data can be used for integration with other applications. Exported files from this task are put into the Object Storage location; the administrator can download the files from this location. For more information, see "Uploading and Downloading Data Files."

The Run Batch Measure Export Group task can be customized by changes to the batch control file. For information about changing the batch control files and how to upload them, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide.

Run Batch Calc Group

This task is used to run a predefined set of batch rules to do the necessary data processing, as defined in the batch control file batch_calc_list.txt. The Run Batch Calc group task can be customized to change the batch calculations and the order in which they run against the application by changing the batch control file. For information about changing the batch control files and how to upload them, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide.

Uploading and Downloading Data Files

Oracle Cloud Infrastructure Object Storage service is used to upload and download data files for batch processing.

A public API has been provided to perform various actions on Object Storage.

A sample scripts is available in Retail Analytics Platform Implementation Guide. Download and save the script and update the environment variables in the script.Sample usages of scripts assuming the script has been saved as fts.sh.

  • fts.sh ping

  • fts.sh listprefixes

  • fts.sh listfiles <prefix>

  • fts.sh uploadfiles <prefix> <file1 <file2>

  • fts.sh downloadfiles <prefix> <file1> <file2>

  • fts.sh deletefiles <prefix> <file1>

Here is an example prefix: planning/<Your-SubNameSpace>/incoming/input.