X

Best Practices from Oracle Development's A‑Team

Integrating PCS, CEC and BI Publisher using OSB/SOACS – Part 1

Derek Kam
Consulting Solutions Architect

Introduction

In this 3 part blog series, I will be demonstrating how to use PCS to invoke OSB (On-Prem or SOACS) services and upload a report/doc generated using BI Publisher to CEC.  The following components are used in this demonstration:

  • Oracle Content and Experience Cloud (CEC)

  • Process Cloud Service (PCS) with CEC integration configured.

  • BI Publisher 12.2.1 with sample reports installed

  • SOACS with OSB or OSB On-Prem.

In this blog series, I will be covering the following topics:
Part 1 - Overview and Setup (Part 1) – cover the use case, configuration steps for PCS, BI Publisher and CEC REST Services.
Part 2 - OSB Services Design (Part 2) – cover the OSB service design in detail and what you need to look out for when you design your OSB services.
Part 3 - PCS Application Design and Testing (Part 3) – cover the PCS process design and how to test the sample project.

Use Case

We will use PCS to design a Salary Report request process, the process allows the user to submit a salary report request and generate a PDF report in BI Publisher.  We also need to create a report folder dynamically and attach the PDF report to the newly created folder in the same PCS process instance so that we can review and approve the generated report.

PCS_DOCS_BI_OSB_High-Level

PCS and CEC/DOCS Integration

We will need to configure PCS and CEC/DOCS integration in order for this demonstration to work, the instruction for PCS and CEC configuration can be found here.

PCS_DOCS_BI_OSB_PCS-DOCS

We will use the default folder structure in this demonstration. However, you can also configure the folder structure (shown below) if it’s required.

PCS_DOCS_BI_OSB_PCS-DOCS Configuration in PCS

Once the PCS and CEC integration have been configured, when a process is initiated, a process folder for that process instance will be created in CEC.  We can then login to CEC using the same username and password we used to configure PCS and CEC integration to review the folder structure:

PCS_DOCS_BI_OSB_DOCS_FolderStructure

CEC REST Services

CEC exposes a number of REST services to retrieve folder/item information and upload the file using multipart messages.  In this demonstration, we will use the following CEC REST API to retrieve the folder ID and upload file:

Resource URI Method Description
/api/1.1/folders/items GET Get a collection of all items (folders and files) that user has access to, including folders that others have shared with that user. The type field indicates if an item is a folder or file.
/api/1.1/folders/{folder id} GET Get folder information (metadata) for the specified folder.
/api/1.1/folders/{folder id} POST Create a new subfolder in the specified destination folder.
/api/1.1/folders/{folder id}/items GET Get a collection of child items (folders and files) in the specified folder. The type field indicates if an item is a folder or file.
/api/1.1/files/data POST Upload a new file using a multipart request to specify destination and file information.

BI Publisher

BI Publisher exposes a web service called report service, which has an operation called runReport. This operation allows you to run a report with or without input parameters and return the generated report in the base64 encoded data format.  A list of operations available in BI Report Service is here

In this demonstration, we will be using the sample report called SalaryReport without parameter, the generated report will be a PDF file in the base64 encoded data format.

SOACS and OSB on-premise

If you are planning to use SOACS, you will need to expose the BI Publisher report service externally so it can be invoked by SOACS.  If you are using OSB on-premise to invoke the BI Publisher report service, you will need to expose the OSB service externally to allow PCS to invoke, and you will also need to import the SSL certificate from CEC to your OSB managed server trust store.

Summary

In this first part of this blog series, we have covered the use case, basic integration configuration, and setup required for the PCS, CEC, BI Publisher and OSB.  In part 2 of the blog, we will examine OSB services design in detail.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha