Interface Suggestion

[Dinesh]

Here is our scenario

We have custom interface process in place. Receiving file from third party ,upload data into staging tables, validate data, upload data into oracle interface tables, run Oracle interface to upload data into Oracle standard tables.

Whole process more or less is sequential. That means user have to process one file at a time. That is somewhat hindrance, users can't work in parallel or if anything goes wrong with one file user can't proceed to next.

What we are looking is for a solution where we accept multiple files at a time and process them simultaneously. Any suggestion how this can be achieved ?

[utsavwalia]

Hi,

One way, and it may not be the best, but its a suggestion...

Have mutliple concurrent process to validate the txt files. This would mean that multiple instatnces of the same validtauion scripts will read multiple files from the same location. As soon as the file is read move it to READ folder. The validation script needs to move to next file and read the next file.
One the file is sucessfully validated move to VALIDATED folder and now we know the chances of any error are minimal.

Regards.

[koms010]

U have to define request set. In that there will be two buttons define stage and link stage. in define u have to define multiple sessions and they have to be linked at link stage.

[keshavkovela]

Hi Utsav,

I couldn't get properly. Could you explain in details

thanks
keshav