PL/SQL (MOSC)

MOSC Banner

Any Idea

edited Nov 21, 2018 8:32AM in PL/SQL (MOSC) 7 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center