You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

List of all backend tables which stores Custom Objects Details

Summary:

List of all backend tables which stores Custom Objects Details

Content (required):

Whenever custom object is created, Oracle assigns the backend table automatically. we would like to get the list of all possible tables that custom object would get assigned when it gets created.

We use below query to identify created custom object table names:

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 '%customobjAPIName%')

We would like to get the complete list of all possible custom object table names which can be occupied in future as well.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!