Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting TSV from oracle apps
On 27 Jul 2006 13:18:01 -0700, "alfonso" <alfonso.mexico_at_yahoo.com>
wrote:
>Hello,
>
>I am an oracle end user, I extract data daily from Oracle Applications.
>For example, I will export inventory balances for my org and bump it
>against open sales orders to figure out what to ship.
>
>My question is the following: Is there a way to automate data
>extraction? Exporting Sales orders from the OM module takes me 45
>minutes and I would be really happy if I could show up at work and have
>the tsv file waiting for me.
>
>My company does have reporting available but that only updates once a
>week and with inventory, shipments, etc it's just not usable for me.
>
>I am looking for something like dataloader from dataload.net except
>going the other way. Exporting data from forms instead of importing.
>
>I hope someone can help. Thank you!
You would need to find out (likely in the docs) whether you can run
that module from the command line.
If you can, you can schedule it.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Jul 27 2006 - 15:57:53 CDT