Hi Everyone,

I have received one requirement for development of code in between two application by using EDI & FlatFile Insert into Oracle DB
so i need to know the flow service steps to built a wm code.
Requirement as follows.
a EDI doc will publish
b convert EDI doc to flatfile
c Map Flatfile into canonical doc
d publish that canonical
e subscribe that canonical doc & insert into the Oracle DB

Please correct me if i am wrong
Find the flow step for above requirement

Need to know the Flow steps for above requirement
Main :Sequence(Success)
Try:Sequence(Failure)
??
??
Catch:Sequence(Done)

Pub.flow.getlasterror
Regd
RJ

you can use WmEDI package services to process the EDI data. do refer EDI services guide available on advantage…

What is the need to convert EDI to Flatfile and then map to canonical?

cant it be directly mapped to canonical??

Shahid,

it’s a big Module so first of all we need to create EDI doc to flat file then
convert tht flat file to canonical doc then follows with insertion into DB

IS ths code workout?

Main Sequence(Success)
Try Sequence(Failure)
wm.b2b.edi.envelopprocess(process all EDI segments)
wm.b2b.edi.getEDIstring
wm.flatfile.converttovalue (flat file schema to validate)
Map (IS doc to canonical)
Pub.publish (canonical)
insert adapter service(canonical doc inserted into db)
Catch sequence(done)
pub.flow.getlasterror

Regd
RJ

Yes you can eliminate the EDI document to Flatfile step and directly map EDI to Canonical:

Requirement as follows.
a EDI doc will publish – receiving from TN or using publish here?
b getEDIString and parse EDI doc using convertToValues…
c Map EDI doc to canonical doc
d publish that canonical doc
e subscribe that canonical doc & insert into the Oracle DB

There are lot of useful threads in the EDISection of this forum,take a look.

HTH,
RMg