PRCS_SCHEDULE_PSQUERY

This service operation schedules PSQuery process.

Request Message: PRQ_SCHEDULE_PSQUERY_REQ

Element Name	Description
QueryName	Specifies a string representing the name of a query.
RunControlId	Specifies a new or an existing run control ID.
PromptName	Specifies the name of the prompt for this query.
PromptValue	Specifies prompt value for its matching prompt names.
FieldName	Specifies the field name for the query tree prompt.
ExpressionText	Specifies the query expression text for the query tree prompt.

Example Request:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_SCHEDULE_PSQUERY_REQ.VERSION_1">
<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 wsu:Id="UsernameToken-1" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
        <wsse:Username>QE_QUERY</wsse:Username>
        <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">QE_QUERY</wsse:Password>
      </wsse:UsernameToken>
    </wsse:Security>
  </soapenv:Header>
   <soapenv:Body>
      <prq:SchedulePSQuery>
         <QueryName>QE_TREE_OPT_PROMPTS</QueryName>
         <Prompts>
            <PromptName>SetID</PromptName>
            <PromptValue>QEDM1</PromptValue>
         </Prompts>
         <TreePrompts>
            <FieldName>A.QE_JOBCODE</FieldName>
            <ExpressionText>,,QE_JOBCODES,1999-01-01,ALL_JOBS</ExpressionText>
         </TreePrompts>
         <TreePrompts>
            <FieldName>C.DEPTID</FieldName>
            <ExpressionText>SHARE,,DEPARTMENTS,1900-01-01,DEPARTMENTS</ExpressionText>
         </TreePrompts>
         <RunControlId>QE_TREE_OPT_PROMPTS</RunControlId>
      </prq:SchedulePSQuery>
   </soapenv:Body>
</soapenv:Envelope>

Response Message: PRQ_SCHEDULE_PSQUERY_RES

Element Name	Description
ProcessInstance	Specifies a number representing a process instance for running the report.

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:SchedulePSQueryResponse xsi:schemaLocation="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_SCHEDULE_PSQUERY_RES.VERSION_1 PRQ_SCHEDULE_PSQUERY_RES.VERSION_1.xsd" xmlns:prq="http://xmlns.oracle.com/Enterprise/Tools/schemas/PRQ_SCHEDULE_PSQUERY_RES.VERSION_1">
         <ProcessInstance>11078</ProcessInstance>
      </prq:SchedulePSQueryResponse>
   </soapenv:Body>
</soapenv:Envelope>