Custom Number Sequences

[bwilson-2]

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

[RussPratt]

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

[bwilson-2]

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

[mmuth]

I believe that you can find your custom series by searching for wt.series.* properties in <Windchill_Home>\codebase\wt.properties

[bwilson-2]

Thanks for all the updates. I really appreciate it