Urls:
- SAAS Home Page : https://hostname:443/
- SAAS UCM : https://hostname:443/cs
- BIP URL : https://hostname:443/xmlpserver or analytics
- BIP Web Service :
- https://<fusion app url>/xmlpserver/services/ExternalReportWSSService?wsdl
- https://<fusion app url>/xmlpserver/services/PublicReportWSSService?wsdl
- https://<fusion app url>/xmlpserver/services/ScheduleReportWSSService?wsdl
- Absolute Path : Provide complete xdo path
- Example : /Custom/Financials/int/Reports/samplereport.xdo
- ERP Adapter :
- Service Catalog :
- https://<fusion app url>/fndAppCoreServices/ServiceCatalogService?wsdl
- Erp Integration :
- https://<fusion app url>/fscmService/ErpIntegrationService
- Event Catalog :
- https://<fusion app url>/soa-infra
- Event Configuration
- https://<fusion app url>/soa-infra/PublicEvent/catalog
- Event Subscriber Check:
- https://<fusion app url>/soa-infra/PublicEvent/subscriptions
- Token Relay
- https://<fusion app url>/fscmRestApi/tokenrelay
- Attachment Service
- https://<host>.fa.ocs.oraclecloud.com/publicFinancialCommonErpIntegration/ErpObjectAttachmentService?wsdl
HCM Details:
- You encrypt files using the Oracle HCM Cloud public key.
- The data-loading process decrypts files using the Oracle HCM Cloud private key.
- Generate the PGP encryption key pair and download the Oracle HCM Cloud public key to Encrypt the file.
Upload File to UCM using following UCM Service.
https://hostname:443/idcws/GenericSoapPort?WSDL
- Read the file as an attachment
- Pass the opaque contents to UCM
- Get the content Id from the response.
- Service IdcService="CHECKIN_UNIVERSAL"
- dDocTitle
- dDocAccount
- dDocType
- dSecurityGroup
- dDocAuthor
https://hostname/hcmCommonDataLoader/HCMDataLoader?WSDL
- Operation - importAndLoadData
- Pass the content ID in the request message. -- dDocName from UCM upload response.
- <ns0:Field name="dDocName">UCMFA00422909</ns0:Field>
- Pass the additional Parameters.
- Operation - getDataSetStatus
- Pass the content id in the input parameter in the following format.
- "ContentId="$UCMContentID
- Exmple : ContentId=12345
- Submit Extract
- URL - https://hostname:443/hcmService/FlowActionsService?WSDL
- Operation
- SubmitFlow - To Submit the job
- Provide Extract Name
- Extract Run ID
- getFlowTaskInstanceStatus - To Get the Status
- Provide Extract Name
- Provide Extract Run Id
- getIntegrationContentId - To Get the content ID
- Provide Extract Name
- Provide Extract Run Id
- Get the Content from UCM.
- URL - https://hostname:443/idcws/GenericSoapPort?WSDL
- Service IdcService="GET_FILE"
- dDocName = ContentId
- Decode the Data and Write the file.
UCM Details:
- Web Service
- URL - https://hostname:443/idcws/GenericSoapPort?WSDL
BIP Webservices:
- To get the list of Webservices
- URL - http://hostname/xmlpserver/services
- To Schedule a BIP Job.
- https://hostname/xmlpserver/services/v2/ScheduleService?wsdl
- Operations
- scheduleReport - To Submit the Job
- getScheduledReportStatus - To get the Status of the Job.
- getAllJobInstanceIDs - To Get the Job Id's
- getXMLData - To Get the XML Data
Sample Payload :
HCM Extract :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/" xmlns:flow="http://xmlns.oracle.com/apps/hcm/processFlows/core/flowControllerService/">
<soapenv:Header/>
<soapenv:Body>
<typ:submitFlow>
<typ:flowName>SAMPLE_EXTRACT_REPORT</typ:flowName>
<!--Zero or more repetitions:-->
<typ:parameterValues>
<flow:ParameterName>Effective Date</flow:ParameterName>
<flow:ParameterValue>2019-10-17</flow:ParameterValue>
</typ:parameterValues>
<typ:parameterValues>
<flow:ParameterName>LookbackDate</flow:ParameterName>
<flow:ParameterValue>2019-10-02</flow:ParameterValue>
</typ:parameterValues>
<typ:parameterValues>
<flow:ParameterName>RunDate</flow:ParameterName>
<flow:ParameterValue>2019-10-17</flow:ParameterValue>
</typ:parameterValues> <typ:flowInstanceName>SAMPLE_EXTRACT_REPORT191017084530</typ:flowInstanceName>
<typ:legislativeDataGroupName>US Legislative Data Group</typ:legislativeDataGroupName>
<typ:recurringFlag>false</typ:recurringFlag>
</typ:submitFlow>
</soapenv:Body>
</soapenv:Envelope>
HCM Get Extract Status :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:getFlowTaskInstanceStatus> <typ:flowInstanceName>SAMPLE_EXTRACT_REPORT191017084530</typ:flowInstanceName> <typ:flowTaskInstanceName>SAMPLE_EXTRACT_REPORT</typ:flowTaskInstanceName>
<typ:legislativeDataGroupName>US Legislative Data Group</typ:legislativeDataGroupName>
</typ:getFlowTaskInstanceStatus>
</soapenv:Body>
</soapenv:Envelope>
HCM Get Content ID of an Extract :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/hcm/processFlows/core/flowActionsService/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:getIntegrationContentId> <typ:flowInstanceName>SAMPLE_EXTRACT_REPORT191017084530</typ:flowInstanceName> <typ:flowTaskInstanceName>SAMPLE_EXTRACT_REPORT</typ:flowTaskInstanceName>
<typ:legislativeDataGroupName>US Legislative Data Group</typ:legislativeDataGroupName> <typ:integrationName>IntegrationIdDefinedinExtractDeliveryType</typ:integrationName>
</typ:getIntegrationContentId>
</soapenv:Body>
</soapenv:Envelope>
Sample HDL File Load :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/hcm/common/dataLoader/core/dataLoaderIntegrationService/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:importAndLoadData>
<typ:ContentId>12345</typ:ContentId> <typ:Parameters>ImportMaximumErrors=100,LoadMaximumErrors=100,LoadConcurrentThreads=4,FileEncryption=PGPSIGNED,DeleteSourceFile=N</typ:Parameters>
</typ:importAndLoadData>
</soapenv:Body>
</soapenv:Envelope>
UCM Get File
<GenericRequest xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" webKey="cs"><tns:Service IdcService="GET_FILE">
<tns:User/>
<tns:Document>
<tns:Field name="dDocName">Doc_Id233088</tns:Field>
<tns:Field name="RevisionSelectionMethod">Latest</tns:Field>
<tns:Field name="Rendition">Web</tns:Field>
</tns:Document>
</tns:Service>
</GenericRequest>
UCM Search
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM">
<soapenv:Header/>
<soapenv:Body>
<ucm:GenericRequest webKey="CS">
<ucm:Service IdcService="GET_SEARCH_RESULTS">
<ucm:Document>
<ucm:Field name="QueryText">dID <MATCHES> `422909`</ucm:Field>
</ucm:Document>
</ucm:Service>
</ucm:GenericRequest>
</soapenv:Body>
</soapenv:Envelope>
Upload File To UCM:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM" xmlns:wsse="http://schemas.xmlsoap.org/ws/2003/06/secext">
<soapenv:Header/>
<soapenv:Body>
<ucm:GenericRequest webKey="cs">
<ucm:Service IdcService="CHECKIN_UNIVERSAL">
<ucm:User/>
<ucm:Document>
<ucm:Field name="dDocTitle">Department2 Load File</ucm:Field>
<ucm:Field name="dDocType">Document</ucm:Field>
<!-- <ucm:Field name="dDocAuthor">test1.user</ucm:Field>
-->
<ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>
<ucm:Field name="dDocAccount">hcm$/dataloader$/import$</ucm:Field>
<ucm:Field name="primaryFile">sampleFile2.zip</ucm:Field>
<ucm:File href="sampleFile2.zip" name="primaryFile"> <ucm:Contents>UEsDBBQACAgIAIZyBVUAAAAAAAAAAAAAAAAQAAAAT3JnYW5pemF0</ucm:Contents>
</ucm:File>
</ucm:Document>
</ucm:Service>
</ucm:GenericRequest>
</soapenv:Body>
</soapenv:Envelope>
Reference:
No comments:
Post a Comment