Customer information

[techman]

Hi All

We need to extract customer information from Ebusiness and send it to OTM through BPEL . any information how can we extract the customer information from ebusiness . is there any concurrent programs to do that ?

thanks

[chrisplough]

It depends on what you want to achieve. The stock Oracle integration flows will transmit basic contact information from EBS to OTM whenever they are referenced by Deliveries/Order Releases that are sent over. However, only basic information for each contact is sent (name, address) and additional information (phone, email, etc) is not.

To resolve this - or to extract all contact details at once would require the development of custom BPEL integration flows.

Thanks,
Chris

[oliver]

Hi,

you might want to contact marinus.snyman@gmail.com
he is busy implementing a similar thing for a client in SouthAfrica and has a lot of experience in the area of EBS-BPEL-OTM

Rgds
Oliver

[jeff.depaul]

The seeded BPEL flow that comes with OTM for EBS integration will extract and send location information over to OTM. This info is tracked/logged in a series of synch tables on the EBS side. They make the determination of what to send/resend based on last_update_date.
We have found that fairly extensive modifications are needed to these flows but the location is likely the most straightforward (compared to the others).

The flow, as defined - pulls location information and sends when the concurrent request to send eligible delivery info over to OTM is run. Is this what you are looking to achieve or send only location information over (with no delivery info).

Within the BPEL process itself, location, item and delivery information is concatenated and sent to OTM for processing. Sending just the location information over might be a challenge both in how you invoke the process (if using the seeded conc. process) AND in xml transformation for processing into OTM.

Let us know more specific details of what you are looking to try to accomplish?

[rafikki]

Since the standard integration only sends the customer information over when a order is send over, and it was required by the OTM team to have all the customer information from the start, I have written a sql query to extract all the customer information into a xml file (Toad required) and then created a custom BPEL flow to import the data. This is not a realtime solution though, but you can contact me, and I will be happy to send you the files.

Regards,
Marinus Snyman

[anasazii]

Since the standard integration only sends the customer information over when a order is send over, and it was required by the OTM team to have all the customer information from the start, I have written a sql query to extract all the customer information into a xml file (Toad required) and then created a custom BPEL flow to import the data. This is not a realtime solution though, but you can contact me, and I will be happy to send you the files.

Regards,
Marinus Snyman

Hello Marinus,

I am interested in seeing this sql and how you managed the Customer integration...Could you please send the sql and anything else you have that would be helpful?

Thanks!!!
Janel Hansen
anasazii@hotmail.com

[rafikki]

This was for ebs release11. I'm pretty sure the table structure have changed in release12 but I'm attaching what I have.

[patu2829]

Hi Marinus,

Can you please send me the SQL as well, I am in process of integrating OTM 6.1 with EBS 11i.

Thanks
Patu
ashu2829@yahoo.com

[rafikki]

Hi, I have added the queries on my blog here:
Oracle, Apple & Other Tech...: OTM EBS Customer Integration