Java Batch Processor For OPA
(Doc ID 1944563.1)
Last updated on MARCH 02, 2017
Applies to:Oracle Policy Automation - Version 10.4.4.21.0 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- http://docs.oracle.com/html/E54502_01/toc.htm#Tutorials 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.|