This discussion is archived
4 Replies Latest reply: Feb 14, 2013 3:03 AM by 982035 RSS

Reading EDI X12 file from local folder

750350 Newbie
Currently Being Moderated
Hi,

We have got a requirement where a EDI X12 file (invoice) will be FTPed to a folder in the SOA server and the file needs to be processed and the data needs to be stored in some custom table(s).

Can anyone please guide me as to how to read this file from local drive. Can I use standard "File adapter"? (I don't think it will work though) Can I somehow use Oracle B2B to read the file and convert into XML?

I have just started working on Oracle B2B. Any help is much appreciated.

Regards,
Abhijit
  • 1. Re: Reading EDI X12 file from local folder
    Anuj Dwivedi Guru
    Currently Being Moderated
    Hi Abhijit,

    Yes, Oracle B2B is the right tool for this scenario. It has inbuilt transports seeded which you can use. No need to use any adapter. You can create an ecs file in B2B Document Editor which B2B will use at run-time for EDI native to XML translation and vice-versa. To understand it's functionality in better way, go through below docs -

    http://www.oracle.com/technetwork/middleware/soasuite/b2b-tu001-edi-133051.pdf
    http://download.oracle.com/docs/cd/E21764_01/integration.1111/e10229/part_workflow.htm#CEGBBDAD

    You may also try the X12 samples, which are here -

    https://www.samplecode.oracle.com/sf/go/page1510

    Regards,
    Anuj
  • 2. Re: Reading EDI X12 file from local folder
    user12255358 Newbie
    Currently Being Moderated
    You can check the links and know the concepts. The invoice will come as EDI 810 files. Configure the FTP channel as a listening channel of your company in b2b console. Use the definition you create in the document editor to configure the b2b adapter. So once the file is received, b2b adapter will pick up the file and give to BPEL. In the BPEL you can transform according to the custom table and invoke a DB adapter / oracle apps adapter and you can insert the invoice records in the custom table.

    Thanks.
  • 3. Re: Reading EDI X12 file from local folder
    user2600364 Newbie
    Currently Being Moderated
    Hi
    B2B can do this.
    1) create the doc def and import those to B2B
    2) configure partners and delivery channels( in ur case FTP)
    3) Deploy the agreement
    4) In SOA composite use the b2b adapter to read
    5) use mediator/BPEL to transform the message to be send to the end system.

    Regards
    S
  • 4. Re: Reading EDI X12 file from local folder
    982035 Newbie
    Currently Being Moderated
    Hi , I too have the same requirement.

    i am using
    -------------------------------------------------
    Jdev 11.1.1.6
    Oracle Editor : 7.0.5.4016
    Document Protocol : EDI_X12
    Document type : 810 (Invoice )
    Version: 4010
    Weblogic server :11.1.1.6.0
    ---------------------------------------------------
    I followed all the steps to create EDI X12 810 ecs file, converted this to .xsd and then to .dat in Oracle Document Editor as explained in the B2B user guide.
    I also configured the trading partner , created agreements and deployed in B2B console. There is no mistake . as i can able to see the def file while configuring Oracle B2B in my Jdev.
    I deployed the same process . But no instance is creating for my process. I also configured listing channel to Generic File 1.0. please help me out in this . Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points