Need generated numbers are sequence based.

[PanneerSelvamM]

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.

[MikeLockwood · Accepted solution]

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.