Announcement

Collapse
No announcement yet.

Question on creating a Regression Test using the Transmission Query

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

  • Question on creating a Regression Test using the Transmission Query

    First off, I am new to OTM. So, here is the question:

    I want to export all the XML from all the transmissions for a given day. So, I am able to create a query that identifies all of the transmissions for that day. I run the query inside Business Process Automation>Integration>Transmission Manager. This request generates several pages of data. Each row inside each page of the list, has the transmission item hyperlinked. In order to get each item's XML, I have click on each hyperlink and get the details. Is there any other way to get the entire list of items PLUS the XML associated to each item?

  • #2
    Re: Question on creating a Regression Test using the Transmission Query

    Hola danielrose01,

    If you have access to OTM database you can run a query against I_TRANSMISSION table, for instance:

    select i_transmission_no, xml_blob from i_transmission where insert_date > sysdate - 1

    I use SQL Tools or PLSQL Developer to execute the query and save the results as CSV files or XML files.

    Regards,
    Nando.

    Comment

    Working...
    X