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

   Table 6-1 Data Source List

   Data Source Name	Data Source JNDI	Targets
   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 plato-config-deploy.env 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/obvam/report-service/template_metadata
   flyway.domain.placeholders.report-service.output-directory=/scratch/obvam/report-service/output/
   flyway.domain.placeholders.report-service.fop-config-file=/scratch/obvam/report-service/fop.xconf

   Note:

   Refer to Oracle Banking Microservices Platform Foundation Installation Guide for a detailed explanation.
4. Create the folder structure as mentioned in Step 3.
5. Download fop.xconf file and place in the below directory:
   /scratch/obvam/report-service
6. Restart plato-config-service.
7. Deploy plato-report-services.
   Once the plato-report-service deployed successfully, ensure 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 obvam-statement-services.
9. Once the obvam-statement-services is deployed, ensure the below table is added in VAS schema.
   • VAS_TB_ADVICE

For Template Upload process, refer to Report Template topic in Oracle Banking Microservices Platform Foundation User Guide.

Naming convention for Report name for creating Report Linkage: OBVAM-Statement-Advice.

Download AccountStatement.xsl the Account Statement template.

User can generate the statement advice in usual way, either by batch process or adhoc statement generation process.