1 Reply Latest reply on Jun 5, 2014 8:54 AM by AlexAnd

    .csv file in an outlook email attachment




      How can we accomplish following using SOA/BPEL without using Oracle Beehive or any other third paty tools.


      1. Emails contain a .csv file with 5 columns.

      2. There is a table in Oracle EBS database with 5 columns.

      3. We need to have real time integration to import these .csv file from incoming emails into Oracle table from #2 above.


      How can SOA/BPEL detach the .csv file from emails, parse .csv fields and import these files in Oracle table in real time manner?


      Please advise.