1. Oracle Banking Corporate Lending - OFSAA Integration guide
  2. OBCL - OFSAA Integration
  3. Prerequisites
  4. Prerequisites in Oracle Banking Corporate Lending
  5. Maintenances

1.2.1.1 Maintenances

Complete the maintenances discussed below.

Maintaining Batch Programs

You need to maintain the batch program OLXTRACT using Mandatory Batch Program Maintenance (EIDMANPE) screen. This batch extracts the data from Oracle FLEXCUBE during End of Financial Input (EOFI) stage. It is recommended that the extraction of data from OBCL is done from the reporting environment and not the production environment. You also need to maintain the extraction routine.

Maintaining Extraction Routines

You can maintain the data extraction routines in the maintenance table called OLTMS_DEST_ES_TABLES. This table is used to maintain extraction routines and should be maintained manually with the following values along with other details.
  • 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 OLTB_EIS_CS_PARAM. In this table the KEYID is the primary key.

Parent topic: Prerequisites in Oracle Banking Corporate Lending