My Oracle Support Banner

SSDM Alters The Name Of The"Foreign Key" Attribute In The Child Entity (Doc ID 1451524.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer Data Modeler - Version All to All
Information in this document applies to any platform.

Symptoms

In case of two entities with one-to-many relation and the parent has an UID-attribute (XXX.AA) with the same name as an attribute in the child (YYY.AA),

the name of the corresponding "FK-"attribute (XXX.AA in YYY) will change whenever an attribute in the parent will change. (An suffix 1 or 2 will be added to XXX.AA in YYY).

 

That is,

-  open the edit dialog for the child and observe the name of the FK-attribute (e.g. AA1, in fact XXX.AA)

- select an attribute in the parent in the edit dialog (and click ok)

- now open the edit dialog for the child again and observe the name of the FK-attribute

- the name has changed from AA1 to AA2 (or vice versa).

 


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.