Processing large EDI 852 inbound files
robn77Jul 26 2010 — edited Aug 4 2010We have an inbound interface that we need to process. Right now we have the file coming in and B2B breaks up the file by transaction and sends that to SOA. The end result is that we would like to have the data inserted into a staging table(EDI_INBOUND) in Oracle so that we can run procedures against it to load the table (POS_HEADER/POS_DETAIL) that the warehouse will be reading. We have tried several iterations of this.
1. Have BPEL insert the data into the EDI_INBOUND staging table.
2. Have a Java class read the XML file generated by B2B and load the EDI_INBOUND staging table.
Both of these solutions take longer than 15 minutes to process so this is too long. We need a better solution to load this data. The xml file generated by B2B is 15MB (380k lines of XML)
Thanks!