Tech Trainings

Oracle Cloud ERP – ERPObjectAttachmentService for PurchaseOrder

September 27, 2020 by admin

Below is the Sample Request Payload for ERPObject Attachment Service : SOAP URL : https://adc2-zrej-fa-ext.oracledemos.com/fscmService/ErpObjectAttachmentService?wsdl

<soapenv:Envelope xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
   <soapenv:Header>
      <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
         <wsse:UsernameToken wsu:Id="UsernameToken-FCAED079FF8B56D73C16012121276596">
            <wsse:Username>FIN_IMPL</wsse:Username>
            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">stT95343</wsse:Password>
            <wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">pkQbvxQmcbTCEVqtOaQv/Q==</wsse:Nonce>
            <wsu:Created>2020-09-27T13:08:47.659Z</wsu:Created>
         </wsse:UsernameToken>
         <wsu:Timestamp wsu:Id="TS-FCAED079FF8B56D73C16012121244955">
            <wsu:Created>2020-09-27T13:08:44.494Z</wsu:Created>
            <wsu:Expires>2020-10-11T13:52:16.494Z</wsu:Expires>
         </wsu:Timestamp>
      </wsse:Security>
   </soapenv:Header>
   <soapenv:Body>
      <typ:uploadAttachment>
         <typ:entityName>PO_HEADERS</typ:entityName>
         <typ:categoryName>MISC</typ:categoryName>
         <typ:allowDuplicate>yes</typ:allowDuplicate>         <!--Zero or more repetitions:-->
         <typ:attachmentRows>
            <!--Optional:-->
            <erp:UserKeyA>164019</erp:UserKeyA> <!--PO Numbe -->
            <!--Optional:-->
            <erp:UserKeyB>US1 Legal Entity</erp:UserKeyB>  <!--sold to le name -->
            <!--Optional:-->
            <erp:UserKeyC>#NULL</erp:UserKeyC>
            <!--Optional:-->
            <erp:UserKeyD>#NULL</erp:UserKeyD>
            <!--Optional:-->
            <erp:UserKeyE>#NULL</erp:UserKeyE>
            <!--Optional:-->
            <erp:AttachmentType>FILE</erp:AttachmentType>
            <erp:Title>Sample.txt</erp:Title>
            <erp:Content>SGVsbG8gV29ybGQ=</erp:Content>
         </typ:attachmentRows>
      </typ:uploadAttachment>
   </soapenv:Body>
</soapenv:Envelope>

Sample Payload Response

<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//ErpObjectAttachmentService/uploadAttachmentResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:13bbaf68-cdbb-4739-8917-ffe8431e4e27</wsa:MessageID>
      <wsse:Security env:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
         <wsu:Timestamp wsu:Id="Timestamp-x01AUhAjdElYLZ1WI8CwOA22" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
            <wsu:Created>2020-09-27T13:43:15Z</wsu:Created>
            <wsu:Expires>2020-10-01T01:03:15Z</wsu:Expires>
         </wsu:Timestamp>
      </wsse:Security>
   </env:Header>
   <env:Body>
      <ns0:uploadAttachmentResponse 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/">"Attachment1":"SUCCEEDED"</result>
      </ns0:uploadAttachmentResponse>
   </env:Body>
</env:Envelope>

BI Query to Validate the attachments

SELECT DISTINCT
    attch.pk1_value,
    attch.pk2_value,
    attch.attached_document_id,
    attch.entity_name,
    tl.dm_document_id,
	tl.dm_version_number,
	tl.dm_type,
    tl.file_name,
    tl.title,
    attch.category_name
FROM
    fnd_attached_documents  attch,
    fnd_documents_tl        tl ,
    po_headers_all ph
    WHERE attch.pk1_value =ph.po_header_id
    and ph.segment1='164019'
     AND attch.document_id = tl.document_id
     AND attch.entity_name  = 'PO_HEADERS'  
     AND attch.category_name in ('TO_SUPPLIER', 'MISC') 

Comments |0|