Any Idea
Requirement:
To get the data from ORACLE EBS into third party tool, it is required that periodically a dump of data from ORACLE EBS is created from many tables into .CSV files.
I expect that these queries have to run every week, and the queries will look like:
Select * from AP_INVOICES_ALL where LAST_UPDATE_DATE > SysDate – 10
Select * from PO_HEADERS_ALL where LAST_UPDATE_DATE > SysDate – 10
Select * from PO_LINES_ALL where LAST_UPDATE_DATE > SysDate – 10
And this goes for all 50 tables.
All the data of each tables has to be exported in a separate CSV file.
So, I could imagine that all queries are going to be included into one single package.