Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FAW - ADW content_upload_ccid_fin_cat_mapping access issue

Received Response
11
Views
1
Comments
Mohit Sobti
Mohit Sobti Rank 1 - Community Starter
edited Aug 13, 2024 7:36PM in Oracle Fusion Data Intelligence

Hi Guys,

Is there any way to query the table 'content_upload_ccid_fin_cat_mapping' (ADW table which will be created once you upload financial categories in FAW uploads). When we are checking sessions of FAW reports we are able to see above mentioned table in physical query. But at the same time when we are trying to query the same table in ADW its throwing error 'no table exists'

Could you please help us in querying this table(content_upload_ccid_fin_cat_mapping) in ADW, which will help us in creating in custom reports based on financial categories.


Regards,

Solman

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @Mohit Sobti

    Thank you for posting your question in Oracle Analytics Community.

    The table (content_upload_ccid_fin_cat_mapping) stores data for financial categories and are in a locked down schema. So they cannot be used for adhoc queries. This is an expected behavior.

    Thanks

    Subha