Webservice Payload to upload Attachments in ERP Cloud – ErpObjectAttachmentService

Shailender Thallam

5 years ago

ERP Object Attachment Service is a generic service provided by oracle to upload text, file, and URL based attachments to business objects.

Service WSDL URL: https://servername/fscmService/ErpObjectAttachmentService?WSDL

Operation – uploadAttachment:Uploads an attachment zip file for a particular Universal Content Management Server account and updates the attachment tables for the relevant business object.

Here is an example payload to upload attachment to Journal Header.

Input Payload:


   
   
      
         Journal Header
         GL_JE_HEADERS
         Yes
         
         
            
            
            DR S1 Test JE Batch 001 JE2
            
            DR S1 Test JE Batch 001
            
            Sep-19
            
            DR CoA
            
            DR Calendar
            
            File
            
            SampleAttachment.txt
            
            U2hhaWxlbmRlciBTYW1wbGVBdHRhY2htZW50IHVwbG9hZCB0aHJvdWdoIFNPQVAgU2VydmljZQ==

To upload attachments to ERP Cloud business objects, we need to pass UserKey as shown in the above example. Each object(Receipts, Journals, Suppliers, Purchase Orders, etc) has different combination of user keys. FUN_ERP_ATTACHMENT_CONTEXTS table will show the association of user keys in combination of different objects under the column USER_KEY_CONTEXT1. Below is the glimpse of FUN_ERP_ATTACHMENT_CONTEXTS table.

Query in column USER_KEY_CONTEXT1 has bind parameters with name :1, :2, :3, :4, :5. Each bind parameter refers to one corresponding user key A, B, C, D, and E.
Response Payload


   
      http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpObjectAttachmentService/uploadAttachmentResponse
      urn:uuid:789ec13c-4b9a-49a7-afe2-f5a503051502
   
   
      
         "Attachment1":"SUCCEEDED"

For Further Reading