Sourcig data for BI Publisher Reports from Oracle Fusion cloud UCM

Senthilrajan V

Description

Creating a consolidated Oracle Fusion cloud BI Publisher Reports/Data Model that shall source data from Oracle Fusion cloud and external data which are loaded as CSV files to UCM using File Based Data Import approach (FBDI)

Use Case and Business Need

Business is looking for a BI Publisher report in Oracle Fusion Cloud ERP/SCM that shall source data from Fusion cloud SaaS database and along with that we need data from On Premise Oracle EBS on premise environment, On premise data shall be uploaded to a specific path in UCM through FBDI process.

More details

Currently Oracle Fusion cloud SaaS Application does not provide an option to source data for Fusion BI Publisher other than its SaaS database.

Original Idea Number: 744b2d61fb

Sandeep S. Chauhan-Oracle

Also, check - Is It Possible to Get UCM Files in the FND_ATTACHMENTS Tables from BI or a SQL Query? (Doc ID 2781879.1)