Search This Blog

Thursday, December 26, 2019

ERPIntegrationService - Sample Payload

Use this service to load data into Oracle ERP Cloud using FBDI templates.

WSDL
https://servername/fscmService/ErpIntegrationService?WSDL

Sample Payload:

***** uploadFileToUcm *****
   <soapenv:Body>
      <typ:uploadFileToUcm>
         <typ:document>
            <erp:Content/>
            <erp:FileName>xxx2216.zip</erp:FileName>
            <erp:DocumentName>xxx2216</erp:DocumentName>
            <erp:ContentType>zip</erp:ContentType>
            <erp:DocumentSecurityGroup>FAFusionImportExport</erp:DocumentSecurityGroup>
            <erp:DocumentAccount>hcm$/dataloader$/import</erp:DocumentAccount>
         </typ:document>
      </typ:uploadFileToUcm>
   </soapenv:Body>

***** Interface Table Load *****
   <soapenv:Body>
      <typ:submitESSJobRequest>
         <typ:jobPackageName>/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</typ:jobPackageName>
         <typ:jobDefinitionName>InterfaceLoaderController</typ:jobDefinitionName>
         <typ:paramList>71</typ:paramList>
         <typ:paramList>6157</typ:paramList>
         <typ:paramList>N</typ:paramList>
         <typ:paramList>N</typ:paramList>
      </typ:submitESSJobRequest>
   </soapenv:Body>

***** Base Table Upload *****
 <soapenv:Body>
      <typ:submitESSJobRequest>
         <typ:jobPackageName>/oracle/apps/ess/financials/receivables/transactions/autoInvoices/</typ:jobPackageName>
         <typ:jobDefinitionName>AutoInvoiceImportEss</typ:jobDefinitionName>
         <!--Zero or more repetitions:-->
         <typ:paramList>300000001353217</typ:paramList>
         <typ:paramList>Manual Imported Invoices</typ:paramList>
         <typ:paramList>2016-10-27</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
         <typ:paramList>Y</typ:paramList>
         <typ:paramList>#NULL</typ:paramList>
      </typ:submitESSJobRequest>

   </soapenv:Body>

No comments:

Post a Comment