UCM using REST API in Oracle Fusion

Uploading a File to UCM using REST API in Oracle fusion.








API endpoint used - /fscmRestApi/resources/11.13.18.05/erpintegrations 

Applications used -  POSTMAN, Oracle Fusion

Sample Request Payload -

{
  "OperationName":"uploadFileToUCM",
  "DocumentContent":"VGVzdGluZyB1Y20gdXBsb2FkIHVzaW5nIHJlc3QgYXBp",
  "DocumentAccount":"fin$/payables$/import$",
  "ContentType":"txt",
  "FileName":"REST_UCM.txt",
  "DocumentId":null
}


Response Payload -                                                                                  

    {
  "OperationName": "uploadFileToUCM",
    "DocumentId": "600239",
    "DocumentContent": "VGVzdGluZyB1Y20gdXBsb2FkIHVzaW5nIHJlc3QgYXBp",
    "FileName": "REST_UCM.txt",
    "ContentType": "txt",
    "FileType": null,
    "DocumentAccount": "fin$/payables$/import$",
    "Comments": null,
    "ProcessName": null,
    "LoadRequestId": null,
    "JobPackageName": null,
    "JobDefName": null,
    "ReqstId": null,
    "RequestStatus": null,
    "JobName": null,
    "ParameterList": null,
    "NotificationCode": null,
    "CallbackURL": null,
    "JobOptions": null,
    "StatusCode": null,
    "ESSParameters": null
}


Screenshots -

Postman - 





 Oracle Fusion  - 







Comments

Post a Comment

Popular posts from this blog

OTBI Report Mailing/Bursting in Oracle Fusion

Image
In this post, lets discuss the process of mailing or bursting an OTBI report to business users. Much like BI report bursting, this functionality enables you to customize the mail subject, body, output file format and mail recipients.   Supported Formats by OTBI -  HTML,  Plain Text,  CSV,  Tab Delimited,  Excel,  PowerPoint,  PDF   Step 1 - Select a recipient to  schedule with and set a mail frequency : 1) Go to the OTBI Report you want to Mail. Navigate to More > Schedule > General. 2) Select a User ID/Name to execute the agent. 3) Set the desired mail frequency (once/daily/weekly/monthly). You can optionally specify an end date.   Note - Condition Tab is set by default. The condition in below screenshot checks whether the report is generating any output or not.   Step 2 – OTBI Report Selection and Email Customization: 1) Choose "Analysis" from the content tab dropdown and locate your OTBI Analysis. 2) Customize th...
Read more

Import Data from CSV/EXCEL using SQL Developer

Image
Importing CSV File data in SQL Developer   Helps put data directly in staging tables using simple CSV files. Sample CSV File - https://drive.google.com/file/d/1logX26_i_0yHYxS6wJZyxS7utcdjYIRp/view?usp=sharing Follow the link for detailed explanation video -  https://youtu.be/Ij7_4dMb8wk
Read more

Query Parameters in REST API for Oracle Fusion

Image
Let’s discuss some key parameters frequently used in fusion REST APIs.   Let's use the following API endpoint as our reference throughout -   /fscmRestApi/resources/11.13.18.05/invoices   Query Parameters: 1)      Expand Fields like invoiceDFF, invoiceLines are not fetched by default in this API. The Expand parameter allows fetching additional fields. Fields that are usable in parameter – invoiceLines invoiceGdf invoiceDff invoiceInstallments attachments appliedPrepayments availablePrepayments   Example – Put this string in Bulk edit: expand:appliedPrepayments,invoiceDff,attachments,availablePrepayments,invoiceGdf,invoiceInstallments,invoiceLines     2)      Fields Fetch any Specific field that you want. Including Expand fields mentioned above.   Example – Put this string in Bulk edit: -  fields:InvoiceId,InvoiceNumber,invoiceDff   3)      Limit Limit the number of rec...
Read more