nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Oracle AI and Analytics

Child Item

Child Item

OTBI Reports in FAW

Manish Sharma-24619

Summary

Using OTBI reports in FAW

Content

Hi team

How can we use our current OTBI reports in FAW, we are able to connect to OTBI but not able to access our current reports.

Regards

Manish

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

Sumanth V -Oracle

Please refer the below document which has the steps and details on how to connect to Fusion applications from OAC.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#GUID-067CC574-D859-40CB-8300-027D682FB8A5

You can also use the below blog as reference to setup.

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://www.clearpeaks.com/oac-to-otbi-connections-improvements/%23:~:text%3DOnce%2520users%2520have%2520been%2520created,Connection%2520and%2520select%2520Oracle%2520Applications.&ved=2ahUKEwjx4_eSmJeEAxVfqFYBHfI2BTEQFnoECA0QBQ&usg=AOvVaw2IWJMiAKd-AZIoDvtvUfO7

All comments

Ravi Guddanti-Oracle

Hi Manish

When you create a new data set from your Fusion OTBI self service connector and choose Select an Analysis, are you able to see the folders as shown in the below screenshot?
Are you able to access your reports through that page?

Thanks
Ravi

Hi Ravi G - Does this apply to BI Publisher reports ?

Ravi Guddanti-Oracle

Hi Dhruv - not for BIP reports. Thanks.

Is there certain level of access needed in order to initiate this please? We currently have misalignment with FAW/OTBI

Sumanth V -Oracle

Please refer the below document which has the steps and details on how to connect to Fusion applications from OAC.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#GUID-067CC574-D859-40CB-8300-027D682FB8A5

You can also use the below blog as reference to setup.

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://www.clearpeaks.com/oac-to-otbi-connections-improvements/%23:~:text%3DOnce%2520users%2520have%2520been%2520created,Connection%2520and%2520select%2520Oracle%2520Applications.&ved=2ahUKEwjx4_eSmJeEAxVfqFYBHfI2BTEQFnoECA0QBQ&usg=AOvVaw2IWJMiAKd-AZIoDvtvUfO7

Thanks @Sumanth V -Oracle really appreciated

Baskar.Chakravarthi

Thanks very useful.

Top Leaders

Bhaskar Konar 171

JohnW-Oracle 127

Raghavendra Raghunath-Oracle 105

SaurabhPSingh 60

Top Posts

Why 'Total duration of Absence(days)' field didn't fetch Life leave & Annual leave half pay data.
Under the Workforce - Absence Management subject area, the Total Duration of Absence (Days) field does not return data for Life Leave and Annual Leave Half Pay. As an alternative, I used the Absence Duration field, which successfully captures all leave types. However, it does not correctly retrieve leave records that span…
Issue in Retrieving Data
Hello Experts, I am having issue while working with HCM - Workforce Core in which I am using Person Number and Department Name. The value getting is not in line with the data in my fusion environment. Please guide what I am missing. 26C.
Prerequisites to Enable the AI Concierge for SME.
Team, I heard we can use the AI assistance for generating the Start model in the SME. So how to enable this feature as our instances are already in 26.R2 version. Using this blog for reference: Guided Star Schema Generation: Bringing AI-Assisted Design to Semantic Model Customization | analytics Regards, Guru
In subject area: Procurement-Purchasing Real Time is PO line amount column available out of the box
Hi Experts, We are trying to create a report using OTBI to extract the PO line amount - Do we have the column which extracts the PO line amount out of the box available under subject area: Procurement-Purchasing Real Time or do we need to calculate it using the formula - PO Line Amount = Ordered Quantity × Unit Price Any…
Fusion Data Intelligence; Where to start?
Hi everyone, I'm a functional consultant. Looking to learn about Fusion Data Intelligence. Where can I start with? I want t learn everything about it. Would be grateful if someone could guide me. Thanks. Regards, Fasahat Ali