Users using excel , uncontrollled data entry. I would like to create a data entry form in qlikview ( Validate data on entry) and populate oracle databse in background.
Secondly I would then like to use the data analysis capability of qlikview to present data. The data is site KPI data.
Very likely. And you're going to use a multimeter (aka VOM) to hammer nails. It's possible, but not a very smart approach. Better imho to find someone to code a small web app for you (perhaps in Oracle Apex) to take care of the data entry side.