E Appendix: APCS Scheduling in JOS/POM
APCS 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 APCS is connected to hooks in the batch control files that can be changed by customers. The APCS 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 APCS Schedule. Only jobs with Template configuration entries are pre-configured for the APCS 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 APCS 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.
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.
APCS 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_EGRS_EXP_START_JOB |
Dummy job to specify the start of Egress Export jobs. |
Daily |
|
AP_EGRS_EXP_RDX_D_JOB |
Daily export of hierarchy and actuals data to RDX for Egress. |
Daily |
|
AP_EGRS_EXP_RDX_W_JOB |
Weekly export of hierarchy and actuals data to RDX for Egress. |
Weekly |
|
AP_EGRS_EXP_END_JOB |
Dummy job to specify the end of Egress Export jobs. |
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_EGRS_EXP_RDX_D_JOB | exec | *hook_AP_EGRS_EXP_RDX_D
AP_EGRS_EXP_RDX_W_JOB | exec | *hook_AP_EGRS_EXP_RDX_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.
Note:
AP_EGRS_EXP_* jobs are placeholder jobs needed only for Egress customers migrated to a new release to export their hierarchy and actuals data to RDX so that AI Foundation can use the data to generate forecasts. Those jobs will execute batch steps in GA only when the Egress Export Hierarchies and Egress Export Actuals Boolean flags are enabled using the Measure Analysis template. New customers in RAP can ignore these jobs if they are getting standard hierarchies and actuals from RAP.
Note:
In Multi-App setup, only one application should import the common shared hierarchies using the *COM_HIER_IMP * jobs. In GA apps, it is controlled by the shared Boolean measure Primary to Load Common Data. If APCS is not the first planning application deployed in RAP and if another planning application such as MFPCS or RDFCS is already deployed, then set Primary to Load Common Data to true in only one of the applications 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. If not set by the user in GA apps, that Boolean will be set to true only for the first deployed GA application for which the initial post build batch is run.
External Dependencies:
In RAP Integration, APCS gets data from RI and AIF. Those dependencies are pre-defined in the schedule. The following table shows the pre-defined dependencies of the APCS 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 APCS 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 |