Interfaces

[kareem2003]

IN purchase
I have 100 lines inthat
80 lines in interface table as other 20 errors
20 lines in the error table .
how can i use add the 20 lines in interface table
can i use SQL LOADER where i can use add or skip,rows ?
or
delete data in the Interface table and do it same process?
.
my mail id kareem2003@gmail.com

have a nice day

[raviteja.manchu]

Hi,

Correct the error lines in the interface table and again upload those lines and import the same into the application

Regards,
Ravi Manchu

[rehmans]

Why are you using SQL Loader? Try using Toad or PLSQL Developer for this purpose. It's a lot easier than SQL Loader.

[kareem2003]

Thanks Ravi,
I know that process next time i do that .

now data at Stagetable at 100 lines.
IF i can validated data and Insert into Interface table ,
But 90 lines at going to the Interface table .10 at the error
How i can insert thouse 10 lines.
plz tell me .
wait for u replay.

Have a nice weekend.