Skip to main content
B
BenLoosli23-Emerald III
23-Emerald III
February 26, 2015
Solved

Workflow Auto Generated Document number

  • February 26, 2015
  • 1 reply
  • 2420 views

In the OOTB Change Request workflow, we have the number field set to Auto generate.

In the OIR for Change Request, we have the following lines for the number field.

<AttrValue id = "number"

algorithm="com.ptc.windchill.enterprise.revisionControlled.server.impl.NumberGenerator"

ignore="false" force="false" final="false"

<Arg>CR-</Arg>

<Arg>{GEN:wt.enterprise.SequenceGenerator:WTCHANGEREQUESTID_seq:5:0}</Arg>

</AttrValue>

When we create new Change Requests, we get a random higher than-the-last number for the change request and what we are looking for is a controlled sequential numbering scheme.

Last week, I created 3 CRs, CR-00021, CR-00023 and CR-00041. This week, the next one created was CR-00061.

What do I need to change in the OIR to get the system to give me a steady sequential numbering scheme? If Windchill cannot do it automatically, we may have to fall back to a manually entered numbering scheme from an external database which we are trying to replace with Windchill Change Management. We do not want to maintain 2 systems for tracking changes.

Best answer by BenPerry

Try this on the DB (log into SQLPlus):

ALTER SEQUENCE WTCHANGEREQUESTID_seq NOCACHE;

Are you able to confirm on a test system first?

1 reply

BenPerry
BenPerry15-MoonstoneAnswer
15-Moonstone
February 26, 2015

Try this on the DB (log into SQLPlus):

ALTER SEQUENCE WTCHANGEREQUESTID_seq NOCACHE;

Are you able to confirm on a test system first?

B
BenLoosli23-Emerald IIIAuthor
23-Emerald III
February 26, 2015

I will try that on my test system.

I would guess that other numbers could also be changed to be sequential by doing the same nocache alteration.

B
BenLoosli23-Emerald IIIAuthor
23-Emerald III
February 26, 2015

How do I alter the initial starting number to 3000?

It is currently at 63 and when I tried to edit it in the Oracle Console, it said start number cannot exceed current number. Current number could not be editted in the console.

Terms & ConditionsAccessibility statement