Previous Next JavaScript must be enabled to correctly display this content

## 6.1 Prerequisites

This topic provides the information of Prerequisites.

1. Create a new schema for PLATO-REPORT-SERVICE in your domain.
2. Ensure that the datasource is created in weblogic server:

   Data Source | Weblogic Server | Schema
   --- | --- | ---
   PLATOCMC | Jdbc/CMNCORE | Plato Common Core Server
   PLATOSMS | jdbc/sms | Plato-SMS-Server
   REPORTSERVICE | jdbc/REPORTSERVICE | Plato-Report-Service-Server

3. Enter the below properties in the setuseroverrides.sh file:

   `flyway.domain.placeholders.report-service.hostname= <http://<REPORT_SERVICE_HOSTNAME>:<REPORT_SERVICE_PORT>`

   `flyway.domain.placeholders.report-service.server.port=<REPORT_SERVICE_PORT>`

   `flyway.domain.placeholders.report-service.domain.jndi=jdbc/REPORTSERVICE`

   `flyway.domain.placeholders.report-service.template-metadata-directory=/scratch/OBMA/report-service/template_metadata`

   `flyway.domain.placeholders.report-service.output-directory=/scratch/OBMA/report-service/output/`

   `flyway.domain.placeholders.report-service.fop-config-file=/scratch/OBMA/report-service/fop.xconf`

   Note:

   Refer to Oracle Banking Microservices Platform Foundation Installation Guide for a detailed explanation.
4. Create the folder structure mentioned in Step 3.
5. Download fop.xconf file and place in the directory: /scratch/OBMA/report-service.
6. Restart plato-config-service.
7. Deploy plato-report-services.

   Once the plato-report-service deployed successfully, make sure that the below tables created in the PLATO-REPORT-SERVICE schema.

   - ERTB_MSGS
   - flyway_schema_history
   - OBMA_DOCUMENT_STORE
   - OBMA_EXTRACTOR_CONFIG
   - OBMA_REPORT_LOG
   - OBMA_TEMPLATE_IMAGE
   - OBMA_TM_REPORT_METADATA
   - OBMA_TM_TEMPLATE_IMAGE
   - OBMA_TM_TEMPLATE_METADATA
   - OBMA_TW_REPORT_METADATA
   - OBMA_TW_TEMPLATE_IMAGE
   - OBMA_TW_TEMPLATE_METADATA
8. Deploy oblm-report-services.
9. Once the oblm-report-services is deployed, ensure the below table is added in LMR schema.
   - LMR_TB_ADVICE

Parent topic: FOP Advices