In This Article , I will explain the way to create the AP invoice using ERP Integration webservices.
Generally to interface an AP invoice in ERP Cloud , we have two options , one is a direct SOAP Web service way and the second way is using a generic web service which in turn submits the respective ESS jobs accepts an FBDI - file based data import format.
In this post , I will show you an working example using a generic web service with FBDI format approach.
At a high level below are the steps we need to perform
1) Prepare the Base64 Encoded Data
2) Update the data to the UCM Payable Account
3) Launch the Load ESS Job to load the data to the AP interface tables
4) Launch the Payable Import ESS Job to load the data into Base tables
5) Check the status of the job and download the report
Step1: FBDI format is an Macro based excel to prepare the data and create a csv files out it . These csv files further zipped and encode it to base64 format using tools like (https://base64.guru/converter/encode/file) . This Encoded information can be further loaded to the respective UCM account.
Sample Encoded Data :
UEsDBBQAAAAIAHm+clBTDN8UVgAAAN8AAAAbAAAAQXBJbnZvaWNlTGluZXNJbnRlcmZhY2UuY3N2M7Q0MDM0MLQ0MDY2M9Qx1PEMcfXVMTPRMzXVAQLn0uKS/NzUIoWg1LTSvBQdZOCno6PsF+rjo2NkYGSgb2Csb2gBFocIogOYqB/QDrBemBk0BK5+LgBQSwMEFAAAAAgASr5yUHUNhmPRAAAA0QEAABcAAABBcEludm9pY2VzSW50ZXJmYWNlLmNzdrVPwW7CMAz9Fava0ZS4pVFzDA1CHNZDgQ9ImxQiSiuVFGl/v8AO9MC0055l2XrPsv1IME6MBEtTTlhttrA+YlGsUeQ8W+WUp5Q8ZE6hSuSrOMswYQlbsnRJOUZK3535dJ29XVyYiBClUtWC8LhXz4xk0wxT76GcrrUd4bUYztqAhma0xnmodaf7xsLQwsfzTAw7D+4GtXX9CUbbTr2xBvwAX8ME2oM/B9W7q43D1f1BlkpWCn8we3Hez+mHy7cQ4j2PWIYIBv/f0G8P/IFNqb4BUEsBAhQAFAAAAAgAeb5yUFMM3xRWAAAA3wAAABsAAAAAAAAAAQAgAAAAAAAAAEFwSW52b2ljZUxpbmVzSW50ZXJmYWNlLmNzdlBLAQIUABQAAAAIAEq+clB1DYZj0QAAANEBAAAXAAAAAAAAAAEAIAAAAI8AAABBcEludm9pY2VzSW50ZXJmYWNlLmNzdlBLBQYAAAAAAgACAI4AAACVAQAAAAA
Step2: Prepare the sample Payload and upload to UCM
**WSDL:**
Operation :
uploadFileToUcm
Request Payload :
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelopexmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/"xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><soapenv:Header /><soapenv:Body><typ:uploadFileToUcm><typ:document><erp:Content>UEsDBBQAAAAIAHm+clBTDN8UVgAAAN8AAAAbAAAAQXBJbnZvaWNlTGluZXNJbnRlcmZhY2UuY3N2M7Q0MDM0MLQ0MDY2M9Qx1PEMcfXVMTPRMzXVAQLn0uKS/NzUIoWg1LTSvBQdZOCno6PsF+rjo2NkYGSgb2Csb2gBFocIogOYqB/QDrBemBk0BK5+LgBQSwMEFAAAAAgASr5yUHUNhmPRAAAA0QEAABcAAABBcEludm9pY2VzSW50ZXJmYWNlLmNzdrVPwW7CMAz9Fava0ZS4pVFzDA1CHNZDgQ9ImxQiSiuVFGl/v8AO9MC0055l2XrPsv1IME6MBEtTTlhttrA+YlGsUeQ8W+WUp5Q8ZE6hSuSrOMswYQlbsnRJOUZK3535dJ29XVyYiBClUtWC8LhXz4xk0wxT76GcrrUd4bUYztqAhma0xnmodaf7xsLQwsfzTAw7D+4GtXX9CUbbTr2xBvwAX8ME2oM/B9W7q43D1f1BlkpWCn8we3Hez+mHy7cQ4j2PWIYIBv/f0G8P/IFNqb4BUEsBAhQAFAAAAAgAeb5yUFMM3xRWAAAA3wAAABsAAAAAAAAAAQAgAAAAAAAAAEFwSW52b2ljZUxpbmVzSW50ZXJmYWNlLmNzdlBLAQIUABQAAAAIAEq+clB1DYZj0QAAANEBAAAXAAAAAAAAAAEAIAAAAI8AAABBcEludm9pY2VzSW50ZXJmYWNlLmNzdlBLBQYAAAAAAgACAI4AAACVAQAAAAA=</erp:Content><erp:FileName>Apinvoiceint1.zip</erp:FileName><!--Optional:--><erp:ContentType /><!--Optional:--><erp:DocumentTitle /><!--Optional:--><erp:DocumentAuthor>Sandeep Satyavolu</erp:DocumentAuthor><!--Optional:--><erp:DocumentSecurityGroup>FAFusionImportExport</erp:DocumentSecurityGroup><!--Optional:--><erp:DocumentAccount>fin$/payables$/import$</erp:DocumentAccount><!--Optional:--><erp:DocumentName /><!--Optional:--><erp:DocumentId /></typ:document></typ:uploadFileToUcm></soapenv:Body></soapenv:Envelope>
Response Payload :
<?xml version="1.0" encoding="UTF-8"?><env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"xmlns:wsa="http://www.w3.org/2005/08/addressing"><env:Header><wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/uploadFileToUcmResponse</wsa:Action><wsa:MessageID>urn:uuid:50a5b6df-f11e-4f83-8f10-d947d431d95e</wsa:MessageID></env:Header><env:Body><ns0:uploadFileToUcmResponsexmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><resultxmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">824274</result></ns0:uploadFileToUcmResponse></env:Body></env:Envelope>
Make a Note of the Request id returned by the above response message.(824274)
Step3: Prepare the Payload for Load ESS job
Request Payload :
The above returned request id has to be passed as a parameter to the below payload.
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelopexmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><soapenv:Header /><soapenv:Body><typ:submitESSJobRequest><typ:jobPackageName>oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader</typ:jobPackageName><typ:jobDefinitionName>InterfaceLoaderController</typ:jobDefinitionName><!--Zero or more repetitions:--><typ:paramList>1</typ:paramList><typ:paramList>824274</typ:paramList><typ:paramList>N</typ:paramList><typ:paramList>N</typ:paramList></typ:submitESSJobRequest></soapenv:Body></soapenv:Envelope>
Response Payload:
<?xml version="1.0" encoding="UTF-8"?><env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"xmlns:wsa="http://www.w3.org/2005/08/addressing"><env:Header><wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/submitESSJobRequestResponse</wsa:Action><wsa:MessageID>urn:uuid:9af896e3-77fb-455d-993c-699610a234a3</wsa:MessageID></env:Header><env:Body><ns0:submitESSJobRequestResponsexmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><resultxmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">1088226</result></ns0:submitESSJobRequestResponse></env:Body></env:Envelope>
Step4: Submit the Payable Import ESS Job
Request Payload :
<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelopexmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"><soapenv:Header /><soapenv:Body><typ:submitESSJobRequest><typ:jobPackageName>oracle/apps/ess/financials/payables/invoices/transactions</typ:jobPackageName><typ:jobDefinitionName>APXIIMPT</typ:jobDefinitionName><!--Zero or more repetitions:--><typ:paramList>#NULL</typ:paramList><typ:paramList>300000002620757</typ:paramList><typ:paramList>N</typ:paramList><typ:paramList>#NULL</typ:paramList><typ:paramList>#NULL</typ:paramList><typ:paramList>#NULL</typ:paramList><typ:paramList>1000</typ:paramList><typ:paramList>CCB</typ:paramList><typ:paramList>#NULL</typ:paramList><typ:paramList>N</typ:paramList><typ:paramList>N</typ:paramList><typ:paramList>300000002621474</typ:paramList><typ:paramList>#NULL</typ:paramList><typ:paramList>1</typ:paramList></typ:submitESSJobRequest></soapenv:Body></soapenv:Envelope>
Response Payload :
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/submitESSJobRequestResponse</wsa:Action>
<wsa:MessageID>urn:uuid:8c38e005-a297-40a8-90fe-909e6312715a</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:submitESSJobRequestResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">1088258</result>
</ns0:submitESSJobRequestResponse>
</env:Body>
</env:Envelope>
Step5: Check status of the above job and Download the Log and output.
Request Payload.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:getESSJobStatus>
<typ:requestId>1088258</typ:requestId>
</typ:getESSJobStatus>
</soapenv:Body>
</soapenv:Envelope>
Response Payload :
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/getESSJobStatusResponse</wsa:Action>
<wsa:MessageID>urn:uuid:5cfc9e37-fa09-45cc-8990-b2321400c598</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:getESSJobStatusResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">SUCCEEDED</result>
</ns0:getESSJobStatusResponse>
</env:Body>
</env:Envelope>
The response returned as Success . Lets Download the Log and Output files.
Request Payload :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:downloadExportOutput>
<typ:requestId>1088258</typ:requestId>
</typ:downloadExportOutput>
</soapenv:Body>
</soapenv:Envelope>
Response Payload :
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/downloadExportOutputResponse</wsa:Action>
<wsa:MessageID>urn:uuid:d9d0c669-5e5b-49b7-afbb-b45e876ffe26</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:downloadExportOutputResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<ns2:result xsi:type="ns0:DocumentDetails" xmlns:ns2="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ns0:Content>
<xop:Include href="cid:3d7bfc53-cffc-44dc-9c25-983f251fa156" xmlns:xop="http://www.w3.org/2004/08/xop/include"/>
</ns0:Content>
<ns0:FileName xsi:nil="true"/>
<ns0:ContentType>zip</ns0:ContentType>
<ns0:DocumentTitle>ESS_L_1088258</ns0:DocumentTitle>
<ns0:DocumentAuthor>integration</ns0:DocumentAuthor>
<ns0:DocumentSecurityGroup>Attachments</ns0:DocumentSecurityGroup>
<ns0:DocumentAccount xsi:nil="true"/>
<ns0:DocumentName>1088258.zip</ns0:DocumentName>
<ns0:DocumentId xsi:nil="true"/>
</ns2:result>
</ns0:downloadExportOutputResponse>
</env:Body>
</env:Envelope>
Download the attachment by accessing the attachments section on SOAP UI As shown below.
![](https://static.wixstatic.com/media/672833_27ed20a88bd04dd082deb1216504cefc~mv2.png/v1/fill/w_776,h_370,al_c,q_85,enc_avif,quality_auto/672833_27ed20a88bd04dd082deb1216504cefc~mv2.png)
![](https://static.wixstatic.com/media/672833_bbcd5c18686640e6873043388a8f998d~mv2.png/v1/fill/w_521,h_373,al_c,q_85,enc_avif,quality_auto/672833_bbcd5c18686640e6873043388a8f998d~mv2.png)
Hope this Post Help you.
Commentaires