Hi,
As I am inserting an entry into PersonInOrg during updating of Person table, I received the following error:
Error during execution of statement: insert into PersonInOrg (UID_org, UID_Person)....
Cannot insert object in PersonInBaseTree because the associated object in BaseTree does not exist.
Upon checking PersonInBaseTree table, entries tagged to the Person(based on UID_Person) shows there are entries in it.
What is the relationship between PersonInBaseTree, PersonInOrg & Person and what are the implications of any discrepancies between these tables?
I understand that PersonInOrg represents the secondary business roles assignment for the Person (correct me if im wrong).
However, the error that I am facing is now pointing to PersonInBaseTree, which I'm not sure why.
Thank you!