Multiple Relationship records between Account and SHM Site
Hi,
Account and SHM Site are party business components and have M:M relationship.
The intersection table between them is S_PARTY_REL.
Now, we found a limitation that more than one record for relationship between Account and SHM Site can not be inserted in this table.
It checks only for REL_PARTY_ID and PARTY_ID combination and if record exists, it does not allow to create another record.
We have business need to have multiple records in this table with same REL_PARTY_ID and PARTY_ID with different REL_TYPE_CD.
Have you encountered such problem in your implementation?
Account and SHM Site are party business components and have M:M relationship.
The intersection table between them is S_PARTY_REL.
Now, we found a limitation that more than one record for relationship between Account and SHM Site can not be inserted in this table.
It checks only for REL_PARTY_ID and PARTY_ID combination and if record exists, it does not allow to create another record.
We have business need to have multiple records in this table with same REL_PARTY_ID and PARTY_ID with different REL_TYPE_CD.
Have you encountered such problem in your implementation?
0