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

Child Item

How to connect OAC to oracle Application

Nalsoft Pvt Ltd

followed the below document, but not able to connect.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-oracle-fusion-cloud-applications-suite.html#ACSDS-GUID-A690D639-B58F-4C19-A685-4D139E71EA7F

Find more posts tagged with

Oracle Fusion Analytics

HCM Analytics Content

OAC

Fusion HCM Analytics

#OracleAnalytics

Accepted answers

Sumanth V -Oracle

@Nalsoft Pvt Ltd -

Yes, you can leverage Fusion application's data security in OAC by using the options below under Authentication to specify how you'd like to authenticate the connection:

Always use these credentials
- Oracle Analytics always uses the login name and password you provide for the connection.
- Users aren’t prompted to log in.
Require users to enter their own credentials
- Oracle Analytics prompts users to enter their own username and password for the data source.
- Users can only access data for which they have permissions, privileges, and role assignments.
Use the active user’s credentials
- Oracle Analytics doesn't prompt users to sign in to access the data.
- The same credentials they used to sign in to Oracle Analytics are used to access this data source.
- Ensure that the Oracle Analytics user exists in Oracle Transactional Business Intelligence.
- For additional details, see Configure Impersonate User for the Use Active User Credentials Option.

Hope this helps!

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62218#Comment_62218

It doesn't work exactly the same way as we have a difference in terminology. But data will be secured as per roles in FA.

Check below blog for more details:

Implementing Data Level Security in Oracle Analytics Cloud Using Identity Cloud Service

Thanks.

All comments

Sumanth V -Oracle

@Nalsoft Pvt Ltd -

The document you are referencing is accurate for connecting an OAC application to Oracle Applications. Currently, you can connect only to the following applications within the Fusion Applications Suite:

Oracle Fusion Cloud Financials
Oracle Fusion Cloud Human Capital Management
Oracle Fusion Cloud Loyalty
Oracle Fusion Cloud Procurement
Oracle Fusion Cloud Project
Oracle Fusion Cloud Supply Chain Planning
Oracle Sales Automation

Please ensure that you are attempting to connect to one of the above-listed applications. If you are, kindly share the error message encountered while trying to create the connection.

Thank you!

Nalsoft Pvt Ltd

Hi Sumanth,

Thanks for the quick response, connection is created now as I didn't included /analytics in the URL when connecting.

I have a doubt that when we connect fusion application with FAW/FDI, we have pre built content in OAC ready, but when we connect with OAC to oracle fusion application i see no such pre built content. Is that an expected behavior?

Best Regards,

Sai Hemanth

Sumanth V -Oracle

@Nalsoft Pvt Ltd - Yes, it's expected behavior, you will have no prebuilt content.

When you connect to applications in Fusion Applications Suite, you access the data from an Oracle Transactional Business Intelligence report unlike FDI.

Nalsoft Pvt Ltd

Hi Sumanth,

How can we implement data security restrictions in OAC? are the data roles present in fusion application which are assigned to the user will work for the data in OAC as well?

Best Regards,

Sai Hemanth

Sumanth V -Oracle

@Nalsoft Pvt Ltd -

Yes, you can leverage Fusion application's data security in OAC by using the options below under Authentication to specify how you'd like to authenticate the connection:

Always use these credentials
- Oracle Analytics always uses the login name and password you provide for the connection.
- Users aren’t prompted to log in.
Require users to enter their own credentials
- Oracle Analytics prompts users to enter their own username and password for the data source.
- Users can only access data for which they have permissions, privileges, and role assignments.
Use the active user’s credentials
- Oracle Analytics doesn't prompt users to sign in to access the data.
- The same credentials they used to sign in to Oracle Analytics are used to access this data source.
- Ensure that the Oracle Analytics user exists in Oracle Transactional Business Intelligence.
- For additional details, see Configure Impersonate User for the Use Active User Credentials Option.

Hope this helps!

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62218#Comment_62218

It doesn't work exactly the same way as we have a difference in terminology. But data will be secured as per roles in FA.

Check below blog for more details:

Implementing Data Level Security in Oracle Analytics Cloud Using Identity Cloud Service

Thanks.

Nalsoft Pvt Ltd

Hi Sumanth & Mandeep,

Thank you for your response. My doubt is cleared.

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders