I am building a SOA BPEL application in Oracle 12c, which gets the list of files in a folder with minimum file age > 60 secs and start processing them.
I am facing issue at the first step, when File Adapter tries to get the list of files in a folder containing 90,000 files. Also, I have got transaction time out exception. I was told not to increase the Time Out settings as it affects all the BPEL processes transactions. Hence, It is returning blank value.
How can I overcome this issue without altering the transaction time out setting change?
Any help is much appreciated.
Thanks in advance!!