Background * This blog was last tested on Fusion 20D (11.13.20.10.0) + ADW 18c * This article describes how to integrate Oracle Fusion Applications – WebCenter...
Background * This blog was last tested on Fusion 20D (11.13.20.10.0) + ADW 18c * This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with PL/SQL. Note: Oracle has discontinued File-Based Data Export support for CX Sales and B2B Service objects with the 20D Update. If you need help transitioning from File-Based Data Export, refer to the document Transition from File-Based Data Import to Import and Export...
Background * This blog was last tested on Fusion 20D (11.13.20.10.0) + ADW 18c * This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM)...
This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). It has not been re-tested on Oracle Analytics Cloud...
This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). It has not been re-tested on Oracle Analytics Cloud (OAC) with Autonomous Data Warehouse (ADW) - nor are there plans to do so. This blog has been left active as it may have some general value to Oracle Apex or Oracle SQL developers. Background This article outlines how to automate the loading of a JSON response with PL/SQL The main components of the PL/SQL code are as...
This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). It has not been re-tested on Oracle Analytics Cloud (OAC) with Autonomous Data Warehouse...
Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate...
Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate Oracle Service Cloud (RightNow) with PL/SQL, illustrating how to programmatically load Service Cloud data into Oracle Autonomous Data Warehouse (ADW), making it readily available to model and display in Oracle Analytics Cloud (OAC). PLEASE NOTE - this article is intended to provide the reader with some ideas of how to...
Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate Oracle Service Cloud (RightNow) with...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now supports direct connectivity to Oracle Fusion Sales Cloud, the BICS component of this blog has been removed and has not been converted to OAC. This is not a recommended method to integrate Fusion and Oracle Analytics Cloud (OAC). This blog has been left active to illustrate how PL/SQL may be used to integrate Oracle...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now supports direct connectivity to Oracle...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data represents some of the content from one of our wiki sites and he was trying to generate a report on some of that data. We considered using dbms_lob functions (e.g. dbms_lob.instr and dbms_lob.substr) to search and extract for the data, but ran into string length limitations. The solution we ended up with was to basically treat...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data represents some of the content from one of...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have direct access to the BI Common Semantic Model (RPD) or other config files. This can make it difficult or near impossible to change the global cache settings. That said, as a developer, you can still change the cache settings at the analysis request level. This can be done from the Advanced tab of the analysis request. If...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have direct access to the BI Common Semantic Model...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). ...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). Background At times a BI patch may fail with RPD consistency errors. If so, it may be beneficial to perform some initial troubleshooting steps to pinpoint the root cause of the errors. This blog describes how to read and download the various patch RPD and log files. Additionally, it gives insight into how these files can...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). Background At times a BI patch may fail with...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps are also applicable to previous OBI releases such as Oracle Business Intelligence Cloud Service (BICS) and Oracle Business Intelligence Enterprise Edition (OBIEE). By default all users with the BI Consumer role can view and run any analyses, dashboards, and agents directly though the Catalog UI. This article discusses...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps are also applicable to previous OBI releases...
Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store...
Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store them into a repository (for detailed information about the repository refer to this Blog). These models form the foundation for the Business Users to create Analyses, Dashboards, Key Performance Indicators (KPIs) and Reports. It has an in-built source control mechanism, but until recently, it could not be integrated...
Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store them into a repository (for...
