Skip to main content
P
PanneerSelvamM1-Visitor
1-Visitor
December 30, 2011
Solved

Need generated numbers are sequence based.

  • December 30, 2011
  • 1 reply
  • 1550 views

Hi,

I want auto genrated numbers are sequence based. Like (0000000001 to 0000000010).

Is this possible?

Also i need those same sequence number in another product. Plz help me out.

Best answer by MikeLockwood

The OIR specifies the sequence in the "number" element.

The database defines the starting number and increment. Change these directly in the database (or create a new sequence in the database and point to it with the OIR).

Note: For Oracle, the default is to cache 20 values; any remaining are lost on each restart. Best to modify all to NOCACHE.

1 reply

M
22-Sapphire I
MikeLockwood22-Sapphire IAnswer
22-Sapphire I
December 30, 2011

The OIR specifies the sequence in the "number" element.

The database defines the starting number and increment. Change these directly in the database (or create a new sequence in the database and point to it with the OIR).

Note: For Oracle, the default is to cache 20 values; any remaining are lost on each restart. Best to modify all to NOCACHE.

Terms & ConditionsAccessibility statement