Skip to content

Ch2: Invalid FK for organization_rollup_party_relationship_fk  #7

@dfhawthorne

Description

@dfhawthorne

Adding FK fails with:

Error starting at line : 410 in command -
ALTER TABLE organization_rollup
    ADD CONSTRAINT organization_rollup_party_relationship_fk FOREIGN KEY ( from_date )
        REFERENCES party_relationship ( from_date,
                                        party_role_party_role_id,
                                        party_role_party_party_id,
                                        party_role_party_role_id2,
                                        party_role_party_party_id2 )
    NOT DEFERRABLE
Error report -
ORA-02256: number of referencing columns must match referenced columns
02256. 00000 -  "number of referencing columns must match referenced columns"
*Cause:    The number of columns in the foreign-key referencing list is not
           equal to the number of columns in the referenced list.
*Action:   Make sure that the referencing columns match the referenced
           columns.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions