we have a requirement from client to access the ATP data in fusion and create reports combining both Fusion and ATP data.
Oracle Analytics Publisher in Oracle Fusion Apps Cloud is designed to access data from Fusion Apps transactional database.
JDBC/JNDI connections to external databases aren't supported.
Refer https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/data-source-connections.html