Oracle Reports - XML output to table
I have been tasked with an unusual request.
We have a number of Oracle Reports that output some very detailed financial data for the entire organization across every dept. The data exists in our Oracle EBS environment. The resulting report outputs are then FTP to an old style mainframe and then made available to each manager/dept on a monthly basis.
We would like to move away from this FTP activity and place the data into a standard table structure and make the data available to every manager via a page in our PeopleSoft environment. The existing reports perform some very detailed calculations and summing activities that we do not want to rewrite.