Scroll to top

© 2021 Conneqtion. All Rights Reserved.
Designed by Quadigy
Oracle Integration Cloud (OIC)

How To Upload/Download Attachments to UCM using OIC


Karan Tulsani - January 9, 2023

Reading Time: 2 minutes

In the previous blog we discussed about how to upload and download attachments in VBCS and also how to implement OJ-FILE-PICKER in your VBCS application. For more info, you can check out the blog – Uploading a file in VBCS using file picker.

Problem

What if you want to store your attachments temporarily or you don’t have database instance available?

Solution

In this blog we will explain how to upload & download attachments to UCM through OIC.

WSDL : https://{xxx}/idcws/GenericSoapPort?wsdl

Step 1: Upload.

UCMStep 2: Here we have created App driven integration which accepts below parameter.

upload/download attachments to UCMStep 3: Using the standard oracle SOAP web-service connection with below mentioned details.

The operation should accept attachment as a response and send attachment as a request.

upload/download attachments to UCM

Once the process is successfully completed, it will return the unique content id which can be used as a reference to download the attachment from UCM when required.

Attachment: Upload request

Attachment: Upload response

Step 4: Download.

In this section, we have created App driven Integration to download the same attachment which we have uploaded to UCM service.

Step 5: Here we have query parameter in the integration which accepts document name as input.

Step 6: Use the standard oracle SOAP web-service connection with below mentioned details.

The operation should accept attachment as a response and send attachment as a request.

Once the process is successful, it will return the file content in base64 along with the file details such as file name, file size etc.

Attachment: Download request

karan-tulsani-conneqtion-group

Karan Tulsani has an extensive experience with various Banking and financial services, FMCG, Supply chain management & public sector clients. He has also led/been part of teams in multitude of consulting engagements. He was part of Evosys and Oracle’s consulting team previously and worked for clients in NA, EMEA & APAC region.

Post Views: 1,081
Author avatar

Karan Tulsani

Karan Tulsani has an extensive experience with various Banking and financial services, FMCG, Supply chain management & public sector clients. He has also led/been part of teams in multitude of consulting engagements. He was part of Evosys and Oracle's consulting team previously and worked for clients in NA, EMEA & APAC region.

Related posts

From Gen 2 to Gen 3: Elevating Your Oracle Integration Cloud (OIC) Experience
Oracle

From Gen 2 to Gen 3: Elevating Your Oracle Integration Cloud (OIC) Experience

Vancy Arokia -
Creating an FBDI File for Journal Upload in Oracle Cloud
Oracle Integration Cloud (OIC)

Creating an FBDI File for Journal Upload in Oracle Cloud

Medhavi Chakraborty -
How to Withdraw Purchase Requisitions Pending Over 90 Days Using Oracle Integration Cloud?
Oracle Integration Cloud (OIC)

How to Withdraw Purchase Requisitions Pending Over 90 Days Using Oracle Integration Cloud?

Fiza Khan -

5 comments

  1. Soumya Mallick

    January 11, 2023 at 11:16 am
    Leave reply

    Hi,
    Nice article.
    Please provide the standard soap web service which can be used to upload and download attachment.

  2. Jaskaran

    April 18, 2024 at 5:48 am
    Leave reply

    Hi Karan,
    Can you also provide mapping of REST & SOAP connections and variables as well if possible

  3. Jaskaran

    May 13, 2024 at 10:18 am
    Leave reply

    Hi Karan,
    I am trying to use getDocumentForDocumentId method of ErpIntegrationService SOAP service. Here I’m passing documentId to download attachments from ERP. Could you confirm whether we will receive the attachment in base64 format in contents. I was trying to identify the mapping for attachment between SOAP adapter and FTP adapter how we will map the attachment

Post a Comment

Your email address will not be published. Required fields are marked *


Previous post

A Guide to Oracle EPM Cloud and It’s Uses

Next post

Oracle Paas: How to Manage Software Applications in the Cloud?

Biswajit Panigrahi

SALES DIRECTOR

Biswajit Panigrahi is an accomplished Sales professional with a wealth of experience in Global Sales, Cloud Strategy, OEM & Customer Relationship Management, and enterprise software. He excels in SAAS, AI, Analytics, IAAS/PAAS, and has a proven track record in the IT and services industry. Biswajit is skilled in Business Planning, Sales, Pre-sales, MIS, and Business Relationship Management. He holds a Post-Graduate Diploma in Planning and Management with a focus on Marketing from the Indian Institute of Planning & Management, New Delhi, and is dedicated to advancing business success through innovative solutions.

Dhruvil Pandya

MANAGER - MARKETING & BRAND DEVELOPMENT

Dhruvil Pandya spearheads Conneqtion’s Marketing & Branding initiatives, overseeing social media, PR, events, and global marketing strategies. With a Masters of Business Administration from Western Sydney University and a decade-long tenure spanning IT services, SaaS, Natural Gases & Equipments, Food, and United Nations sectors, Dhruvil brings a diverse range of industry experiences to the table. His extensive expertise extends to the Indian startup ecosystem, showcasing a keen understanding of business and marketing dynamics. Prior to Conneqtion, Dhruvil made significant contributions to BOC Australia, a prominent Gas company, where he played a pivotal role in managing APAC Marketing operations.

Jagdeesh Jaisinghani

VICE PRESIDENT - ORACLE APEX & PRODUCT DEVELOPMENT

Jagdeesh Jaisinghani, Conneqtion’s Vice President of Oracle APEX Practice and Product Development, brings over 23 years of IT expertise, primarily honed during his nearly two-decade tenure in Oracle's Industry Solutions Group. Armed with a Master's degree in Computer Science from the US, he has been hands-on in tech across various projects, specializing in Java, database-intensive web applications, and Oracle APEX development. His contributions extend to crafting UIs, APIs for cross-industry demo POCs, and playing a pivotal role in developing Oracle's Business Accelerators (OBA) playback tool for EBS. With extensive experience in Oracle APEX dating back to 2004, he has led numerous successful projects, demonstrating his prowess in technology leadership and solution development.

Arun Sharma

VICE PRESIDENT-DELIVERY (ORACLE PRACTICE)

Arun Sharma, serving as Conneqtion’s Vice President of Delivery (Oracle Practice), is a seasoned leader with a Bocconi certification in International Leadership and over 25 years of rich experience in IT. His expertise lies in end-to-end implementation, support, and roll-outs of enterprise applications, particularly in Oracle Applications, Utilities, GRC, integration, and digital transformation technologies across diverse industries and global regions. Arun's extensive background in Project, Program, Delivery Management & PMO, coupled with his management of over 100 cross-functional teams for 18+ years, underscores his strategic acumen, strong customer relationships, and dedication to fostering talent and organizational growth.

Prerna

DIRECTOR OF BUSINESS OPERATIONS

Prerna leads the Finance and Operations space in Conneqtion Group and overseeing compliance, risk, process improvement, corporate governance, sustainability, Financial Functions and Merger and Acquisitions. She is also leading the global expansions, fostering effective organizational cultures, and elevating employee experiences. Prior to Conneqtion, Prerna was an integral part of American Express and Bank of America and has worked on different products and strategies across North America, Europe and APAC region clientele.

Roshan Baig

PARTNER

Roshan Baig is renowned for his strategic acumen and hands-on delivery & project leadership. His expertise spans application development, integration, and team management, honed through extensive experience across the GCC, US, Australia, and APAC regions. Roshan's global perspective and cultural agility have driven successful projects and facilitated cross-border collaboration. With a passion for innovation and spearheading digital transformation initiatives that deliver tangible value. His track record includes delivering projects on time, within budget, and exceeding expectations, ensuring stakeholder satisfaction and organizational success. Before joining Conneqtion, Roshan was a part of Evosys Mastek, Capgemini and Birlasoft.

Lalji Gajera

DIRECTOR AND CTO

Lalji Gajera, the Chief Technology Officer at Conneqtion Group, brings over a decade of dynamic experience in the IT industry. He is renowned for his visionary leadership and adeptness in leveraging technology to tackle intricate business challenges. Lalji's deep understanding of emerging technologies and market dynamics has propelled Conneqtion Group to the forefront of innovation, delivering bespoke solutions that align with each client's unique requirements. Having held pivotal technical roles at esteemed multinational firms like Oracle Consulting Services, Accelalpha and 3Di Inc., Lalji's expertise spans a wide spectrum of IT domains.

Karan Tulsani

FOUNDER AND CEO

Karan Tulsani is the Founder and CEO of Conneqtion Group, an Oracle Cloud Infrastructure (OCI) & Oracle SaaS Implementation Partner enabling customers to achieve digital transformation in ERP and Analytics. Under his able leadership, the Conneqtion team has grown to 100+ Oracle certified consultants. In the past year, with his guidance and vision, Conneqtion has successfully implemented 50+ Enterprise transformations and have delivered 40+ OCI projects across the globe. Prior to Conneqtion, Karan was an integral part of Evosys Mastek, Deloitte and Oracle’s Consulting team and has worked for clients in North America, EMEA & JAPAC region.