My Oracle Support Banner

Java Batch Processor For OPA (Doc ID 1944563.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Policy Automation - Version and later
Information in this document applies to any platform.


Need to fetch several fields from various database tables for executing Business Rules implemented in OPA and dump data into another Database tables.,
Table A-Fields AA(int),AB(String)---AA is Primary Key
Table B-Fields BB(int),BC(String)---BB is Primary Key
Table C-Fields CC(int),CD(String)---CC is Primary Key
Table D-Fields DD(int),DE(String)---DD is Primary Key
Table E-Fields EE(int),EF(String),EG,EH,EI----EE is Primary Key
Table F--Fields FF(int),FG(String)----FF is Primary Key

created Business Rules in OPA which read fields values from AB,BC,CD,DE,EF by Java Batch Processor and dump into Fields values EF,EG,EH,EI and FG (OPA processing result data will be publish into Table E , Table F)

can it be possible with out creating SQL view or if possible in SQL view (Doc ref- and Samples/Eg_Batch_Processor_using_with_dbase.htm%3FTocPath%3DTutorials%20and%20examples%7C_____28) then how can result data inserted into View and its original database tables .

The customer  have to make a updatable view  but what about data accessing from  various database schema in same and different database (only Databases which support by OPA batch Processor)  .
Is it possible to map in single config.xml file or have to  create isolatedly


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.