Announcement

Collapse
No announcement yet.

EBS PO Integration - PO_OTM_OUT records processing very slowly

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

  • EBS PO Integration - PO_OTM_OUT records processing very slowly

    Hi...we have this situation come up every once in awhile where we get an influx of PO updates in the PO_OTM_OUT queue...like for instance a user closes a bunch of POs or Releases and about 200-500 entries get put into the queue and it just causes everything to back up...is there anything that can be ran or set to help speed things up? Right now it looks like they are processing about 1 record every 2-5 minutes and we are still waiting on updates from yesterday to catch up (So as of Friday 10:04 am....the last record processed was put in the queue Thursday night at 9:05 PM). We are down to about 40 records waiting to process, but we have users waiting for that information to get into OTM so they can hire out the trip.

    EBS version - 12.1.3
    OTM version - 6.3.1
    Enterprise Manager 11g, not sure how to tell BPEL version

    We have both Sales Orders and POs integrating to OTM

    Thanks,
    Janel

  • #2
    Re: EBS PO Integration - PO_OTM_OUT records processing very slowly

    Hi Janel,

    Please share screensnap for OTM Event Diagnostic Servlet when you are facing this slowness

    Thank you


    -Prasad-
    Let's connect on LinkedIn
    Mobile: +91 973 049 6886
    E-mail: [email protected]

    If my post was helpful, then click on the Like button

    Comment


    • #3
      Re: EBS PO Integration - PO_OTM_OUT records processing very slowly

      Hi Prasad,

      Could you please tell me how to get to and run that servlet?

      Thanks!
      Janel

      Comment


      • #4
        Re: EBS PO Integration - PO_OTM_OUT records processing very slowly

        Hi Janel,

        Use below Event Diagnostic Servlet to get more information

        glog.webserver.event.EventDiagServlet

        You need to provide OTM URL and append above servlet to it

        e.g. http://10.4.20.54/GC3/glog.webserver.event.EventDiagServlet

        You will get more information about OTM Servlets at link

        Please let us know in case of any queries

        Thank you


        -Prasad-
        Let's connect on LinkedIn
        Mobile: +91 973 049 6886
        E-mail: [email protected]

        If my post was helpful, then click on the Like button

        Comment


        • #5
          Re: EBS PO Integration - PO_OTM_OUT records processing very slowly

          here are some snapshots....I closed out a few more releases in a test environment to get some data going...19 records were inserted into PO_OTM_OUT at 11:59 am today, as of 12:25 only 3 records have dequeued.

          Thanks!
          Janel
          Attached Files

          Comment


          • #6
            Re: EBS PO Integration - PO_OTM_OUT records processing very slowly

            Hi Janel,

            We have checked your given screensnaps

            There is no backlog at any Event Queue so, unable to understand your exact problem

            Thank you


            -Prasad-
            Let's connect on LinkedIn
            Mobile: +91 973 049 6886
            E-mail: [email protected]

            If my post was helpful, then click on the Like button

            Comment

            Working...
            X