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

[crosato]

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.

[ddemay]

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

[patrick.chin1]

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.

[crosato]

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...