cancel
Showing results for 
Search instead for 
Did you mean: 
amit_kothari
Employee
Employee

Introduction 

There are many Fusion modules like Oracle Trade Management or Oracle CPQ which do not integrate with Oracle BICC. In these cases, you can use other available methods, like Oracle BI Publisher (BIP) reports, to publish them to Oracle UCM, and then you can ingest them into Incorta using our connector. 

What you should know before reading this article 

Before exploring this topic further, we recommend that you be familiar with these Incorta concepts.  

Applies to 

These concepts apply to all versions of Incorta. 

Let's Go 

Now let's dive into the concepts that will help you publish your Oracle BIP reports to UCM. 

  • Create a BIP report in Oracle as a CSV format. Name it in the format: "file_<catalog>_<schema>_<table>", eg... file_invschema_inv_invtable1
  • Under Output, select the security group as below and push it to UCM  
  • Put in some values for the catalog and schema
  • You can follow the instructions in this article for defining a Destination File Name Dynamically with a Date Expression. 
amit_kothari_0-1688065622591.png
  • Make sure that the oracle cloud erp login has the 'BICC_UCM_CONTENT_ADMIN '  role granted in the oracle application.
  • Once the report csv has uploaded to UCM successfully, go to the UCM server, navigate to Search, and click on the Advanced Search. Type in the Security group name to filter out the files. Click on "Search" 
amit_kothari_1-1687296546113.png
  • In this example, you can see the file that was uploaded earlier 
amit_kothari_2-1687296546116.png
  • In Incorta, create a separate data connection using 'Oracle Cloud Application' since the UCM file pattern is different, add the file pattern and other details, and save the connection.  Refer the sample screenshot below

amit_kothari_0-1688050209653.png

  • Use schema wizard to create a table via the new connection on this UCM object
  • Ensure you turn off the incremental flag and use data discovery as 'Use Sample Data'. Check the screenshot below. 

amit_kothari_3-1687296546118.png

  • Save and load the table 

Related Material 

Comments
amit_kothari
Employee
Employee

If you do not see CSV as a valid output then edit the BIP report and click "View List" in the far right. Then in the screen shown navigate to output formats (these are the allowed output formats) - click on csv and save. After this, schedule shows the csv format in the list.

Best Practices Index
Best Practices

Just here to browse knowledge? This might help!

Contributors
Version history
Last update:
‎06-29-2023 12:07 PM
Updated by: