AP interface (Invoices)

[lionso]

Hi,

I am very new to apps.

I have a task to import invoices from other systems using a custom SQL*Loader program at real-time. I haven't got a clue on where to start.

I have used SQL*loader before but not on apps. I am not sure where the program will be stored and where it will run from. If someone has got some documentation, a link or a script, I wil be very grateful if you can email it to my address tagemenaw@yahoo.co.uk.


Thanks

[seenujanu]

hai lion

chech this i have posted regarding abt sql loader

topic.asp?TOPIC_ID=308

that (.ctl) must be in schema(AP) to which ur importing the data into AP
the flat filename is 'c:\seenu.dat' (.dat or .csv or .txt)
u have to place(,ctl) in this server path and flat file (data)
\\erp\oracle\demoappl\ar\11.5.0\bin

u just register in AOL with .SQL LOADER Extension
like how u register the reports in AOL

if u have any doubts regarding this let me know

regards
seenu

[admin]

Thanks seenujanu for your time and efforts. Have a nice time.

[lionso]

Thanks for your help Seenu. This is very helpful.