1 Reply Latest reply: Jun 5, 2014 3:54 AM by AlexAnd RSS

    .csv file in an outlook email attachment

    User529649-OC

      Hello,

       

      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.

      Darsh