Oracle Common Technologies and User Experience
New Feature Summary
  1. Update 19C
  1. Revision History
  2. Overview
    1. BI Cloud Connector
        1. Inactive and Unavailable BI View Objects (BIVOs) and BIVO Columns for Exclusion from Extraction in BI Cloud Connector
        2. Multiple Job Profiles Support
        3. Support for Oracle Cloud Infrastructure (OCI) Object Storage
        4. OTBI Metadata Independent Mode for Extraction
    2. Extensibility
        1. Unified Sandboxes
    3. Reporting and Analytics
        1. New Search Type Parameter in Data Model
        2. Password Protect and Zip Your Output Delivery
        3. Use relogon=1 in URL Parameter to Apply Fusion Apps User Preferences
        4. XML Data Chunking for Extremely Large Data Sets

Update 19C

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Date Feature Notes
21 JUN 2019 Multiple Job Profiles Support Updated document. Delivered feature in update 19C.
21 JUN 2019 OTBI Metadata Independent Mode for Extraction

Updated document. Delivered feature in update 19C.

21 JUN 2019 Support for Oracle Cloud Infrastructure (OCI) Object Storage

Updated document. Delivered feature in update 19C.

21 JUN 2019 New Search Type Parameter in Data Model

Updated document. Delivered feature in update 19C.

21 JUN 2019 Password Protect and Zip Your Output Delivery

Updated document. Delivered feature in update 19C.

21 JUN 2019 Use relogon=1 in URL Parameter to Apply Fusion Apps User Preferences

Updated document. Delivered feature in update 19C.

21 JUN 2019 XML Data Chunking for Extremely Large Data Sets

Updated document. Delivered feature in update 19C.

07 JUN 2019   Created initial document.

Overview

This guide outlines the information you need to know about new or improved functionality in this update.

Disclaimer

The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.

BI Cloud Connector

Inactive and Unavailable BI View Objects (BIVOs) and BIVO Columns for Exclusion from Extraction in BI Cloud Connector

Beginning with Update 18B, there are BI View Objects and BI View Object columns that are unavailable or marked inactive in Oracle Applications Cloud. These objects are unavailable for extraction using BICC in Oracle Applications Cloud.

Multiple Job Profiles Support

BI Cloud Connector (BICC) now supports multiple job profiles. You can use the Manage Jobs feature if you use BICC to extract data from Oracle Applications Cloud to support multiple downstream integrations.

Support for Oracle Cloud Infrastructure (OCI) Object Storage

Beginning with release 19C, BI Cloud Connector (BICC) now supports Oracle Cloud Infrastructure (OCI) Object Storage as an external storage option. You can use this external storage for your BICC extracts if you have a subscription to OCI Object Storage.

OTBI Metadata Independent Mode for Extraction

In release 19C, BI View Objects may now be extracted in OTBI Metadata Independent Mode.

Oracle Development strongly recommends that you switch your BICC extracts to use OTBI Metadata Independent mode by release 20C.

Extensibility

Unified Sandboxes

You can now opt in for Unified Sandboxes to enhance your user experience and productivity when working with sandboxes. With Unified Sandboxes, you can refresh and merge sandboxes with changes in the mainline environment, and perform many other new and versatile sandbox activities. In addition to making the sandbox experience more consistent across all configuration tools, this feature also introduces a more robust user interface. Additionally, you get a new UI for Configuration Set Migration, and new migration options with this feature.

Reporting and Analytics

New Search Type Parameter in Data Model

When you create a parameter using List of Value (LOV), the LOV query is executed to populate the LOV selections. At times this can cause performance bottleneck when the LOV queries are very complex and fetches huge amount of data. To handle this scenario, a new Search type parameter has been added that allows user to enter few characters to narrow down the parameter selection. You can even use the search icon to navigate to search window where you can enter few characters, and select the value required for the report, thereby keeping the parameter selection minimal and applying a single selection value.

Password Protect and Zip Your Output Delivery

Now you can safeguard the output file by adding password protection and then include the file in a zip archive format before delivery. The password protection will apply to Microsoft office file formats (XSLX, PPTX, DOCX)  which can be applied from the runtime properties page. PDF password protection has been there for a while. The password protection will apply to both online viewed reports and scheduled jobs.

NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.

Also at the time of scheduling a job, you can select the option "Compress output prior to delivery" to archive the output file in a zip file format before it is sent through a delivery channel. Compress output feature is not supported for PDFZ format as it is already a zipped file format and HTML format for email delivery.

So you can choose to apply only password protection, only compression or both.

Use relogon=1 in URL Parameter to Apply Fusion Apps User Preferences

When you make a change to User Preferences from Fusion Applications User Preferences UI, the change does not immediately reflect in BI Publisher reports if the session is not renewed. To make this work, one has to navigate to BI Publisher server and logout the user. With a new login session, the updated user preferences starts working correctly.

To eliminate this dependency, now you can simply append relogon=1 parameter in the URL of BI Publisher report it will pick up the latest Fusion Apps User Preference, without session renewal.

XML Data Chunking for Extremely Large Data Sets

The XML data chunking capability in BI Publisher reduces the time and memory used for processing large data of size greater than 2 GB.  The concepts are similar to bursting where a single large XML data will be split into several smaller chunks of XML data of manageable size, be executed as multiple sub-jobs in parallel to process the individual XML data chunks, and finally merges the outputs to create a single consolidated output.