E Appendix: AP CS Scheduling in JOS/POM
AP CS provides a default job schedule with a detailed list of jobs with pre-defined dependencies with RI and AIF schedules in RAP integration. The customer can easily customize their batch process by controlling the batch control files without changing the batch schedule. Each batch job in AP is connected to hooks in the batch control files that can be changed by customers. The AP job flow only contains daily and weekly jobs. Jobs scheduled daily are scheduled to run every day. Jobs scheduled to run weekly are scheduled to run only on Sunday by default.
The following table shows the list of jobs in the AP Schedule. Only jobs with Template configuration entries are pre-configured for the AP Template version. The rest of the jobs are placeholder jobs to allow changes to the schedule of the jobs or to add more jobs by changing the batch control file. Each AP job calls the same set names in the batch control file without _JOB in the name which in turn allows it to call the respective *hook jobs, so even if it is not linked to a batch set. The batch can be controlled without changing the job flow by adding or changing the hooks.
If AP CS is not the first planning application deployed in RAP and if another planning application such as MFP or RDF is already deployed, then set Primary to Load Common Data to false under the Planning Administration -> Batch Setup in show/hide, to avoid trying to load the common data again for shared planning applications through the JOS/POM schedule.
For more details about the implementation of JOS/POM, see the Oracle Retail Predictive Application Server Cloud Edition Implementation Guide. For more details about how to use JOS/POM to schedule and maintain the job flows, see the Oracle Retail JOS/POM User Guide.
| AP Job Name | Description/Comments | Daily/Weekly | Template Configuration |
|---|---|---|---|
|
AP_PRE_EXP_START_JOB |
Dummy Job, to specify the start of pre-batch exports. |
Daily |
|
|
AP_PRE_EXP_RDX_D_JOB |
To schedule any daily plan exports to RAP integration before the calc cycle. |
Daily |
|
|
AP_PRE_EXP_OBS_D_JOB |
To schedule any daily plan exports to Object Storage before the calc cycle. |
Daily |
Exports Standard Plans, if the Export Daily Plans Boolean is enabled. |
|
AP_PRE_EXP_RDX_W_JOB |
To schedule any weekly plan exports to RAP integration before the calc cycle. |
Weekly |
Exports Plans to RI, if RDX is enabled. |
|
AP_PRE_EXP_OBS_W_JOB |
To schedule any weekly plan exports to Object Storage before the calc cycle. |
Weekly |
Exports Standard Plans Weekly, if the Export Weekly Plans Boolean is enabled. Also exports to Allocation if DRDVALLOCB is enabled. |
|
AP_PRE_EXP_END_JOB |
Dummy job to specify the end of pre-batch exports. |
Daily |
|
|
AP_COM_HIER_IMP_START_JOB |
Dummy job to specify the start of a common hierarchies import. |
Daily |
|
|
AP_COM_HIER_IMP_RDX_D_JOB |
To schedule any daily common hierarchy imports from RAP integration. |
Daily |
|
|
AP_COM_HIER_IMP_OBS_D_JOB |
To schedule any daily common hierarchy imports from Object Storage. |
Daily |
|
|
AP_COM_HIER_IMP_RDX_W_JOB |
To schedule any weekly common hierarchy imports from RAP integration. |
Weekly |
Imports hierarchies from RI, if RDX is enabled. |
|
AP_COM_HIER_IMP_OBS_W_JOB |
To schedule any weekly common hierarchy imports from Object Storage. |
Weekly |
Loads hierarchy files from Object Storage, if uploaded. |
|
AP_COM_HIER_IMP_END_JOB |
Dummy Job, to specify the end of a common hierarchies import. |
Daily |
|
|
AP_COM_DATA_IMP_START_JOB |
Dummy job to specify the start of common data imports. |
Daily |
|
|
AP_COM_DATA_IMP_RDX_D_JOB |
To schedule any daily common data imports from RAP integration. |
Daily |
|
|
AP_COM_DATA_IMP_OBS_D_JOB |
To schedule any daily common data imports from Object Storage. |
Daily |
|
|
AP_COM_DATA_IMP_RDX_W_JOB |
To schedule any weekly common data imports from RAP integration. |
Weekly |
Imports data files from RI, if RDX is enabled. |
|
AP_COM_DATA_IMP_OBS_W_JOB |
To schedule any weekly common data imports from Object Storage. |
Weekly |
Loads data files from Object Storage, if uploaded. |
|
AP_COM_DATA_IMP_END_JOB |
Dummy job to specify the end of common data imports. |
Daily |
|
|
AP_HIER_IMP_START_JOB |
Dummy job to specify the start of application-specific hierarchies import. |
Daily |
|
|
AP_HIER_IMP_RDX_D_JOB |
To schedule any daily application-specific hierarchy imports from RAP integration. |
Daily |
|
|
AP_HIER_IMP_OBS_D_JOB |
To schedule any daily application-specific hierarchy imports from Object Storage. |
Daily |
|
|
AP_HIER_IMP_RDX_W_JOB |
To schedule any weekly application-specific hierarchy imports from RAP integration. |
Weekly |
Imports application-specific hierarchies from RI, if RDX is enabled. |
|
AP_HIER_IMP_OBS_W_JOB |
To schedule any weekly application-specify hierarchy imports from Object Storage. |
Weekly |
Imports any application-specific hierarchies from Object Storage. |
|
AP_HIER_IMP_END_JOB |
Dummy job to specify the end of application-specific hierarchies import. |
Daily |
|
|
AP_PRE_DATA_IMP_START_JOB |
Dummy job to specify the start of application-specific data imports before the calc cycle. |
Daily |
|
|
AP_PRE_DATA_IMP_RDX_D_JOB |
To schedule any daily application-specific data imports from RAP integration before the calc cycle. |
Daily |
|
|
AP_PRE_DATA_IMP_OBS_D_JOB |
To schedule any daily application-specific data imports from Object Storage before the calc cycle. |
Daily |
|
|
AP_PRE_DATA_IMP_RDX_W_JOB |
To schedule any weekly application-specific data imports from RAP integration before the calc cycle. |
Weekly |
|
|
AP_PRE_DATA_IMP_OBS_W_JOB |
To schedule any weekly application-specific data imports from Object Storage before the calc cycle |
Weekly |
|
|
AP_PRE_DATA_IMP_END_JOB |
Dummy Job to specify the end of application-specific data imports before the calc cycle |
Daily |
|
|
AP_BATCH_AGG_START_JOB |
Dummy job to specify the start of the Batch Aggregation Cycle. |
Daily |
|
|
AP_BATCH_AGG_D_JOB |
To schedule any daily batch aggregation jobs. |
Daily |
Runs Daily Batch Calcs or Aggregations. |
|
AP_BATCH_AGG_W_JOB |
To schedule any weekly batch aggregation jobs. |
Weekly |
Runs Weekly Batch Calcs or Aggregations. |
|
AP_BATCH_AGG_END_JOB |
Dummy job to specify the end of the Batch Aggregation Cycle. |
Daily |
|
|
AP_POST_DATA_IMP_START_JOB |
Dummy job to specify the start of application-specific data imports after the calc cycle. |
Daily |
|
|
AP_POST_DATA_IMP_RDX_D_JOB |
To schedule any daily application-specific data imports from RAP integration after the calc cycle. |
Daily |
|
|
AP_POST_DATA_IMP_OBS_D_JOB |
To schedule any daily application-specific data imports from Object Storage after the calc cycle. |
Daily |
|
|
AP_POST_DATA_IMP_RDX_W_JOB |
To schedule any weekly application-specific data imports from RAP integration after the calc cycle. |
Weekly |
Imports data from, enabled Interfaces from AIF, if RDX is enabled. |
|
AP_POST_DATA_IMP_OBS_W_JOB |
To schedule any weekly application-specific data imports from Object Storage after the calc cycle. |
Weekly |
|
|
AP_POST_DATA_IMP_END_JOB |
Dummy Job, to specify the end of application-specific data imports after the calc cycle. |
Daily |
|
|
AP_POST_EXP_START_JOB |
Dummy job to specify the start of post-batch exports. |
Daily |
|
|
AP_POST_EXP_RDX_D_JOB |
To schedule any daily data exports from RAP integration after the calc cycle. |
Daily |
|
|
AP_POST_EXP_OBS_D_JOB |
To schedule any daily data exports from Object Storage after the calc cycle. |
Daily |
|
|
AP_POST_EXP_RDX_W_JOB |
To schedule any weekly data export from RAP integration after the calc cycle. |
Weekly |
Exports data from, enabled Interfaces to AIF, if RDX is enabled. |
|
AP_POST_EXP_OBS_W_JOB |
To schedule any weekly data exports from Object Storage after the calc cycle. |
Weekly |
|
|
AP_POST_EXP_END_JOB |
Dummy job to specify the end of post-batch exports. |
Daily |
|
|
AP_WB_BUILD_START_JOB |
Dummy job to specify the start of workbook build/refresh jobs. |
Daily |
|
|
AP_WB_BUILD_D_JOB |
To schedule any workbook build/refresh steps daily. |
Daily |
Runs daily scheduled workbook builds and refresh. |
|
AP_WB_BUILD_W_JOB |
To schedule any workbook build/refresh steps weekly. |
Weekly |
Runs weekly scheduled workbook builds and refresh. |
|
AP_WB_BUILD_END_JOB |
Dummy job to specify the end of workbook build/refresh jobs. |
Daily |
|
|
AP_STATS_START_JOB |
Server level job to get Offer metric status. |
Weekly |
|
|
AP_ADHOC_XX_JOB |
To schedule any adhoc jobs with the batch execution set name as a parameter. XX varies from 01 to 10. 10 Jobs available to schedule any adhoc steps with any set name as the parameter. |
Adhoc |
|
Even if a customer is using a non-template version of the application, they should have the following entries in their batch control file (batch_exec_list.txt) with the necessary hooks connected to the customer job steps in order to execute those steps using pre-defined AP jobs from JOS/POM.
Generic schedule mapping in JOS/POM
AP_PRE_EXP_RDX_D | exec | *hook_AP_PRE_EXP_RDX_D
AP_PRE_EXP_OBS_D | exec | *hook_AP_PRE_EXP_OBS_D
AP_PRE_EXP_RDX_W | exec | *hook_AP_PRE_EXP_RDX_W
AP_PRE_EXP_OBS_W | exec | *hook_AP_PRE_EXP_OBS_W
AP_COM_HIER_IMP_RDX_D | exec | *hook_AP_COM_HIER_IMP_RDX_D
AP_COM_HIER_IMP_OBS_D | exec | *hook_AP_COM_HIER_IMP_OBS_D
AP_COM_HIER_IMP_RDX_W | exec | *hook_AP_COM_HIER_IMP_RDX_W
AP_COM_HIER_IMP_OBS_W | exec | *hook_AP_COM_HIER_IMP_OBS_W
AP_COM_DATA_IMP_RDX_D | exec | *hook_AP_COM_DATA_IMP_RDX_D
AP_COM_DATA_IMP_OBS_D | exec | *hook_AP_COM_DATA_IMP_OBS_D
AP_COM_DATA_IMP_RDX_W | exec | *hook_AP_COM_DATA_IMP_RDX_W
AP_COM_DATA_IMP_OBS_W | exec | *hook_AP_COM_DATA_IMP_OBS_W
AP_HIER_IMP_RDX_D | exec | *hook_AP_HIER_IMP_RDX_D
AP_HIER_IMP_OBS_D | exec | *hook_AP_HIER_IMP_OBS_D
AP_HIER_IMP_RDX_W | exec | *hook_AP_HIER_IMP_RDX_W
AP_HIER_IMP_OBS_W | exec | *hook_AP_HIER_IMP_OBS_W
AP_PRE_DATA_IMP_RDX_D | exec | *hook_AP_PRE_DATA_IMP_RDX_D
AP_PRE_DATA_IMP_OBS_D | exec | *hook_AP_PRE_DATA_IMP_OBS_D
AP_PRE_DATA_IMP_RDX_W | exec | *hook_AP_PRE_DATA_IMP_RDX_W
AP_PRE_DATA_IMP_OBS_W | exec | *hook_AP_PRE_DATA_IMP_OBS_W
AP_BATCH_AGG_D | exec | *hook_AP_BATCH_AGG_D
AP_BATCH_AGG_W | exec | *hook_AP_BATCH_AGG_W
AP_POST_DATA_IMP_RDX_D | exec | *hook_AP_POST_DATA_IMP_RDX_D
AP_POST_DATA_IMP_OBS_D | exec | *hook_AP_POST_DATA_IMP_OBS_D
AP_POST_DATA_IMP_RDX_W | exec | *hook_AP_POST_DATA_IMP_RDX_W
AP_POST_DATA_IMP_OBS_W | exec | *hook_AP_POST_DATA_IMP_OBS_W
AP_POST_EXP_RDX_D | exec | *hook_AP_POST_EXP_RDX_D
AP_POST_EXP_OBS_D | exec | *hook_AP_POST_EXP_OBS_D
AP_POST_EXP_RDX_W | exec | *hook_AP_POST_EXP_RDX_W
AP_POST_EXP_OBS_W | exec | *hook_AP_POST_EXP_OBS_W
AP_WB_BUILD_D | exec | *hook_AP_WB_BUILD_D
AP_WB_BUILD_W | exec | *hook_AP_WB_BUILD_W
AP_STATS_OFFER_W | exec | *hook_AP_STATS_OFFER_W
Note: The AP_STATS_OFFER_W job is connected to the hook step hook_AP_STATS_OFFER_W that executes the pre-defined system task offer metrics. It is an optional job which provides the stats specific to offer metrics. For more details about this job, see the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.
External Dependencies:
In RAP Integration, AP gets data from RI and AIF. Those dependencies are pre-defined in the schedule. The following table shows the pre-defined dependencies of the AP jobs The customer needs to enable those dependencies based on the modules enabled on the RI and AIF side, so that the dependent job on the AP side waits for the completion of that interface on the source side.
| JobName | ExternalScheduleName | ExternalPredecessorJobName |
|---|---|---|
|
RPASCE_HIER_IMP_START_JOB |
RI |
RDX_EXPORT_DIM_MILE_MARKER_JOB |
|
RPASCE_DATA_IMP_START_JOB |
RI |
RDX_EXPORT_FACT_MILE_MARKER_JOB |
|
AP_POST_DATA_IMP_START_JOB |
AIF |
RSE_AP_FCST_EXPORT_JOB |
|
AP_POST_DATA_IMP_START_JOB |
AIF |
DT_EXPORT_END_JOB |
|
AP_POST_DATA_IMP_START_JOB |
AIF |
AC_CLUSTER_SET_EXPORT_END_JOB |
|
AP_POST_DATA_IMP_START_JOB |
AIF |
SPO_EXPORT_END_JOB |