Skip to main content
B
bwilson-21-Visitor
1-Visitor
May 14, 2015
Question

Custom Number Sequences

  • May 14, 2015
  • 3 replies
  • 1772 views

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

3 replies

R
RussPratt8-Gravel
8-Gravel
May 15, 2015

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
Out of the Box Schemes.png

    B
    bwilson-21-VisitorAuthor
    1-Visitor
    May 15, 2015

    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

      M
      mmuth1-Visitor
      1-Visitor
      May 15, 2015

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

      B
      bwilson-21-VisitorAuthor
      1-Visitor
      May 20, 2015

      Thanks for all the updates. I really appreciate it

      Terms & ConditionsAccessibility statement