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>
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