Hi Team - I am trying to retreive the DDL scripts for some of the tables in Fusion schema from Oracle BIP by creating a custom SQL datamodel.
I can see that below tables are present in Fusion schema when I query from ALL_TABLES using this query
select TABLE_NAME, OWNER
from all_tables
where 1=1
and table_name = 'ap_invoices_all'
Results
TABLE_NAME: ap_invoices_all
OWNER: FUSION
However when I run the below query to get the ddl
select dbms_metadata.get_ddl('TABLE','ap_invoices_all','FUSION') tableddl
from dual
I get below error -
ORA-31603: object "ap_invoices_all" of type TABLE not found in schema "FUSION" ORA-06512: at "SYS.DBMS_METADATA", line 6731 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.DBMS_METADATA", line 2588 ORA-06512: at "SYS.DBMS_METADATA", line 2827 ORA-06512: at "SYS.DBMS_METADATA", line 3608 ORA-06512: at "SYS.DBMS_METADATA", line 5008 ORA-06512: at "SYS.DBMS_METADATA", line 5336 ORA-06512: at "SYS.DBMS_METADATA", line 6702 ORA-06512: at "SYS.DBMS_METADATA", line 9734 ORA-06512: at line 1
Any suggestion on this?