3.7.5 Reconciliation using Batch Process

You can perform Reconciliation using the Scheduler Services. The steps below use the GL RECON component, which does not require a Service URL selection.

To run the Reconciliation using Batch Process, follow these steps:

1. With the Define Batch feature, it is possible to create new batches and review existing ones. Navigate to the Scheduler Service and click Define Batch.
2. Click + to create a new batch.
3. In the Create Batch screen, enter the following values:
   1. Code (spaces are not allowed in the code section).
   2. Batch Name
   3. Click Save.

   Note:

   The Service Url Name field in the Create Batch screen does not require a selection when using the GL RECON component. Leave it blank.
4. In the Define Task screen, you can define the tasks related to a specific batch.
   1. Navigate to Define Task.
   2. Select the name of the batch that has been created for this task.
5. Click + to create a new task.
6. In the Create Task screen, enter the following values:
   1. Task Code (Spaces are not allowed in the code section). b.
   2. Task Name.
   3. Select the task type as REST.
   4. Select the Component as GL RECON.
   5. Click Save.

   Note:

   When the GL RECON component is selected, the Batch Service URL field is not displayed and does not require configuration.

   Figure 3-55 Define Task

   
   

   

   
   
7. In the Task Parameter section, enter the following values:
   1. Process Name — Select the Reconciliation Definition for which the batch should be executed. Ensure you select the correct definition to avoid errors in the batch process.
   2. Threshold — Enter a numeric threshold value.

      Note:

      The value must be greater than or equal to zero (0). Negative values are not supported. A null (blank) value is also accepted, in which case all data will be inserted into the Ledger Instrument and Reconciliation Difference Audit tables.
   3. Insert Type — Select one of the following options from the dropdown:
      • Insert only — Appends reconciliation data on top of any existing data for the concerned AS_OF_DATE/MIS_DATE. Use this option when different Reconciliation Definitions are being executed for different instrument tables.
      • Truncate And Insert — Truncates all existing data for the concerned AS_OF_DATE/MIS_DATE and inserts fresh reconciliation data. Use this option when intermediate day runs have taken place and a final global run is required.

   Figure 3-56 Task Parameter

   
   

   

   
   
8. Schedule the batch using the Schedule Batch screen.
   1. Navigate to Schedule Batch.
   2. Select the Name of the batch created in Step 1.
   3. Use the Edit Parameters option to review the batch parameters and make any necessary adjustments before execution.
   4. Verify the following before executing:
      • MIS Date — The MIS Date is used as the As-of-Date in the Reconciliation UI. Select the appropriate MIS Date.
      • Confirm that the Process Name and Threshold values entered in Step 7 are correct for the target environment.
   5. Click Execute to run the batch, or click Save to save the batch definition without running it.
      • Clicking Save saves the batch definition without executing the batch.
      • Clicking Execute submits the batch for execution. An Execute Status dialog is displayed confirming the batch has been submitted.
9. Monitor the Batch:
   1. Navigate to Monitor Batch.
   2. Select the batch name and MIS Date, then check the Batch Status.
   3. After the batch completes successfully, navigate to the Balance Reconciliation module to verify the results in the GL Recon Audit report.

Sometimes a batch may fail. The reason for batch failure could be one of the following:

• Selecting an incorrect or invalid Process Name (Reconciliation Definition).
• Entering an invalid Threshold value. Only null or a value ≥ 0 are supported. Negative values are not permitted.
• Not selecting an Insert Type — this field is mandatory.

Note:

The following role mappings to the SKU User group must be present to enable GL RECON listing and execution:

• RCMDREAD
• RCMDADVND

For detailed instructions for defining, executing, and monitoring a Batch, see the Scheduler Service documentation.