Wednesday, June 30, 2021

Deriving Business Object Service Endpoint and WSDL in Oracle Fusion

In order to derive the external virtual host and port for a tokenized service WSDL, we need to use the Review Topology page in the Offerings work area.
This page contains information about the domains and applications that are deployed on your cloud instance.

To access the Review Topology page, below entitlement needs to be granted to your job role -


Using the Service Catalog Service, below example shows how to derive the concrete service WSDL URL from the following tokenized URL -


Navigate to Setup and Maintenance work area, click the Tasks icon, and select the Review Topology task -

On the Review Topology page, select the Detailed tab.

In the Name column, expand the FADomain node.

Expand the FSCMUI subnode. 
For example-

The virtual host value is fs-your-cloud-hostname.

The port value is 443.

Replace the values in parenthesis in the tokenized URL with the identified external virtual host and port values: https://fs-your-cloud-hostname:443/fscmService/ServiceCatalogService?wsdl

Remove ?wsdl from the URL to derive the Service Catalog Service end point URL.


Wednesday, June 16, 2021

How to display images dynamically in BI Publisher reports in Oracle Fusion

Alright, so you have a set of images (say a few company Logos) that you want to display dynamically in your report based on some criteria.

Let's see how to achieve this in ERP Cloud BI Publisher.

  • First step is to convert convert the image file(s) into base64 encoding. You can use any open source web based tool to convert a given image and retrieve it's corresponding Base64 data.

  • Now you should have the base64 encoding representation of the image(s). 
    For example the following image has the below base64 representation -

    Image - 

    Base64 data -

  • Create the data model that decides which image should be displayed for a particular set of data depending on the required conditions and ensure to select the actual Base64 data as one of the XML tags.

  • Now, let's see how we can convert Base64 information in RTF and display it as an image.

  • This can be done using "foreign object" construct like this -
    <fo:instream-foreign-object content-type="image/jpg"><?IMAGE1?></fo:instream-foreign-object>

    Here IMAGE1 is a tag containing Base64 data of the image in your XML output.

  • XML data should look like this -

  • Below is how your template will look like -

  • And here's the output of your report showing the image dynamically -