Flatfile to EDI_X12

2637523

Hi ,

I am working on Integrating Oracle SOA with Oracle B2B .

I am able to read all the invoices coming in from a flat file using file adapter and process the same in a loop to B2B [ where in B2B should create a single EDI X12 810 document ]

In this case B2B is creating an EDI document for the first invoice only  i.e., i could see only one invoice info

Navigating to Administration --> Reports and had a look at the xml payload coming in to b2B before getting translated to X12., the xml payload has all the invoices [ invoice info ] coming from flatfile, but after translation i dont see  the  similar behavior .Does this ensures that there is something went wrong while creating .ecs file.

please do suggest me in this reg :-

Thanks

Prasanna Chandrashekhara

Are you looking for flat to EDI conversion?

2637523

Hi

Yes, I am looking for flatfile to EDI conversion. flow is as follows :-

1. Read the Invoices from the flatfile

2. Transform it in to the format of Oracle B2B [ EDI X12_810 ]

3. EDI document should be created in B2B which should have all the Invoices info in a single document.

4 At this point , B2B is creating a document for few records only.

Also  I tried to implement the same using Oracle B2B default web services which is "Outbound Web Service ".

looks like mapping is big deal when invoking this service , because the structure of this service which accepts the payload is   "tns:payload" of  " any Type ".

Though you try to pass the entire payload  [ payload of the incoming flat files ] to  payload [ any Type ] , things are not going good.

Could you please suggest me in this regard

Thanks

Prasanna Chandrashekhara

Sorry for more question

"I am able to read all the invoices coming in from a flat file using file adapter and process the same in a loop to B2B [ where in B2B should create a single EDI X12 810 document ]

In this case B2B is creating an EDI document for the first invoice only  i.e., i could see only one invoice info"

Does it mean you sending you are converting Flat file to XML and then XML to X12 ?

If you are expecting batching, you need to schedule batching - Translation WebService won't support batched translation.

2637523

Yes, I am here converting flatfile to  xml structure of B2B , Once the document is sent to b2b , B2B is responsible for writing the EDI file in the specified channel of the remote trading partner.

We have concept of batching in Oracle B2B , what it does is ,, it would group all the EDI messages of a particular trading partner [ also of a particular document type ] in to a single EDI document.

I have executed the batching succesfully.

But my question is How do i created an EDI document which should have  batch of invoices through Oracle SOA.

which is the best way to achieve this

Is it thorugh a web service call , if so what are the considerations ,

Could you please share some info on Oracle B2B Outbound WebService , on how it can be invoked in Oracle SOA Suite layer

Thanks

Prasanna Chandrashekhara

since you are already doing below mentioned step, you can just schedule a batching and it will help you batch all invoices.

", Once the document is sent to b2b , B2B is responsible for writing the EDI file in the specified channel of the remote trading partner."

SURYA

Yes I am able to do batching succesfully.

Could you please share some info on Oracle B2B Outbound Web Service.

if you have some sample on the same that would be really helpful for me.

Thanks

Prasanna Chandrashekhara

Partner channel can be used as WS

http://docs.oracle.com/cd/E28280_01/user.1111/e10229/bb_partner_webservice.htm

Only translation as a WS

Using the Oracle B2B Web Services - 11g Release 1 (11.1.1.7)

Complete list of WS feature in B2B

Using the Oracle B2B Web Services - 11g Release 1 (11.1.1.7)

If you are just beginning, you might want to take a look at 12.1.3 features as well.

Service Oriented Architecture - SOA | Oracle

Oracle B2B Integration | SOA | Oracle