Hi all,
I’m working in Oracle Fusion BI Publisher to extract metadata (table and column comments) for documentation purposes.
Observation:
- For POZ_SUPPLIERS, my query returns both the VIEW and the underlying TABLE, and both have populated
COMMENTS.
- For AP_INVOICES_ALL, I only get the VIEW — there’s no physical table listed in the
FUSION schema, and the COMMENTS field for the view is blank.
Query used:
SELECT *
FROM all_tab_comments
WHERE UPPER(table_name) IN ('POZ_SUPPLIERS', 'AP_INVOICES_ALL');
Requirement:
I need to retrieve the table object (not just the view) for AP_INVOICES_ALL along with its COMMENTS for documentation.
If you know the answer please respond.