Skip to main content
C
crosato1-Visitor
1-Visitor
February 6, 2012
Question

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

  • February 6, 2012
  • 3 replies
  • 1636 views

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

D
ddemay1-Visitor
1-Visitor
February 6, 2012
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
P
patrick.chin11-Visitor
1-Visitor
February 7, 2012

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.

C
crosato1-VisitorAuthor
1-Visitor
February 8, 2012

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

Terms & ConditionsCookie settingsAccessibility statement