14.2.2 Batch Based Procedure
Cash Flow Processes can also be executed as batch processes. The following approaches are available:
- ICC Batch
To execute the batch with ICC Batch, follow these steps:
1. From the LHS menu, select Common Object Maintenance, select Operations, and then select Batch Maintenance.
2. Create a new batch.
3. Enter the Batch Name and Description.
4. To add a task, click the Add button under the Task Details section.
5. Define the Task ID and Description.
6. Select Components as “WORKFLOW_EXECUTION”.
7. Do not change the default values populated for fields “Datastore Type”, “Datastore Name”, “Primary IP For Runtime processes”.
- Object ID: $objectId
- Workflow: "CASH_FLOW_PROCESS_EXEC"
- Optional Parameters: RUN_P1_DATE:EXECDATE,RUN_P2_INFODOM:OFSCFEINFO,RUN_P3_ID:200023,RUN_P4_USERID:CFEUSER,RUN_P5_DATE_FORMAT:yyyyMMdd,RUN_P6_AS_OF_DATE:EXECDATE,RUN_P7_LEGAL_ENTITY_ID:-1,RUN_P8_LEGAL_HIERARCHY_ID:-1
The value for parameter RUN_P3_ID should be taken from column
PROCESS_ID of table FSI_M_CFE_PROCESS_DETAILS for Cash
Flow Process OR column PROCESS_ID of table FSI_M_CFE_EDITS_DETAILS for Cash
Flow Edits. Replace the value 200023 given against RUN_P3_ID with the value available in the
table for the respective Business Definition.
Replace the value CFEUSER given against RUN_P4_USERID with the logged in user id which will be used to audit the last executed by.
Replace the value -1 given against RUN_P7_LEGAL_ENTITY_ID with the actual legal entity id to process the instruments.
Replace the value -1 given against RUN_P8_LEGAL_HIERARCHY_ID with the actual legal entity hierarchy id. This is required if you process for a parent LE member and want to include its child and descendants. This is the equivalent of LE hierarchy selected in run execution parameters when process is executed from summary UI.
9. Save the rule and Execute the batch with Batch ID and MIS Date.