1 Reply Latest reply on Apr 17, 2019 3:04 PM by Martien van den Akker

    SOA 12c - Use case read large file and transform the content of file


      I have an use case in my current project where i need to read a csv file and need to

      replace a column value ( item number ) with corresponding ERP fusion item value by

      making ERP webservice call. for each record in a file i am making a call to ERP SOAP webservice to get the itemvalue.


      If the file contains more than 1000 records its unable to process it and soa service getting timed out. As of now i could see

      two approaches one using file chunk read and the other is to insert all the file records in DB and process it further.

      currently ODI is not used in our project.


      is there any better approach to given use case ? if so please share it.