Use the following SOAP service to execute the BICC PVO and publish the data to Object Storage.
https://servername.fa.us2.oraclecloud.com/bi/ess/esswebservice?wsdl
SubmitRequest Operation
<submitRequest xmlns:nstrgmpr="http://xmlns.oracle.com/types/submitbiacm/1654097574293/OutboundSOAPRequestDocument" xmlns:nsmpr0="http://www.w3.org/2005/08/addressing" xmlns:tns="http://xmlns.oracle.com/scheduler" xmlns:ns33="http://xmlns.oracle.com/scheduler/types" > <nstrgmpr:Headers>
<nstrgmpr:SOAPHeaders>
<nsmpr0:MessageID>112233</nsmpr0:MessageID>
<nsmpr0:Action>submitrequest</nsmpr0:Action>
</nstrgmpr:SOAPHeaders>
</nstrgmpr:Headers>
<nstrgmpr:Body>
<tns:submitRequest>
<!-- Can be Any Value-->
<tns:description>VIJAYA_BICC_EXTRACT</tns:description>
<tns:jobDefinitionId>
<!-- Required : Constant Value-->
<ns33:name>BICloudConnectorJobDefinition</ns33:name>
<!-- Constant Value-->
<ns33:packageName>oracle.apps.ess.biccc</ns33:packageName>
<!-- Required : Constant Value-->
<ns33:type>JOB_DEFINITION</ns33:type>
</tns:jobDefinitionId>
<!-- Required : Constant Value-->
<tns:application>oracle.biacm</tns:application>
<tns:requestedStartTime/>
<tns:requestParameters>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>SYS_className</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>oracle.esshost.impl.CloudAdaptorJobImpl</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>SYS_application</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>BI Cloud Adaptor</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>EXTRACT_JOB_TYPE</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>VO_EXTRACT</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>DATA_STORE_LIST</ns33:name>
<!-- Required : PVO Name -->
<ns33:value>FscmTopModelAM.PrcPozPublicViewAM.SupplierPVO</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>EXTERNAL_STORAGE_LIST</ns33:name>
<!-- Required : Variable Value : Configured Object Storage Name -->
<ns33:value>VIJAYA_BICC</ns33:value>
</ns33:parameter>
</tns:requestParameters>
</tns:submitRequest>
</nstrgmpr:Body>
</submitRequest>
<nsmpr0:MessageID>112233</nsmpr0:MessageID>
<nsmpr0:Action>submitrequest</nsmpr0:Action>
</nstrgmpr:SOAPHeaders>
</nstrgmpr:Headers>
<nstrgmpr:Body>
<tns:submitRequest>
<!-- Can be Any Value-->
<tns:description>VIJAYA_BICC_EXTRACT</tns:description>
<tns:jobDefinitionId>
<!-- Required : Constant Value-->
<ns33:name>BICloudConnectorJobDefinition</ns33:name>
<!-- Constant Value-->
<ns33:packageName>oracle.apps.ess.biccc</ns33:packageName>
<!-- Required : Constant Value-->
<ns33:type>JOB_DEFINITION</ns33:type>
</tns:jobDefinitionId>
<!-- Required : Constant Value-->
<tns:application>oracle.biacm</tns:application>
<tns:requestedStartTime/>
<tns:requestParameters>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>SYS_className</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>oracle.esshost.impl.CloudAdaptorJobImpl</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>SYS_application</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>BI Cloud Adaptor</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>EXTRACT_JOB_TYPE</ns33:name>
<!-- Required : Constant Value-->
<ns33:value>VO_EXTRACT</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>DATA_STORE_LIST</ns33:name>
<!-- Required : PVO Name -->
<ns33:value>FscmTopModelAM.PrcPozPublicViewAM.SupplierPVO</ns33:value>
</ns33:parameter>
<ns33:parameter>
<ns33:dataType>STRING</ns33:dataType>
<!-- Required : Constant Value-->
<ns33:name>EXTERNAL_STORAGE_LIST</ns33:name>
<!-- Required : Variable Value : Configured Object Storage Name -->
<ns33:value>VIJAYA_BICC</ns33:value>
</ns33:parameter>
</tns:requestParameters>
</tns:submitRequest>
</nstrgmpr:Body>
</submitRequest>
Get Completion Status Async:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sch="http://xmlns.oracle.com/scheduler">
<nstrgmpr:Headers>
<nstrgmpr:SOAPHeaders>
<nsmpr0:MessageID>112233</nsmpr0:MessageID>
<nsmpr0:Action>getCompletionStatus</nsmpr0:Action>
<nsmpr0:MessageID>112233</nsmpr0:MessageID>
<nsmpr0:Action>getCompletionStatus</nsmpr0:Action>
<nsmpr0:ReplyTo>
</nstrgmpr:Headers>
<nsmpr0:Address>Callback_URL</nsmpr0:Address>
</nsmpr0:ReplyTo>
</nstrgmpr:SOAPHeaders></nstrgmpr:Headers>
<soapenv:Body>
<sch:getCompletionStatus>
<sch:requestId>12345</sch:requestId>
</sch:getCompletionStatus>
</soapenv:Body>
</soapenv:Envelope>
Reference : https://docs.oracle.com/en/cloud/saas/applications-common/22d/biacc/soap-api.html#u00180699
No comments:
Post a Comment