Hi,
I am a PL/SQL guy and working on a project to create a dashboard to display different data from different tables. The list of tables will grow as we keep on adding more sites. Wanted to create dashboard page to show information stored on those tables in a ADF table without changing code in future.
Is there any way to implement this? I got many links to do this but did not understand all the steps in full.
1) How to create dynamic ViewObject based on a query?
2) Where to write this code?
3) can you help us with a sample code?
4) From where will this code will be triggered? I have Bounded taskflow and the input to that taskflow is the table name.
5) How to test this?
I am working on JDeveloper 12.2.1.10 and the application would be deployed on Weblogic 12c.
Thanks in advance for your help.
Thanks,
Mehabub