My Oracle Support Banner

FAW: Custom Subject Area Report Based On External Merge RPD Fails With ORA-00942 Error. (Doc ID 2980474.1)

Last updated on OCTOBER 25, 2023

Applies to:

Fusion Analytics Warehouse - Version N/A and later
Information in this document applies to any platform.


As part of the limited availability, the external application merge capability within FAW has been enabled and this feature is working as expected. After merging the custom RPD with the semantic template of FAW and importing it, the custom subject area is available for reporting. Created the custom objects in the custom schema and given read only access to these objects to OAX$OAC

But the reports fail with below error when the custom subject area columns are used.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.