1.3.1 Maintenance

Perform the maintenance as discussed below.

• Maintain Batch Programs
  This topic describes maintenance of batch programs.
• Maintain Extraction Routines
  The Maintaining Extraction Routines topic explains the maintenance of the data extraction routines in the maintenance table called ESTM_TR_DEST_TABLES.

1.3.1.1 Maintain Batch Programs

This topic describes maintenance of batch programs.

You need to maintain the batch program EMXTRACT using Mandatory Batch Program Maintenance (EIDMANPE) screen. This batch extracts the data from Oracle Banking Treasury Management during end of financial input (EOFI) stage. It is recommended that the extraction of data from Oracle Banking Treasury Management is done from the reporting environment and not the production environment. You also need to maintain the extraction routine.

1.3.1.2 Maintain Extraction Routines

The Maintaining Extraction Routines topic explains the maintenance of the data extraction routines in the maintenance table called ESTM_TR_DEST_TABLES.

The below table is used to maintain extraction routines and must be maintained manually with the following values along with other details:

Table 1-2 ESTM_TR_DEST_TABLES Details

Column Name	Description
ORD_OF_EXT	Order of extraction in which routine will be executed. This should be a unique value.
TABLE_NAME	Name of the staging table to be populated with data.
ROUTINE	Routine to be executed. The format should be ‘Package.procedure’
INTEGRATION_NAME	OFSAA

All the parameters such as extraction date, previous extraction date, log required and so on are maintained in maintenance table ‘CSTB_TR_EIS_PARAM’. In this table the KEYID is the primary key.