Is there a way to show OTM data in OTBI?

Naresh313

Hi All,

We have an requirement to show OTM related data in OTBI reports.

Nathan CCC

Hi, What is OTM? Oracle Transportation Management (OTM)?

Is this a module that is part of Oracle Fusion Cloud Applications? Is OTM in SCM?

OTBI is for Oracle Fusion Cloud Applications https://docs.oracle.com/en/cloud/saas/index.html.

If you go to the following page you get the list of subject areas at the bottom analytics/saw.dll?PrivilegeAdmin

And if you go to your user guide for each application you can read about each one For example, SCM

subject areas

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/23c/faosm/index.html#COPYRIGHT_0000

application database tables and views

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/23c/oedsc/index.html#COPYRIGHT_0000

and data lineage

https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

Naresh313

Hi Nathan,

Yes, OTM - Mean Oracle Transportation Management. Heard that for OTM we has it's own database . Can we build reports using OTBI?

Nathan CCC

Hi Yes that was why I posted the 3 links.

If a subject area exists you can build an analysis in OTBI (or a report in OTBI using bi as a data source).

If the tables and views exist in one of the data sources in your data model then you can build a report in OTBI.

If you know the table or view but need to know if a subject area exists that reads it then look in the data lineage.

Naresh313

Thanks for the update.

As per the oracle documentation, we don't have any prebuilt data models /subject areas available in SCM.

In some of the oracle blogs, it was mentioned that we have to use FTI(Fusion Transactional Intelligence) to build transactional reports in OTM.

Hence, trying to understand if we can call the reports that are built in FTI to OTBI

Nathan CCC

Hi, OTBI is "Oracle Transactional Business Intellignece" part of "Oracle Fusion Cloud Applications". OTBI = the patform "Oracle Business Intelligence (OBI) suite (Enterprise Edition EE)" + inside OBI our prebuilt analytics and reports and subject areas in the metadata repository database for each application.

I have never heard of FTI? Is this perhaps a blogger making a mistake with an abmigous reference mixing up some of the words from to OTBI and Fusion? When I google FTI I only hit OTBI? https://www.google.com/search?q=Fusion+Transactional+Intelligence

Naresh313

hi Sorry, My bad it is Fusion Transportation Intelligence.