Oracle Common Technologies and User Experience
New Feature Summary
  1. Update 19D
  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. Extensibility
        1. Scheduled Batch Processing of Custom Logic Now Available for ERP and SCM Custom Objects
        2. Unified Sandboxes
    3. User Experience
        1. Applications Help Moves to Oracle Help Center
    4. Reporting and Analytics
        1. Set Parameters as Mandatory
        2. Creating New Direct Database Query in BI Answers is Disabled
        3. Configure New BI Reporting Duty Roles to Hide the Factory Catalog Folders
        4. Support for CLOB Data Without XML Tags

Update 19D

Revision History

Date Feature Notes
06 SEP 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.

Extensibility

Scheduled Batch Processing of Custom Logic Now Available for ERP and SCM Custom Objects

You can now use Scheduled Processes to run a custom object's object function on a set of records at a scheduled time. You can process a set of records on a daily or weekly basis, for example, and you can do it asynchronously, when users don't need to see immediate feedback on the page. You can schedule and submit the Schedule Custom Groovy Object Functions process for top-level ERP and SCM custom objects only. You can't do this for ERP and SCM standard objects.

Unified Sandboxes

You can now use the Unified Sandboxes feature, which is the opt-in feature enabled for you by default. Use 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 do 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. You also get a new UI for Configuration Set Migration, and new migration options with this feature.

User Experience

Applications Help Moves to Oracle Help Center

Instead of accessing help through a separate Applications Help portal, all help and documentation is now available from a single location: Oracle Help Center. You get to the help content from the application with fewer clicks, you can keep it open while you work, and the table of contents makes it easy to find additional related content. You can add your own help links to help windows, just as you did before, and your existing help works in the new approach without you doing anything.

Reporting and Analytics

Set Parameters as Mandatory

You can now set data model parameters as mandatory to prevent unintended execution of reports without necessary parameter selections and to ensure a minimum set of required parameters support creation of meaningful reports. Once set as mandatory, a parameter appears with an asterisk next to its parameter label. Report generation is allowed only once a parameter value is entered or selected.

Creating New Direct Database Query in BI Answers is Disabled

To protect data security and prevent slow-running reports, the ability to create Direct Database Query in BI Answers is disabled. BI Administrators are no longer able to create new BI analyses with Direct Database Query or modify existing ones, but can continue to execute existing ones in 19D. Customers are advised that in the upcoming 20A update, the capability to execute Direct Database Query in BI Answers will be permanently removed. This change doesn’t affect the SQL capabilities in BI Publisher.

Configure New BI Reporting Duty Roles to Hide the Factory Catalog Folders

Users are provisioned with the BI Consumer role, which allows you to navigate the entire BI catalog folder structure. Analytics and reports are properly secured based on your security profile. You may have a need to hide some or all of the factory BI catalog content. To allow modification of catalog folder access, BI has introduced a new set of BI catalog reporting duty roles to secure catalog root folders. The new feature provides the ability to:

  • Hide the entire factory BI catalog
  • Selectively display seeded BI family root folders
  • Limit users who have access to factory BI catalog

Support for CLOB Data Without XML Tags

If your SQL data set has a CLOB column, the general behavior of a data model is to wrap the CLOB within wrapper XML tags. In many cases, it's desirable to see the data exactly as it's stored. You can now enable the Exclude Tags for CLOB Columns data model XML Output Options property to remove the wrapper XML tags.