FAW - ADW content_upload_ccid_fin_cat_mapping access issue

Question

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

Subha_Tripathy-Oracle · Answer

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