PRCS_FINDREQUESTS

Use this service operation to find process requests.

Request Message: PRQ_FINDREQUESTS_REQ

Element Name	Description
ProcessInstanceFrom	Enter the process instance number for the beginning of a range of instances by which to limit the process requests that are returned.
ProcessInstanceTo	Enter the process instance number for the end of a range of instances by which to limit the process requests that are returned.
OperatorId	Enter the ID of the user who submitted the process. Leave blank to view all of the processes that you are authorized to view. Use service operation PRCS_GETPROMPT with ParameterName OperatorId for a list of valid user IDs.
ProcessType	Enter a process type to limit the returned list to a specific process type.
ProcessName	Enter a process name to limit the returned list to a specific process name. Process name is case-sensitive.
ServerRun	Enter the name of a server to limit the returned list to a specific server.
RunStatus	Enter the run status to limit the returned list to a specific status. Use service operation PRCS_GETPROMPT with ParameterName RunStatus for a list of valid run statuses.
DistributionStatus	Enter the distribution status to limit the returned list to a specific distribution status. Use service operation PRCS_GETPROMPT with ParameterName DistributionStatus for a list of valid distribution statuses.
ProcessRequestCount	Enter a number to limit the returned list.
IsProcessCount	Use this parameter to receive all data and process count. Specify 0 to receive all data but no ProcessCount. Specify 1 to receive all data and ProcessCount.

<FilterType> The filter type can be either Last or Date Range

For <Last> specify an interval of time by which to limit the process requests that appear in the list.

Last Elements	Description
FilterValue	Enter a custom numerical value.
FilterUnit	Enter the interval. Valid values are: All Days Hours Minutes

Last Elements

Description

FilterValue

Enter a custom numerical value.

FilterUnit

Enter the interval. Valid values are:

All
Days
Hours
Minutes

Date Range

For <CustomDates> specify dates to get a list of requests created between two specific dates.

Date Range Elements	Description
FromDate	Enter a from date.
ToDate	Enter a to date.

Example Request:

<?xml version="1.0"?>
<soapenv:Envelope xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:⇒
soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http:⇒
//schemas.xmlsoap.org/ws/2003/03/addressing/" xmlns:xsd="http://www.w3.org/2001⇒
/XMLSchema/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance/">
  <soapenv:Header xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <wsse:Security soap:mustUnderstand="1" xmlns:soap="http://schemas.xmlsoap.org⇒
/wsdl/soap/" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-⇒
wssecurity-secext-1.0.xsd">
      <wsse:UsernameToken>
        <wsse:Username>QEDMO</wsse:Username>
        <wsse:Password>QEDMO</wsse:Password>
      </wsse:UsernameToken>
    </wsse:Security>
  </soapenv:Header>
  <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <prq:FindRequests xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas⇒
/PRQ_FINDREQUESTS_REQ.VERSION_1">
      <OperatorId>QEDMO</OperatorId>
      <ProcessType>SQR Report</ProcessType>
      <ProcessName></ProcessName>
      <RunStatus>Success</RunStatus>
      <DistributionStatus>Posted</DistributionStatus>
      <FilterType>
         <CustomDates>
            <FromDate>2009-02-01</FromDate>
            <ToDate>2009-02-10</ToDate>
         </CustomDates>
      </FilterType>
    </prq:FindRequests>
  </soapenv:Body>
</soapenv:Envelope>

Response Message: PRQ_FINDREQUESTS_RES

Element Name	Description
ProcessInstance	Process instance.
ProcessName	Process name.
ProcessType	Process type.
RunControlID	Run control ID.
ServerNameRequested	Name of the server requested for the process.
ServerNameRun	Name of the server where the process was run.
OperatorID	ID that submitted the process.
RequestDateTime	Date and time that the process request was submitted.
RunDateTime	The date and time that the process request was created.
BeginDateTime	The date and time that the process started.
EndDateTime	The date and time that the process ended.
OutputDestinationFormat	Output format.
OutputDestinationType	Output type.
Recurrence	Recurrence.
RunStatus	Run status.
DistributionStatus	Distribution status.
ContentId	Content ID is the Report ID assigned to the individual report by the Process Scheduler. The Content ID is used to view reports in the Report Repository. Note: For bursted reports all the associated content IDs will be retrieved and will be a part of the response.
IsProcessCount	Process count.

Example Response::

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:⇒
soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org⇒
/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <prq:FindRequestsResponse xsi:schemaLocation="http://xmlns.oracle.com⇒
/Enterprise/Tools/schemas/PRQ_FINDREQUESTS_RES.VERSION_1 PRQ_FINDREQUESTS_⇒
RES.VERSION_1.xsd" xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas⇒
/PRQ_FINDREQUESTS_RES.VERSION_1">
         <ProcessRequestItem>
            <ProcessInstance>9999941</ProcessInstance>
            <ProcessName>DDDAUDIT</ProcessName>
            <ProcessType>SQR Report</ProcessType>
            <RunControlId>2</RunControlId>
            <ServerNameRequested>PSNT</ServerNameRequested>
            <ServerNameRun>PSNT</ServerNameRun>
            <OperatorId>QEDMO</OperatorId>
            <RequestDateTime>2009-02-03-192.0.2.1</RequestDateTime>
            <RunDateTime>2009-02-03-192.0.2.2</RunDateTime>
            <BeginDateTime>2009-02-03-192.0.2.3</BeginDateTime>
            <EndDateTime>2009-02-03-192.0.2.4</EndDateTime>
            <OutputDestinationFormat>PDF</OutputDestinationFormat>
            <OutputDestinationType>WEB</OutputDestinationType>
            <RecurranceName/>
            <RunStatus>Success</RunStatus>
            <DistributionStatus>Posted</DistributionStatus>
            <ContentId>9999905</ContentId>
         </ProcessRequestItem>
         <ProcessRequestItem>
            <ProcessInstance>9999948</ProcessInstance>
            <ProcessName>SYSAUDIT</ProcessName>
            <ProcessType>SQR Report</ProcessType>
            <RunControlId>2</RunControlId>
            <ServerNameRequested>PSNT</ServerNameRequested>
            <ServerNameRun>PSNT</ServerNameRun>
            <OperatorId>QEDMO</OperatorId>
            <RequestDateTime>2009-02-05-198.51.100.1</RequestDateTime>
            <RunDateTime>2009-02-05-198.51.100.2</RunDateTime>
            <BeginDateTime>2009-02-05-198.51.100.3</BeginDateTime>
            <EndDateTime>2009-02-05-198.51.100.4</EndDateTime>
            <OutputDestinationFormat>PDF</OutputDestinationFormat>
            <OutputDestinationType>WEB</OutputDestinationType>
            <RecurranceName/>
            <RunStatus>Success</RunStatus>
            <DistributionStatus>Posted</DistributionStatus>
            <ContentId>9999914</ContentId>
         </ProcessRequestItem>
      </prq:FindRequestsResponse>
   </soapenv:Body>
</soapenv:Envelope>