Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
Does anyone know how to find out what custom number sequences have been created in Windchill? I have an oracle database and want to see the sequences as well as what they look like (Starting number and increment). Any thoughts would be appreciated.
Brian
Brian,
The WC OOTB sequences are documented in the Windchill Help Center under "Out-of-the-Box Schemes". By default they start at "1" with leading zero padding. I've attached a screen shot.
Russ
Russ,
Thanks for the info. What I really am looking for is how to find out
about any custom sequences that have been created. I found some code I think
will work but I haven’t tested it yet.
select substr(sequence_owner,1,10) "OWNER",
substr(sequence_name,1,25) "SEQ NAME",
substr(to_char(min_value),1,3) "MIN",
max_value "MAX",
increment_by "INC",
cache_size "CACHE",
last_number "LAST NUM"
from all_sequences
order by 1 asc, 2 asc;
Brian
I believe that you can find your custom series by searching for wt.series.* properties in <Windchill_Home>\codebase\wt.properties
Thanks for all the updates. I really appreciate it