Get Started

Visual Builder Extension for Fusion SaaS: upload an attachment without existing REST API endpoint

Upload Attachments without a REST Endpoint: Visual Builder Extension for Fusion SaaS

General

Oracle Visual Builder Studio has a pre-configured backends for REST API available in Fusion Apps.
Not all business entities that allow attachment management in UI of Fusion Apps expose REST APIs for attachment management.
This post will show how to overcome this obstacle by utilizing SOAP ErpObjectAttachmentService, Application Composer, Groovy and Oracle Integration Cloud.

Use Case

Upload an attachment for Payables Check.
The existing REST APIs for Payable Payments are listed in the official documentation and do not have attachments.

High Level Implementation Details

  1. Create an OIC REST integration that will expose ErpObjectAttachmentService available in Cloud ERP adapter as REST call.
  2. Enhance the REST Utility described here by adding a new externally callable groovy method.
  3. Use FUN_ERP_ATTACHMENT_CONTEXTS to convert PK values used in FND_ATTACHED_DOCUMENTS to user keys acceptable by ErpObjectAttachmentService.
  4. Use standard REST call in Visual Builder to upload the attachment

Detailed Implementation Details

  1. Create an OIC Integration with following JSON payloads for request and response:
    Request:
    {
    “entityName” : “AP_CHECKS_ALL”,
    “categoryName” : “PAYMENT_SUPPORTING_DOC”,
    “UserKeyA” : “35”,
    “UserKeyB” : “#NULL”,
    “UserKeyC” : “#NULL”,
    “UserKeyD” : “#NULL”,
    “UserKeyE” : “#NULL”,
    “Title” : “attach.txt”,
    “Content” : “SGVsbG8gV29ybGQ=”
    }

    Response:
    {
    “result” : “Attachment1: SUCCEEDED”,
    “success” : true
    }

    Screenshot 2024 06 22 at 16.21.04
  2. Add a new externally callable groovy method:
    Screenshot 2024 06 22 at 16.24.03
  3. To calculate the conversion between keys in FND_ATTACHED_DOCUMENTS and ErpObjectAttachmentService – use the query below than can be achieved by our free tool.
    Screenshot 2024 06 22 at 16.27.07
  4. Use standard REST call to call previously exposed groovy method:
    Screenshot 2024 06 22 at 16.32.38 1
Table of Contents

Leave a Reply

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