Accessing Physical Tables in OAC for Advanced SQL Use Cases

Loboo55

Hi all,

I've successfully established a connection from OAC to Oracle Applications and can access the logical tables (Subject Areas) from the Fusion Cloud environment. However, I would also like to work with the physical tables to meet more complex requirements using SQL.

Is this possible, or is there a recommended workaround for accessing the underlying physical data structures?

Best regards,
Loboo

Gianni Ceresa

Hi,

Are you using FDI? If not, where does the subject areas come from (who did build the semantic model)?

Loboo55

I am in the Cloud Version, the Subject Areas are coming directly from the Oracle Fusion Cloud Applications – the connection was established via the prebuilt Oracle Applications connector in OAC.

GayathriAnand-Oracle

You cannot access the physical tables in fusion directly. You can use Data Replication feature in OAC to populate ADW tables based on PVOs from fusion (bicc is used to extract from fusion).

Other option is to purchase Fusion Data Intelligence which gives you more options to bring fusion data to ADW using prebuilt pipelines.

Thanks

Gayathri

Loboo55

Thank you for the information, is there a guidline how i can replicate physical tables to the Oracle ADW?

Gianni Ceresa

If you mean the "Data Replication" option Gayathri mentioned, it is this: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/overview-data-replication.html

It doesn't give you access to physical tables, it doesn't replicate physical tables, it does export PVOs to ADW, and from there you can do whatever you want with those database tables.

The details about the PVOs (what means what, what is where etc.) are part of Fusion, it isn't really an analytics feature. That topic is covered in the parallel forum Cloud Customer Connect: https://community.oracle.com/customerconnect

Loboo55

Following our review, we have identified that FDI is also in use within our environment.
Could you please share any best practice documentation or guidance on how FDI has been successfully implemented in similar use cases?

We’re particularly interested in approaches that have proven effective and could support a successful deployment for our specific scenario.

Thank you in advance!