Announcement

Collapse
No announcement yet.

Customer information

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Customer information

    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

  • #2
    Re: Customer information

    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
    Chris Plough
    twitter.com/chrisplough
    MavenWire

    Comment


    • #3
      Re: Customer information

      Hi,

      you might want to contact [email protected]
      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

      Comment


      • #4
        Re: Customer information

        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?

        Comment


        • #5
          Re: Customer information

          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
          Marinus Snyman

          Comment


          • #6
            Re: Customer information

            Originally posted by rafikki View Post
            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
            [email protected]

            Comment


            • #7
              Re: Customer information

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

              Comment


              • #8
                Re: Customer information

                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
                [email protected]

                Comment


                • #9
                  Re: Customer information

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

                  Comment

                  Working...
                  X