cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Configuration to disallow dup part numbers? Even with diff cage code?

Newbie

Configuration to disallow dup part numbers? Even with diff cage code?

Does anyone know if there is a configuration setting that can be made to disallow duplicate part numbers to be created, regardless of the cage code? So if part 123a456 has been created, it cannot be created again even with a diff cage.


I know I can setup a listener on create, but if there was a simple OOTB setting that would great.

3 REPLIES 3

Configuration to disallow dup part numbers? Even with diff cage code?

Database level unique constraint of both columns would do the trick. Keep in mind this is how system currently enforces number uniqueness.



Sent from my Verizon Wireless BlackBerry
Highlighted

RE: Configuration to disallow dup part numbers? Even with diff cage code?

this is a configuration to the database index. But you have to clean the system first. If you want the uniquenss accross the entire Windchill system, you have to remove the orgid column from the index.

RE: Configuration to disallow dup part numbers? Even with diff cage code?

Thanks guys. I was given some info, today, that it can't be locked down to every part that is created, so listener it is...