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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms