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.