4 Managing Batches

The Process Orchestration and Monitoring (POM) application is a user interface for scheduling, tracking, and managing batch jobs. As an application administrator, you will be expected to monitor the various batches running in POM and potentially take corrective actions if a batch is in a failed or long-running state. This chapter summarizes the most common activities associated with POM and batch execution and provides references to additional details where available.

Batch Administration Duties

Throughout the project and after you are in a Production environment, the responsibility of monitoring and maintaining batch schedules and processes is divided across multiple groups. Review the information below for a typical breakdown of batch responsibilities.

Initial Configuration: Oracle Cloud Operations deploys batch schedules according to your subscriptions, which come pre-installed with certain basic configurations and enabled or disabled batch programs.

Final Configuration: Customer/Solution Implementation Partner (SI) is responsible for modifying the batch schedules during the project and after go-live in Production, based on their current implementation needs.

Scheduling: Customer/Solution Implementation Partner (SI) uses the POM scheduler to schedule nightly, cyclical, and ad hoc jobs. Oracle is not typically responsible for changing schedule start times after go-live, as it can be done in POM.

Notifications: Customer/Solution Implementation Partner (SI) is responsible for setting up batch notifications using Retail Home and POM. Oracle will not typically alter batch notifications on customer environments (unless needed to change internal notifications of batch status).

Error Resolution: Customer/Solution Implementation Partner (SI) is responsible for resolving issues in non-production environments and restarting batch processes from POM after the errors are resolved. In Production environments, the Customer is responsible for monitoring the batch and resolving errors, if possible (for example, if files are not uploaded on time or uploaded with bad data). In both cases, Service Requests can be raised with Oracle for support.

File Retention: Customer is responsible for retaining backups and archives of any file-based data sent as input to Oracle systems according to their business’s data retention policies. Oracle’s file retention policy for RAP solutions is between 7 and 30 days depending on the OCI region, after which time any incoming or outgoing files may be purged without notice.

Review the table below for a summary of duties broken down by environment type:

Environments	Activities	Responsibility	Support Mechanism
Non-Prod (Dev, Breakfix, Stage)	Batch Monitoring Troubleshooting Data Correction Data File Retention	Customer/SI partner	Service Request
Production	Batch Monitoring Troubleshooting Data Correction	Customer/Oracle	Service Request/ Email groups
Production	Data File Retention	Customer	Service Request

Batch Email Notifications

The primary source of information about the batch status on a daily basis will be the email notifications sent from POM for every batch execution. These emails will contain a summary of the batch status, the longest-running jobs, the total batch duration, and other useful details to help you assess the state of the current batch cycle. To keep the business up-to-date on batch execution status and take action in the case of batch failures, the designated administrators for the Retail Analytics and Planning applications will be expected to receive and review these emails regularly after going live in a production environment.

Figure 4-1 POM Sample Batch Notification

Each batch schedule in POM issues its email notifications. Additionally, POM supports numerous notification types for specific use cases, such as individual job failures and long-running processes. Customers are expected to set up local mailing lists which can receive automated messages from Oracle Cloud applications. To change the recipients on an email notification, access the Notifications interface in Retail Home. Follow these steps to add or update a notification:

1. Log in to Retail Home with a user having Retail Home Administrator privileges (see the section on Application Security Policies for role details if needed).

2. Open the Settings panel and access the Manage Notifications screen.

3. Select Process Orchestration and Monitoring from the dropdown.

   

4. A pre-populated list of supported notifications appears in the table below the dropdown. POM supports many different notification types. For example, the code for batch summary emails is NightlySummaryReportExternal. You can type codes into the Filter box to find specific entries.

   

5. To add email addresses to a notification type, select a row and click the Edit icon. Enter one or more email addresses in the popup menu, separated by spaces. Do not edit the notification type code or name.

   

6. Once a Notification Type has been selected in the previous step, the Notification Groups table refreshes on the right side of the screen. You can add groups to the notification, and all users in these groups will see notifications in their Task panel from POM. Click Create in the Notification Groups table. Enter a name and description for the group of users or roles that you plan to send this notification to.

   

7. Click Add Job Role in the Notification Groups table to add valid roles to the new notification group. Notifications of this type will show up for users with these roles within the Notification Panels throughout Oracle Retail applications.

8. Enter a valid role name (for example, BUYER_JOB) to issue the notifications to all users having that role.

   

Repeat these steps for as many POM notification types as you wish to receive.

Note:

It is not recommended to set up these emails until the implementation is nearing completion, as it could result in spamming email inboxes with many unwanted messages from non-production environments

Batch Monitoring in POM

The POM application provides a Batch Monitoring screen for viewing detailed information about batch schedules, including the current run status of each job in a schedule, and the runtime of completed jobs. Accessing the Batch Monitoring screen requires you to have at least the OCI IAM user group BATCH_VIEWER_JOB. Once you have the necessary user permissions, follow these general steps to monitor the batch:

1. Navigate to POM using the application link provided in Retail Home, or navigate directly to the POM URL, if known.

2. Click the Batch Monitoring link from the navigator menu.

3. Change the business date if you are looking to see batch information for prior runs; otherwise, select an application tile to open the batch details.

4. Select the batch cycle type (nightly / recurring / standalone).

5. Review the information shown on-screen or click Download Cycle Summary to save the information to review offline.

For additional information about this screen, refer to the POM User Guide section on “Batch Monitoring”.

Change Batch Start Time

Another maintenance task that the application administrator may be required to do periodically is to change the start time for a batch cycle. This activity requires you to have the BATCH_SCHEDULE_ADMINISTRATOR_JOB in OCI IAM. The POM application provides a way to configure each batch with a start time following the general steps below:

1. Navigate to POM using the application link provided in Retail Home, or navigate directly to the POM URL, if known.

2. Click the Scheduler Administration link from the navigator menu.

3. Select a schedule tile and frequency that you wish to edit.

4. Select the row displayed in the table and click the Edit action to modify the start time of the batch cycle.

For additional information about this screen, refer to the POM User Guide section on “Scheduler Administration”.

Batch Error Details

When a batch process fails in POM, an email notification should be issued, stating the exact point of failure (assuming notifications are configured). You can also access the Batch Monitoring screen in the POM user interface to view the failed job and download the log information. The steps to download job logs are below:

1. Navigate to POM using the application link provided in Retail Home, or navigate directly to the POM URL, if known.

2. Click the Batch Monitoring link from the navigator menu.

3. Select your schedule and cycle from the available batches.

4. Click the name of a job with an incomplete status. Under the Batch Details screen, locate the table for Executions and click the download link in the Log column.

Review the error log details for the cause of failure. If the error message does not indicate a problem that can be fixed internally (for example, invalid data files, duplicate data rows, or data that violates a key constraint on the interface) then raise an Oracle Service Request for assistance. After batch issues have been resolved, you may restart the batch processing from the point of failure using the POM user interface.

Planning Batches in OAT

If you are using any Planning solution, then POM will not be the only source of batch information that you will be required to access. Planning applications like Merchandise Financial Planning schedule jobs through POM and run ad hoc tasks within the application through Online Administration Tools (OAT). Please refer to the RPASCE Administration Guide and the Administration Guide(s) for your Planning-specific application for more details on managing tasks using OAT.