There are cases where we need to upload large size attachments in Oracle Fusion using OIC integrations.
One example will be Journal import and having supporting documents to be uploaded as attachment on journals.
For this we can use uploadAttachment Operation of ErpObjectAttachmentService
If we create OIC connection with WSDL url like below then we will have limitations:
https://abcd-dev2.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?wsdl
The limitations will be:
1). We will not get attachment option while configuring the SOAP adapter for this operation:
In the above screenshots of adapter configuration we saw that we didn't get Send attachment checkbox .
2). We will have to pass content as base64 text in payload body. If we get base64 encoded text from source then we can upload attachment upto 50MB which is the standard limit currently in OIC for SOAP Adapter payload size.
3). If we have got attachment or file reference from source then we need to encode the reference to base64.
so we will have to use oraext:encodeReferenceToBase64 (nsmpr2:FileReference ) function.
This function has limit of 10 MB only.
So if we see above limitations we can't upload large size attachments >50MB if we use the wsdl url in connection.
The above issue is caused because the below xsd of the wsdl doesn't allow binary
https://abcd-dev2.fa.us6.oraclecloud.com/fscmService/ErpObjectAttachmentService?XSD=/oracle/apps/financials/commonModules/shared/model/erpIntegrationService/AttachmentDetails.xsd
If we see the content of this xsd we can see that it supports only string:
So to make the SOAP adapter allow attachment in content then we need to customize the wsld file and upload the customized wsdl zipped file in OIC connection.
Below are the three files we need to create:
- AttachmentDetails.xsd
- ErpObjectAttachmentService.wsdl
- ErpObjectAttachmentService.xsd
Lets us see each file one by one:
AttachmentDetails.xsd
Replace "Your FA POD" with your Fusion Application env
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema elementFormDefault="qualified" targetNamespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" sdoJava:package="oracle.apps.financials.commonModules.shared.model.erpIntegrationService" xmlns:sdoJava="commonj.sdo/java" xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:annotation>
<xsd:documentation xmlns:oer="http://xmlns.oracle.com/oer">
<name>Attachment Information SDO</name>
<description>List of elements, each containing the details of the Attachment
to be uploaded.</description>
<oer:attributes>
<oer:attribute description="User Key to derive the PK1" name="UserKeyA" />
<oer:attribute description="User Key to derive the PK2" name="UserKeyB" />
<oer:attribute description="User Key to derive the PK3" name="UserKeyC" />
<oer:attribute description="User Key to derive the PK4" name="UserKeyD" />
<oer:attribute description="User Key to derive the PK5" name="UserKeyE" />
<oer:attribute description="Attachment Type" name="AttachmentType" />
<oer:attribute description="Attachment Title" name="Title" />
<oer:attribute description="Attachment Text/Url" name="Content" />
</oer:attributes>
</xsd:documentation>
</xsd:annotation>
<xsd:import namespace="commonj.sdo/java" schemaLocation="https://Your fa POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?XSD=/xml/sdoJava.xsd" />
<xsd:complexType name="AttachmentDetails">
<xsd:annotation>
<xsd:appinfo source="http://xmlns.oracle.com/adf/svc/metadata/">
<key xmlns="http://xmlns.oracle.com/adf/svc/metadata/">
<attribute>Title</attribute>
</key>
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element minOccurs="0" name="UserKeyA" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="UserKeyB" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="UserKeyC" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="UserKeyD" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="UserKeyE" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="AttachmentType" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="Title" nillable="true" type="xsd:string" />
<xsd:element minOccurs="0" name="Content" nillable="true" type="xsd:base64Binary" />
</xsd:sequence>
</xsd:complexType>
<xsd:element name="attachmentDetails" type="AttachmentDetails" />
</xsd:schema>
If we see in the above xsd, we have updated the content type from string to base64Binary
ErpObjectAttachmentService.wsdl
It will be the same wsdl that we get from erpObjectAttachmentService wsdl with slight changes like the xsd schema location.
Replace "Your FA POD" with your Fusion Application env
<?xml version="1.0" encoding="UTF-8"?>
<wsdl:definitions name="ErpObjectAttachmentService" targetNamespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/" xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/" xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:types="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
<wsdl:documentation xmlns:oer="http://xmlns.oracle.com/oer">
<name>ERP Object Attachment Service</name>
<description>provides external web service operations for ERP Attachment scenarios</description>
<docCategories>
<category>External</category>
</docCategories>
<oer:lifecycle>Active</oer:lifecycle>
<oer:compatibility>Supported - Backward Compatibility Assured</oer:compatibility>
<oer:operation name="downloadAttachment">
<description>Download attachment corresponding to the attachment details
passed.</description>
<oer:parameters>
<oer:parameter name="attachment" description="Element containing the details of the Attachment to be downloaded. The details include the entity name, category name and user keys." />
<oer:return description="Downloaded Attachment Details. Details include Attachment Type and Attachment Content" />
</oer:parameters>
</oer:operation>
<oer:operation name="uploadAttachment">
<description>Uploads the Attachments Zip file on UCM Account and also updates
the corresponding Attachments tables</description>
<oer:lifecycle>Active</oer:lifecycle>
<oer:parameters>
<oer:parameter name="entityName" description="Entity Name for Single/Multiple Attachment upload" />
<oer:parameter name="categoryName" description="Category Name for Single/Multiple Attachment upload" />
<oer:parameter name="allowDuplicate" description="User Option to allow Duplicates or not." />
<oer:parameter name="attachmentRows" description="List of elements, each containing the details of the Attachment to be uploaded." />
<oer:return description="Request Id of the Ess Job submitted for Attachments upload in asynchronous manner" />
</oer:parameters>
</oer:operation>
</wsdl:documentation>
<plnk:partnerLinkType name="ErpObjectAttachmentService">
<plnk:role name="ErpObjectAttachmentServiceProvider">
<plnk:portType name="tns:ErpObjectAttachmentService" />
</plnk:role>
<plnk:role name="ErpObjectAttachmentServiceRequestor">
<plnk:portType name="tns:ErpObjectAttachmentServiceResponse" />
</plnk:role>
</plnk:partnerLinkType>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceResponse_Fault_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" />
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceResponse_Input_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Namespace="http://www.w3.org/2005/08/addressing" />
<sp:Header Namespace="http://schemas.xmlsoap.org/ws/2004/08/addressing" />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:EncryptedParts>
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceResponse_Output_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:EncryptedParts>
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceSoapHttpPort_Fault_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<wsp:ExactlyOne>
<wsp:All />
<wsp:All />
<wsp:All />
<wsp:All />
</wsp:ExactlyOne>
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceSoapHttpPort_Input_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<wsp:ExactlyOne>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Namespace="http://www.w3.org/2005/08/addressing" />
<sp:Header Namespace="http://schemas.xmlsoap.org/ws/2004/08/addressing" />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
<sp:Header Name="SignatureConfirmation" Namespace="http://docs.oasis-open.org/wss/oasis-wss-wssecurity-secext-1.1.xsd" />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Namespace="http://www.w3.org/2005/08/addressing" />
<sp:Header Namespace="http://schemas.xmlsoap.org/ws/2004/08/addressing" />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Namespace="http://www.w3.org/2005/08/addressing" />
<sp:Header Namespace="http://schemas.xmlsoap.org/ws/2004/08/addressing" />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
<sp:Header Name="SignatureConfirmation" Namespace="http://docs.oasis-open.org/wss/oasis-wss-wssecurity-secext-1.1.xsd" />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Namespace="http://www.w3.org/2005/08/addressing" />
<sp:Header Namespace="http://schemas.xmlsoap.org/ws/2004/08/addressing" />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
<sp:Header Name="fmw-context" Namespace="http://xmlns.oracle.com/fmw/context/1.0" />
</sp:EncryptedParts>
</wsp:All>
</wsp:ExactlyOne>
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="ErpObjectAttachmentServiceSoapHttpPort_Output_Policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<wsp:ExactlyOne>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:EncryptedParts>
</wsp:All>
<wsp:All>
<sp:SignedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:SignedParts>
<sp:EncryptedParts xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<sp:Body />
</sp:EncryptedParts>
</wsp:All>
</wsp:ExactlyOne>
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="fast_infoset_service_policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<wsOptfiser:OptimizedFastInfosetSerialization enabled="true" xmlns:wsOptfiser="http://java.sun.com/xml/ns/wsit/2006/09/policy/fastinfoset/service" />
</wsp:Policy>
<wsp:Policy xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="wsaddr_policy" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy">
<wsaw:UsingAddressing xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl" />
</wsp:Policy>
<wsp:Policy xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="wsmtom_policy">
<wsoma:OptimizedMimeSerialization xmlns:wsoma="http://schemas.xmlsoap.org/ws/2004/09/policy/optimizedmimeserialization" />
</wsp:Policy>
<wsp:Policy xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="wss11_saml_or_username_token_with_message_protection_service_policy">
<wsp:ExactlyOne>
<wsp:All>
<sp:SymmetricBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:ProtectionToken>
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/Never">
<wsp:Policy>
<sp:RequireThumbprintReference />
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:ProtectionToken>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
<sp:ProtectTokens />
<sp:OnlySignEntireHeadersAndBody />
</wsp:Policy>
</sp:SymmetricBinding>
<sp:SignedSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:SamlToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssSamlV11Token11 />
</wsp:Policy>
</sp:SamlToken>
</wsp:Policy>
</sp:SignedSupportingTokens>
<sp:EndorsingSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:EndorsingSupportingTokens>
<sp:Wss11 xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:MustSupportRefKeyIdentifier />
<sp:MustSupportRefIssuerSerial />
<sp:MustSupportRefThumbprint />
<sp:MustSupportRefEncryptedKey />
<sp:RequireSignatureConfirmation />
</wsp:Policy>
</sp:Wss11>
</wsp:All>
<wsp:All>
<sp:SymmetricBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:ProtectionToken>
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/Never">
<wsp:Policy>
<sp:RequireThumbprintReference />
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:ProtectionToken>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128Exn256 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
<sp:ProtectTokens />
<sp:OnlySignEntireHeadersAndBody />
</wsp:Policy>
</sp:SymmetricBinding>
<sp:SignedSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:SamlToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssSamlV11Token11 />
</wsp:Policy>
</sp:SamlToken>
</wsp:Policy>
</sp:SignedSupportingTokens>
<sp:EndorsingSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:EndorsingSupportingTokens>
<sp:Wss11 xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:MustSupportRefKeyIdentifier />
<sp:MustSupportRefIssuerSerial />
<sp:MustSupportRefThumbprint />
<sp:MustSupportRefEncryptedKey />
<sp:RequireSignatureConfirmation />
</wsp:Policy>
</sp:Wss11>
</wsp:All>
<wsp:All>
<sp:SymmetricBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:ProtectionToken>
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/Never">
<wsp:Policy>
<sp:RequireThumbprintReference />
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:ProtectionToken>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
<sp:OnlySignEntireHeadersAndBody />
</wsp:Policy>
</sp:SymmetricBinding>
<sp:SignedSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:UsernameToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssUsernameToken10 />
</wsp:Policy>
</sp:UsernameToken>
</wsp:Policy>
</sp:SignedSupportingTokens>
<sp:Wss11 xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:MustSupportRefKeyIdentifier />
<sp:MustSupportRefIssuerSerial />
<sp:MustSupportRefThumbprint />
<sp:MustSupportRefEncryptedKey />
<sp:RequireSignatureConfirmation />
</wsp:Policy>
</sp:Wss11>
</wsp:All>
<wsp:All>
<sp:SymmetricBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:ProtectionToken>
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/Never">
<wsp:Policy>
<sp:RequireThumbprintReference />
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:ProtectionToken>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128Exn256 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
<sp:OnlySignEntireHeadersAndBody />
</wsp:Policy>
</sp:SymmetricBinding>
<sp:SignedSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:UsernameToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssUsernameToken10 />
</wsp:Policy>
</sp:UsernameToken>
</wsp:Policy>
</sp:SignedSupportingTokens>
<sp:Wss11 xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:MustSupportRefKeyIdentifier />
<sp:MustSupportRefIssuerSerial />
<sp:MustSupportRefThumbprint />
<sp:MustSupportRefEncryptedKey />
<sp:RequireSignatureConfirmation />
</wsp:Policy>
</sp:Wss11>
</wsp:All>
<wsp:All>
<sp:TransportBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:TransportToken>
<wsp:Policy>
<sp:HttpsToken RequireClientCertificate="false">
<wsp:Policy />
</sp:HttpsToken>
</wsp:Policy>
</sp:TransportToken>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
</wsp:Policy>
</sp:TransportBinding>
<sp:SupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:SamlToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssSamlV11Token10 />
</wsp:Policy>
</sp:SamlToken>
</wsp:Policy>
</sp:SupportingTokens>
</wsp:All>
<wsp:All>
<sp:TransportBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:TransportToken>
<wsp:Policy>
<sp:HttpsToken RequireClientCertificate="false">
<wsp:Policy />
</sp:HttpsToken>
</wsp:Policy>
</sp:TransportToken>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
</wsp:Policy>
</sp:TransportBinding>
<sp:SupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:SamlToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssSamlV20Token11 />
</wsp:Policy>
</sp:SamlToken>
</wsp:Policy>
</sp:SupportingTokens>
</wsp:All>
<wsp:All>
<sp:TransportBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:TransportToken>
<wsp:Policy>
<sp:HttpsToken RequireClientCertificate="false">
<wsp:Policy />
</sp:HttpsToken>
</wsp:Policy>
</sp:TransportToken>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
</wsp:Policy>
</sp:TransportBinding>
<sp:SupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:UsernameToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssUsernameToken10 />
</wsp:Policy>
</sp:UsernameToken>
</wsp:Policy>
</sp:SupportingTokens>
</wsp:All>
<wsp:All>
<sp:TransportBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:TransportToken>
<wsp:Policy>
<sp:HttpsToken RequireClientCertificate="false">
<wsp:Policy />
</sp:HttpsToken>
</wsp:Policy>
</sp:TransportToken>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
</wsp:Policy>
</sp:TransportBinding>
</wsp:All>
<wsp:All>
<sp:TransportBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:TransportToken>
<wsp:Policy>
<sp:HttpsToken RequireClientCertificate="false">
<wsp:Policy>
<osp:HttpJwtAuthentication xmlns:osp="http://schemas.oracle.com/ws/2012/01/wssecuritypolicy" />
</wsp:Policy>
</sp:HttpsToken>
</wsp:Policy>
</sp:TransportToken>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
</wsp:Policy>
</sp:TransportBinding>
</wsp:All>
</wsp:ExactlyOne>
</wsp:Policy>
<wsp:Policy xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" wsu:Id="wss11_saml_token_with_message_protection_client_policy">
<sp:SymmetricBinding xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:ProtectionToken>
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/Never">
<wsp:Policy>
<sp:RequireThumbprintReference />
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:ProtectionToken>
<sp:AlgorithmSuite>
<wsp:Policy>
<sp:Basic128 />
</wsp:Policy>
</sp:AlgorithmSuite>
<sp:Layout>
<wsp:Policy>
<sp:Lax />
</wsp:Policy>
</sp:Layout>
<sp:IncludeTimestamp />
<sp:ProtectTokens />
<sp:OnlySignEntireHeadersAndBody />
</wsp:Policy>
</sp:SymmetricBinding>
<sp:SignedSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:SamlToken sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssSamlV11Token11 />
</wsp:Policy>
</sp:SamlToken>
</wsp:Policy>
</sp:SignedSupportingTokens>
<sp:EndorsingSupportingTokens xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:X509Token sp:IncludeToken="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy/IncludeToken/AlwaysToRecipient">
<wsp:Policy>
<sp:WssX509V3Token11 />
</wsp:Policy>
</sp:X509Token>
</wsp:Policy>
</sp:EndorsingSupportingTokens>
<sp:Wss11 xmlns:sp="http://schemas.xmlsoap.org/ws/2005/07/securitypolicy">
<wsp:Policy>
<sp:MustSupportRefKeyIdentifier />
<sp:MustSupportRefIssuerSerial />
<sp:MustSupportRefThumbprint />
<sp:MustSupportRefEncryptedKey />
<sp:RequireSignatureConfirmation />
</wsp:Policy>
</sp:Wss11>
</wsp:Policy>
<wsdl:import namespace="http://xmlns.oracle.com/adf/svc/errors/" location="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?WSDL=/META-INF/wsdl/ServiceException.wsdl" />
<wsdl:types>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<import namespace="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0" schemaLocation="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?XSD=/META-INF/oracle-webservices-async-fault-11_0.xsd" />
<import namespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" schemaLocation="ErpObjectAttachmentService.xsd" />
</schema>
</wsdl:types>
<wsdl:message name="ErpObjectAttachmentService_onFault">
<wsdl:part name="parameters" element="orafault:Fault" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_downloadAttachmentAsyncResponse">
<wsdl:part name="parameters" element="types:downloadAttachmentAsyncResponse" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_uploadAttachmentAsyncResponse">
<wsdl:part name="parameters" element="types:uploadAttachmentAsyncResponse" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_downloadAttachment">
<wsdl:part name="parameters" element="types:downloadAttachment" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_downloadAttachmentResponse">
<wsdl:part name="parameters" element="types:downloadAttachmentResponse" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_downloadAttachmentAsync">
<wsdl:part name="parameters" element="types:downloadAttachmentAsync" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_uploadAttachment">
<wsdl:part name="parameters" element="types:uploadAttachment" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_uploadAttachmentResponse">
<wsdl:part name="parameters" element="types:uploadAttachmentResponse" />
</wsdl:message>
<wsdl:message name="ErpObjectAttachmentService_uploadAttachmentAsync">
<wsdl:part name="parameters" element="types:uploadAttachmentAsync" />
</wsdl:message>
<wsdl:portType name="ErpObjectAttachmentServiceResponse">
<wsdl:operation name="onFault">
<wsdl:input message="tns:ErpObjectAttachmentService_onFault" xmlns:ns1="http://www.w3.org/2006/05/addressing/wsdl" ns1:Action="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0/Fault" />
</wsdl:operation>
<wsdl:operation name="downloadAttachmentAsyncResponse">
<wsdl:input message="tns:ErpObjectAttachmentService_downloadAttachmentAsyncResponse" xmlns:ns1="http://www.w3.org/2006/05/addressing/wsdl" ns1:Action="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/downloadAttachmentAsyncResponse" />
</wsdl:operation>
<wsdl:operation name="uploadAttachmentAsyncResponse">
<wsdl:input message="tns:ErpObjectAttachmentService_uploadAttachmentAsyncResponse" xmlns:ns1="http://www.w3.org/2006/05/addressing/wsdl" ns1:Action="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/uploadAttachmentAsyncResponse" />
</wsdl:operation>
</wsdl:portType>
<wsdl:portType name="ErpObjectAttachmentService">
<wsdl:documentation />
<wsdl:operation name="downloadAttachment">
<wsdl:input message="tns:ErpObjectAttachmentService_downloadAttachment" />
<wsdl:output message="tns:ErpObjectAttachmentService_downloadAttachmentResponse" />
<wsdl:fault name="ServiceException" message="errors:ServiceException" />
</wsdl:operation>
<wsdl:operation name="downloadAttachmentAsync">
<wsdl:input message="tns:ErpObjectAttachmentService_downloadAttachmentAsync" xmlns:ns1="http://www.w3.org/2006/05/addressing/wsdl" ns1:Action="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/downloadAttachmentAsync" />
</wsdl:operation>
<wsdl:operation name="uploadAttachment">
<wsdl:input message="tns:ErpObjectAttachmentService_uploadAttachment" />
<wsdl:output message="tns:ErpObjectAttachmentService_uploadAttachmentResponse" />
<wsdl:fault name="ServiceException" message="errors:ServiceException" />
</wsdl:operation>
<wsdl:operation name="uploadAttachmentAsync">
<wsdl:input message="tns:ErpObjectAttachmentService_uploadAttachmentAsync" xmlns:ns1="http://www.w3.org/2006/05/addressing/wsdl" ns1:Action="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/uploadAttachmentAsync" />
</wsdl:operation>
</wsdl:portType>
<wsdl:binding name="ErpObjectAttachmentServiceSoapHttp" type="tns:ErpObjectAttachmentService">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#wsmtom_policy" wsdl:required="false" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#wss11_saml_or_username_token_with_message_protection_service_policy" wsdl:required="false" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#fast_infoset_service_policy" wsdl:required="false" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#wsaddr_policy" wsdl:required="false" />
<wsdl:operation name="downloadAttachment">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/downloadAttachment" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Input_Policy" wsdl:required="false" />
</wsdl:input>
<wsdl:output>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Output_Policy" wsdl:required="false" />
</wsdl:output>
<wsdl:fault name="ServiceException">
<soap:fault name="ServiceException" use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Fault_Policy" wsdl:required="false" />
</wsdl:fault>
</wsdl:operation>
<wsdl:operation name="downloadAttachmentAsync">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/downloadAttachmentAsync" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Input_Policy" wsdl:required="false" />
</wsdl:input>
</wsdl:operation>
<wsdl:operation name="uploadAttachment">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/uploadAttachment" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Input_Policy" wsdl:required="false" />
</wsdl:input>
<wsdl:output>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Output_Policy" wsdl:required="false" />
</wsdl:output>
<wsdl:fault name="ServiceException">
<soap:fault name="ServiceException" use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Fault_Policy" wsdl:required="false" />
</wsdl:fault>
</wsdl:operation>
<wsdl:operation name="uploadAttachmentAsync">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/uploadAttachmentAsync" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceSoapHttpPort_Input_Policy" wsdl:required="false" />
</wsdl:input>
</wsdl:operation>
</wsdl:binding>
<wsdl:binding name="ErpObjectAttachmentServiceResponseBinding" type="tns:ErpObjectAttachmentServiceResponse">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#wss11_saml_token_with_message_protection_client_policy" wsdl:required="false" />
<wsdl:operation name="onFault">
<soap:operation soapAction="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0/Fault" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceResponse_Input_Policy" wsdl:required="false" />
</wsdl:input>
</wsdl:operation>
<wsdl:operation name="downloadAttachmentAsyncResponse">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/downloadAttachmentAsyncResponse" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceResponse_Input_Policy" wsdl:required="false" />
</wsdl:input>
</wsdl:operation>
<wsdl:operation name="uploadAttachmentAsyncResponse">
<soap:operation soapAction="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/uploadAttachmentAsyncResponse" />
<wsdl:input>
<soap:body use="literal" />
<wsp:PolicyReference xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" URI="#ErpObjectAttachmentServiceResponse_Input_Policy" wsdl:required="false" />
</wsdl:input>
</wsdl:operation>
</wsdl:binding>
<wsdl:service name="ErpObjectAttachmentService">
<wsdl:port name="ErpObjectAttachmentServiceSoapHttpPort" binding="tns:ErpObjectAttachmentServiceSoapHttp">
<soap:address location="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService" />
<wsa:EndpointReference xmlns:wsa="http://www.w3.org/2005/08/addressing">
<wsa:Address xmlns:wsa="http://www.w3.org/2005/08/addressing">https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService</wsa:Address>
<wsid:Identity xmlns:wsid="http://schemas.xmlsoap.org/ws/2006/02/addressingidentity">
<dsig:KeyInfo xmlns:dsig="http://www.w3.org/2000/09/xmldsig#">
<dsig:X509Data>
<dsig:X509Certificate>MIIDVzCCAj+gAwIBAgIIT/yPBCeD1PswDQYJKoZIhvcNAQELBQAwWTETMBEGCgmS
JomT8ixkARkWA2NvbTEWMBQGCgmSJomT8ixkARkWBm9yYWNsZTEVMBMGCgmSJomT
8ixkARkWBWNsb3VkMRMwEQYDVQQDEwpDbG91ZDlDQS0yMB4XDTE2MDUyODAzNDcy
OVoXDTI2MDUyNjAzNDcyOVowWzETMBEGCgmSJomT8ixkARkWA2NvbTEWMBQGCgmS
3jKAhxrwF4ucQQ7tCqXF/9LcQmWBLwMgDefxYWtCIDT1SvhYgeF3Yy16hmxiSIbV
ZCKjGCHoiUh4RgEghVmdRaAJxm+6E74fLNfyGdmOQv85whfadb6xkrY7dOyToipF
ggu/d2RrZYrvSaOvu5usfQ/GujzkMsqHB2V+SNJqAzmX9ax/yYoFpod1niH7JNLw
SkbKIsEqpiD+eTtahZThMZ+9zHQCSkdZtgM/klctUjtTNSBzf5+HScrUK/mBuZUK
7VzFFnXVhsD8OaIu0SudByEqT6Q7vhN1AB38ar4n1rJmA9uoStHF7YWxhQ==</dsig:X509Certificate>
<dsig:X509IssuerSerial>
<dsig:X509IssuerName>CN=Cloud9CA-2, DC=cloud, DC=oracle, DC=com</dsig:X509IssuerName>
<dsig:X509SerialNumber>5763638871132984571</dsig:X509SerialNumber>
</dsig:X509IssuerSerial>
<dsig:X509SubjectName>CN=FAEncryption, DC=cloud, DC=oracle, DC=com</dsig:X509SubjectName>
<dsig:X509SKI>2J0BevcT5jEwN+vg0mynVnu2LTA=</dsig:X509SKI>
<dsig:X509Certificate>MIIDazCCAlOgAwIBAgIIVG39wJnOff4wDQYJKoZIhvcNAQELBQAwWTETMBEGCgmS
JomT8ixkARkWA2NvbTEWMBQGCgmSJomT8ixkARkWBm9yYWNsZTEVMBMGCgmSJomT
8ixkARkWBWNsb3VkMRMwEQYDVQQDEwpDbG91ZDlDQS0yMCAXDTE2MDUyODAzNDcy
mcQymnssHZ1kqfmwn0MWvBr/xRaTBvC4Zu7htnr9HHsibHFPhYJfqM3VcLs5lDIg
jMLYOfI9o9dbOhPZ/tREnAAPV/9bu7bipMMTJoDwGr7l1cpTF/sisawvOKkJ/0sC
HuKsiE3Uz25/1ABG+F0+uxZFi0GCbGPmcFku4KliyzUOMNm+UUq2G6zMqZi3DSnc
PQjD9IcIOO7TDQgH0hbj5QtuTIANiVJTIdtIOFgPofdSsrTeYGG9nuyr46d4XSio
W9h9VDEECvUVZqexYp9CwdD91MMVjc2Oqc0CrUv+EzpTf+J+uSnb7+omQK060uHk
ZSxYqkElNd+SzodVC9yW</dsig:X509Certificate>
</dsig:X509Data>
</dsig:KeyInfo>
</wsid:Identity>
</wsa:EndpointReference>
</wsdl:port>
</wsdl:service>
</wsdl:definitions>
ErpObjectAttachmentService.xsd
Replace "Your FA POD" with your Fusion Application env
<?xml version="1.0" encoding="UTF-8"?>
<schema elementFormDefault="qualified" targetNamespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:ns0="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns1="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:tns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns="http://www.w3.org/2001/XMLSchema">
<import namespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" schemaLocation="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?XSD=/oracle/apps/financials/commonModules/shared/model/erpIntegrationService/DownloadedAttachment.xsd" />
<import namespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" schemaLocation="AttachmentDetails.xsd" />
<import namespace="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" schemaLocation="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?XSD=/oracle/apps/financials/commonModules/shared/model/erpIntegrationService/DownloadAttachmentDtls.xsd" />
<import namespace="http://xmlns.oracle.com/adf/svc/errors/" schemaLocation="https://Your FA POD.fa.us6.oraclecloud.com:443/fscmService/ErpObjectAttachmentService?XSD=/META-INF/wsdl/ServiceException.xsd" />
<element name="downloadAttachment">
<complexType>
<sequence>
<element name="attachment" nillable="true" type="ns1:DownloadAttachmentDtls" />
</sequence>
</complexType>
</element>
<element name="downloadAttachmentResponse">
<complexType>
<sequence>
<element maxOccurs="unbounded" minOccurs="0" name="result" nillable="true" type="ns1:DownloadedAttachment" />
</sequence>
</complexType>
</element>
<element name="downloadAttachmentAsync">
<complexType>
<sequence>
<element name="attachment" nillable="true" type="ns1:DownloadAttachmentDtls" />
</sequence>
</complexType>
</element>
<element name="downloadAttachmentAsyncResponse">
<complexType>
<sequence>
<element maxOccurs="unbounded" minOccurs="0" name="result" nillable="true" type="ns1:DownloadedAttachment" />
</sequence>
</complexType>
</element>
<element name="uploadAttachment">
<complexType>
<sequence>
<element name="entityName" type="string" />
<element name="categoryName" type="string" />
<element name="allowDuplicate" type="string" />
<element maxOccurs="unbounded" minOccurs="0" name="attachmentRows" nillable="true" type="ns1:AttachmentDetails" />
</sequence>
</complexType>
</element>
<element name="uploadAttachmentResponse">
<complexType>
<sequence>
<element name="result" type="string" />
</sequence>
</complexType>
</element>
<element name="uploadAttachmentAsync">
<complexType>
<sequence>
<element name="entityName" type="string" />
<element name="categoryName" type="string" />
<element name="allowDuplicate" type="string" />
<element maxOccurs="unbounded" minOccurs="0" name="attachmentRows" nillable="true" type="ns1:AttachmentDetails" />
</sequence>
</complexType>
</element>
<element name="uploadAttachmentAsyncResponse">
<complexType>
<sequence>
<element name="result" type="string" />
</sequence>
</complexType>
</element>
</schema>
Once these files are ready, we need to zip them.
We can name the zipped file based on ENV like PROD, DEV, TEXT in the suffix as we will have respective URLS mentioned in the xsd and wsdl.
Now we will create OIC connection with this wsdl file.
Upload this file in the connection and provide creedentials.
Now let us go in the integration and configure the soap adapter for this webservice. This time we should get the attachment checkbox.
Let us see the mapper where we can simply map the fileReference and no need to encode to base64.
So using this we can upload very large attachemnts (>50MB) to Oracle Fusion from OIC .
Note: In Gen3 if the test connection gives error with above customized files then we need to use complete wsdl and customize based on our environment:
