Hi,
I have a scenario:
Firstly there was 1 file in the FTP server and that get loaded using SQL loader tables
There is a unix Shell Script where the Program to download the file from FTP Server to local using Fnd_Request.Submit_Request and then if its FTP successfully Submit Sql Loader Import concurrent runs and loads the data into interface table
Now there is requirement where there would be 2 files in the FTP Server..
How to process where there are 2 files in the Server and i have to FTP the 2 files and load into SQL lader same table
Any help will be needful for me