3.1.7 Entity Staging Clean-up

This topic provides information about the Entity Staging Clean-up process.

This batch will clean up the data from the staging area like account, account party, payment, re-payment, bill details and will make staging area ready for the next batch run.

Prerequisite: All staging table for cleanup activity to be configured in lookup for lookup code ENTITY_STAGING_TABLES

Job Name: obcr-entity-staging-cleanup-batch

Dependent Batch/Job: Not Applicable

Multi-threaded: No

Multi-stream: No

URI: <protocol>://obcr-entity-services/jobLauncher/runBatch/

Mandatory Headers:

Table 3-14 Mandatory Headers

Parameter Name Value Mandatory Description
appld CRENTITY Yes The application ID of the host service.

Specify following parameters while executing this batch:

Table 3-15 Parameters

Parameter Name Value Mandatory Description
runDate 16062019 Yes It must be in ddmmyyyy format.
branchCode DMO Yes Branch code of the project.
userId ADMINUSER1 Yes User id of the user.
Success/Failure Details:
  • User can verify the record level status in the following tables in CR_ENTITY schema.

    DM_ENTITY_STAGING_DRIVER

  • For a successful processing of a record, the below condition should be satisfied.

    ERROR_CODE = Success and PROCESS_RESULT = 1