1 Reply Latest reply: Nov 20, 2012 6:27 AM by Philip Stoyanov-Oracle RSS

    3.3EA1 Discover Foreign Keys not applying FK naming template properly

    Kent Graziano
      I reverse engineered in another schema (381 tables). It has PK but no FKs so I decided to use the Discover Foreign Keys utility (whihc seems to work fine overall),. The proble is that it did nto quite name the FKs correctly.

      My template is {child}_FK{seq nr}

      What I get is:
      RTMRMID0_TM_ROUTED_MED_FK2

      What I should get is:
      RTMRMID0_TM_ROUTED_MED_FK1

      Further if there is more than one on a table I get this:
      RTMRMID0_TM_ROUTED_MED_FK2
      RTMRMID0_TM_ROUTED_MED_FK2v1

      See the problem?

      If I then run use the Naming Rules button on the table dialog, the template is applied correctly!

      So I surmise the issue is in the Discover FK utility code.