on 11-19-2014 6:47 AM
Dear All,
We have a major issue in SRM system in HRT1222 table.The entries in the table exceed 7 million entries which is affecting the organization structure performance.When checked we found there are duplicates in the system for each attribute.
For example: the same product category is duplicated 1000 times in the table.hence would like to know what is the major reason for having these duplicates.I got few hints but needed expert inputs on this.
Regards
Swathi
Hi Swathi,
The reason for the duplicate entries might be because of the
inhertance . The system reads the attributes for the entire hierarchy.
For example if there is an attibute PRCAT , it is read for the entire hierarchy under which the user falls and this happens for all the attributes.
We cannot avoid this reading of attributes .
The only way is to "delete the duplicate entries" which is suggested before or maintaining "Minimum inhertance level" .
Best regards,
Ivy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.