Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Feature request for Oracle Business Intelligence Publisher connector

Answered
Tom Bescherer User
  • Edited

Hello!

We are using the Oracle Business Intelligence Publisher Connector. I have followed this guide https://fivetran.com/docs/connectors/applications/oracle-business-intelligence-publisher/troubleshooting/tables-missing-from-schema, and the following reports do not show up in the query provided '

SELECT TABLE_NAME, APPLICATION_SHORT_NAME FROM FUSION.FND_TABLES WHERE TABLE_NAME in ('HR_LOCATIONS_ALL', 'W_CUSTOMER_WAREHOUSE')

:

- HR_LOCATIONS_ALL

- W_CUSTOMER_WAREHOUSE

 

Can you please add support for these tables to the connector?

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Tom, 

    Did you run the second part of the query to check if the tables are active?  

    SELECT TABLE_NAME, APPLICATION_SHORT_NAME FROM FUSION.FND_TABLES WHERE select_allowed = 'Y' and status = 'Active' and TABLE_NAME = '<table_name>'

    Let me know what the output of this is. 

    Frank