Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP Backend — Cloud Customer Connect
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

Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP Backend

Hi Team,

We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PRIMARY_KEYS" table, which is providing the expected results. However, when querying the "FND_FOREIGN_KEYS" table to obtain table relationships, we have found that this table is empty.

Could you please advise why the "FND_FOREIGN_KEYS" table does not contain any data? Alternatively, if we are referencing the incorrect table, is there another table or method available to obtain the relationships between backend tables?

Thank you for your assistance.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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