Subject: How to get a fusion base table for custom objects.
(To Learn More About Application Composer Visit Oracle Fusion: Application Composer)
There is 2 way to find custom object base tables.
1) Using Backend SQL Query Approach:
/*--Need to pass custom object api name--*/
/*--Get Table ID--*/
select TABLE_ID
from fusion.adf_extensible_table_usage
where ENTITYDEF_FULLNAME like '%customobject_api_name%';
/*--Need to pass custom Table Id from the above query--*/
/*--Get Table Name--*/
select TABLE_NAME
from fusion.adf_extensible_table where TABLE_ID = P_TABLE_ID;
/*--Combining above 2 query--*/
/*--Need to pass custom object api name only--*/
/*--Get Table Name--*/
select TABLE_NAME
from fusion.adf_extensible_table
where TABLE_ID IN (select TABLE_ID
from fusion.adf_extensible_table_usage
where ENTITYDEF_FULLNAME like '%PO_REF%');
2) Using Metadata Manager Approach:
Navigation:
Application Composer > Metadata Manager > Click on Generate > After Successfully Run > Click on Export.
Open the excel sheet. It is having all the custom object summaries.
Click on any custom object it will open the detailed mapping for that custom object. Let's click on the Bank_c custom object.
It's having all the custom object fields with base table mapping.
