C Appendix: IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Scheduling in JOS/POM
IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment 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 IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment is connected to hooks in the batch control files that can be changed by customers. The IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment job flow only contains daily and weekly jobs. Jobs scheduled daily are scheduled to run every day and jobs scheduled to run weekly are scheduled to run only on Sunday by default.
Table C-1 shows the list of jobs in IPOCS-Demand Forecasting / IPOCS-Lifecycle
Allocation and Replenishment Schedule. Most jobs are pre-configured
for the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and
Replenishment GA 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 IPOCS-Demand Forecasting / IPOCS-Lifecycle
Allocation and Replenishment job calls the same set names in the batch
control file without _JOB in the name, which in turn allows it to
call 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.
POM Business Date and RPAS_TODAY
Retail Insights (RI) requires that the internal business date be set to the last date the data is being loaded into the system. Merch also has a similar requirement. So if Saturday is at the end of week or the last sales day for that week, then the business date must be set to Saturday.
To align with that requirement and reduce support issues, it is better for the POM Business date to be set as a Saturday date (end of week date).
For IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment, the POM Business date also flows as the RPAS_TODAY and is set as the default Forecast Start Date. Since the Forecast Start Date must start from Sunday rather than Saturday, an implementer will need to set the following PDS property using OAT.
OAT -> List/Set/Unset PDS Environment Variables -> RPAS_TODAY_DELTA_JOS_POM=+1 and checked numeric type.
Note:
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.
List of Jobs in IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Schedule
The following table provides a list of jobs in the IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment schedule.
Table C-1 List of Jobs in IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Schedule
| IPOCS-Demand Forecasting / IPOCS-Lifecycle Allocation and Replenishment Job Name | Description/Comments | Daily/Weekly | GA Configuration |
|---|---|---|---|
|
IPO_INIT_EXP_START_JOB |
Dummy Job to specify the start of initial batch exports. |
Daily |
|
|
IPO_INIT_EXP_RDX_D_JOB |
To schedule any daily data exports to RAP integration before the calc cycle. |
Daily |
|
|
IPO_ INIT_EXP_OBS_D_JOB |
To schedule any daily data exports to Object Storage before the calc cycle. |
Daily |
|
|
IPO_ INIT_EXP_RDX_W_JOB |
To schedule any weekly data exports to RAP integration before the calc cycle. |
Weekly |
|
|
IPO_ INIT_EXP_OBS_W_JOB |
To schedule any weekly data exports to Object Storage before the calc cycle. |
Weekly |
|
|
IPO_ INIT_EXP_END_JOB |
Dummy job to specify the end of initial batch exports. |
Daily |
|
|
IPO_COM_HIER_IMP_ START_JOB |
Dummy job to specify the start of a common hierarchies import. |
Daily |
|
|
IPO_COM_HIER_IMP_ RDX_D_JOB |
To schedule any daily common hierarchy imports from RAP integration. |
Daily |
Imports common hierarchies from RI. |
|
IPO_COM_HIER_IMP_OBS_ D_JOB |
To schedule any daily common hierarchy imports from Object Storage. |
Daily |
Loads common hierarchy files from Object Storage, if uploaded. |
|
IPO_COM_HIER_IMP_ RDX_W_JOB |
To schedule any weekly common hierarchy imports from RAP integration. |
Weekly |
Imports common hierarchies from RI. |
|
IPO_COM_HIER_IMP_OBS_ W_JOB |
To schedule any weekly common hierarchy imports from Object Storage. |
Weekly |
Loads common hierarchy files from Object Storage, if uploaded. |
|
IPO_COM_HIER_IMP_ END_JOB |
Dummy Job, to specify the end of a common hierarchies import. |
Daily |
|
|
IPO_COM_DATA_IMP_ START_JOB |
Dummy job to specify the start of common data imports. |
Daily |
|
|
IPO_COM_DATA_IMP_ RDX_D_JOB |
To schedule any daily common data imports from RAP integration. |
Daily |
|
|
IPO_COM_DATA_IMP_ OBS_D_JOB |
To schedule any daily common data imports from Object Storage. |
Daily |
|
|
IPO_COM_DATA_IMP_ RDX_W_JOB |
To schedule any weekly common data imports from RAP integration. |
Weekly |
|
|
IPO_COM_DATA_IMP_ OBS_W_JOB |
To schedule any weekly common data imports from Object Storage. |
Weekly |
|
|
IPO_COM_DATA_IMP_ END_JOB |
Dummy job to specify the end of common data imports. |
Daily |
|
|
IPO_HIER_IMP_START_JOB |
Dummy job to specify the start of application-specific hierarchies import. |
Daily |
|
|
IPO_HIER_IMP_RDX_D_ JOB |
To schedule any daily application-specific hierarchy imports from RAP integration. |
Daily |
Imports application-specific hierarchies from RI or AIF. |
|
IPO_HIER_IMP_OBS_D_ JOB |
To schedule any daily application-specific hierarchy imports from Object Storage. |
Daily |
Load any Application specific hierarchies from Object Storage. |
|
IPO_HIER_IMP_RDX_W_ JOB |
To schedule any weekly application-specific hierarchy imports from RAP integration. |
Weekly |
Imports application-specific hierarchies from RI or AIF. |
|
IPO_HIER_IMP_OBS_W_ JOB |
To schedule any weekly application-specify hierarchy imports from Object Storage. |
Weekly |
Load any Application specific hierarchies from Object Storage. |
|
IPO_HIER_IMP_END_JOB |
Dummy job to specify the end of application-specific hierarchies import. |
Daily |
|
|
IPO_PRE_DATA_IMP_ START_JOB |
Dummy job to specify the start of application-specific data imports before the calc cycle. |
Daily |
|
|
IPO_PRE_DATA_IMP_RDX_ D_JOB |
To schedule any daily application-specific data imports from RAP integration before the calc cycle. |
Daily |
Imports application-specific data from RI or AIF. |
|
IPO_PRE_DATA_IMP_OBS_ D_JOB |
To schedule any daily application-specific data imports from Object Storage before the calc cycle. |
Daily |
Load any application specific data from Object Store. |
|
IPO_PRE_DATA_IMP_RDX_ W_JOB |
To schedule any weekly application-specific data imports from RAP integration before the calc cycle. |
Weekly |
Imports application-specific data from RI or AIF. |
|
IPO_PRE_DATA_IMP_OBS_ W_JOB |
To schedule any weekly application-specific data imports from Object Storage before the calc cycle. |
Weekly |
Load any application specific data from Object Store. |
|
IPO_PRE_DATA_IMP_ END_JOB |
Dummy Job to specify the end of application-specific data imports before the calc cycle. |
Daily |
|
|
IPO_PRE_BATCH_START_ JOB |
Dummy job to specify the start of the Pre Forecast Batch. |
Daily |
|
|
IPO_PRE_BATCH_D_JOB |
To schedule any daily Pre Forecast batch jobs. |
Daily |
|
|
IPO_PRE_BATCH_W_JOB |
To schedule any weekly Pre Forecast batch jobs. |
Weekly |
Runs Weekly Pre Forecast batch jobs. |
|
IPO_PRE_BATCH_END_ JOB |
Dummy job to specify the end of the Pre Forecast batch jobs. |
Daily |
|
|
IPO_PRE_EXP_START_JOB |
Dummy job to specify the start of the Export Forecast Parameters Batch. |
Daily |
|
|
IPO_PRE_EXP_RDX_D_JOB |
To schedule any daily exports of forecast parameters to RAP integration. |
Daily |
|
|
IPO_PRE_EXP_OBS_D_JOB |
To schedule any daily exports of forecast parameters to object store. |
Daily |
|
|
IPO_PRE_EXP_RDX_W_JOB |
To schedule any weekly exports of forecast parameters to RAP integration. |
Weekly |
Runs weekly export of forecast parameters to RAP integration. |
|
IPO_PRE_EXP_OBS_W_JOB |
To schedule any weekly exports of forecast parameters to object store. |
Weekly |
|
|
IPO_PRE_EXP_END_JOB |
Dummy job to specify the end of the Export Forecast Parameters Batch. |
Daily |
|
|
IPO_EGRS_EXP_START_JOB |
IPO Egress Exports Start Job |
Daily |
|
|
IPO_EGRS_EXP_RDX_D_JOB |
IPO Egress Exports to RDX Daily Job |
Daily |
|
|
IPO_EGRS_EXP_RDX_W_JOB |
IPO Egress Exports to RDX Weekly Job |
Weekly |
|
|
IPO_EGRS_EXP_END_JOB |
IPO Egress Exports End Job |
Daily |
|
|
IPO_POST_DATA_IMP_ START_JOB |
Dummy job to specify the start of application-specific data imports from RAP integration. |
Daily |
|
|
IPO_POST_DATA_IMP_ RDX_D_JOB |
To schedule any daily application-specific data imports from RAP integration after the calc cycle. |
Daily |
|
|
IPO_POST_DATA_IMP_ OBS_D_JOB |
To schedule any daily application-specific data imports from Object Storage after the calc cycle. |
Daily |
|
|
IPO_POST_DATA_IMP_ RDX_W_JOB |
To schedule any weekly application-specific data imports from RAP integration after the calc cycle. |
Weekly |
Imports forecast data from AIF. |
|
IPO_POST_DATA_IMP_ OBS_W_JOB |
To schedule any weekly application-specific data imports from Object Storage after the calc cycle. |
Weekly |
|
|
IPO_POST_DATA_IMP_ END_JOB |
Dummy Job, to specify the end of application-specific data imports after the calc cycle. |
Daily |
|
|
IPO_POST_BATCH_START_JOB |
Dummy Job, to specify the start of Post Forecast batch job. |
Daily |
|
|
IPO_POST_BATCH_D_JOB |
To schedule the daily Post Forecast batch job. |
Daily |
Runs daily post forecast batch jobs. |
|
IPO_POST_BATCH_W_JOB |
To schedule the weekly Post Forecast batch job. |
Weekly |
Runs weekly post forecast batch jobs |
|
IPO_POST_BATCH_END_JOB |
Dummy Job, to specify the end of Post Forecast batch job. |
Daily |
|
|
IPO_BATCH_ID_1_JOB |
IPO Batch Intra-Day 1 Job |
Daily |
|
|
IPO_BATCH_ID_2_JOB |
IPO Batch Intra-Day 2 Job |
Daily |
|
|
IPO_POST_EXP_START_JOB |
Dummy Job to specify the start of post forecast batch exports. |
Daily |
|
|
IPO_POST_EXP_RDX_D_ JOB |
To schedule any daily data exports to RAP integration after the calc cycle. |
Daily |
Runs daily exports. |
|
IPO_POST_EXP_OBS_D_ JOB |
To schedule any daily data exports to Object Storage after the calc cycle. |
Daily |
|
|
IPO_POST_EXP_RDX_W_ JOB |
To schedule any weekly data export to RAP integration after the calc cycle. |
Weekly |
Runs weekly exports. |
|
IPO_POST_EXP_OBS_W_ JOB |
To schedule any weekly data exports to Object Storage after the calc cycle. |
Weekly |
|
|
IPO_POST_EXP_END_JOB |
Dummy job to specify the end of post forecast batch exports. |
Daily |
|
|
IPO_WB_BUILD_START_ JOB |
Dummy job to specify the start of workbook build/refresh jobs. |
Daily |
|
|
IPO_WB_BUILD_D_JOB |
To schedule any workbook build/refresh steps daily. |
Daily |
Runs daily dashboard updates. |
|
IPO_WB_BUILD_W_JOB |
To schedule any workbook build/refresh steps weekly. |
Weekly |
Runs weekly dashboard updates. |
|
IPO_WB_BUILD_END_JOB |
Dummy job to specify the end of workbook build/refresh jobs. |
Daily |
|
|
IPO_ADHOC_XX_JOB |
To schedule any adhoc jobs with the batch execution set name as a parameter. XX varies from 01 to 10. |
Adhoc |
|
|
IPO_STATS_START_JOB |
Dummy job to specify start of Offer metric server job. |
Weekly |
|
|
IPO_STATS_OFFER_W_JOB |
Server level job to get Offer metric status. |
Weekly |
|
|
IPO_STATS_END_JOB IPO |
Dummy job to specify end of Offer metric server job. |
Weekly |