My Oracle Support Banner

FAW: DFF Tables Not Accessible Using OAX_USER and Admin User Accounts (Doc ID 2955998.1)

Last updated on JUNE 23, 2023

Applies to:

Fusion Analytics Warehouse - Version 23.R1.x and later
Information in this document applies to any platform.

Goal

Unable to access DFF tables from FAW ADW database using OAX_USER and admin user accounts.
There are some downstream applications that are dependent on these DFF tables.
But unable to select these tables from mentioned schemas.
How to access the DFF tables for downstream customization ?

Following is a sample list of DFF tables.
DW_PO_AGRMNT_HEADERS_DFF
DW_PO_AGRMNT_LINES_DFF
DW_AP_INVOICES_DFF
 

Solution

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
Goal
Solution


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