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.
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.
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"
In this example, you can see the file that was uploaded earlier
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
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.