Can you please provide read access to OAC_USER for the table DW_USAGE_PHYSICAL as it has the access on DW_USAGE_LOGICAL.
Actually, this access is needed to check what are the tables have been hit for a particular report using Full Physical SQL from DW_USAGE_PHYSICAL table.
Below SR has been cteated they advised us to open an enhancement. Please check and let us know the ETA.
4-0002691555: Unable to access oax$oac.dw_usage_physcial from Production ADW database through SQL Developer
