transaction no in Ar

[harikumarc1981@rediffmail]

in AR(11i) the transaction no is automatically created by the system.in transaction source we will give only last no . now the user is complaining that the transaction no is jumping. what is the reason for this.


thank in advance

[oteixeira]

Hello.

The problem is in the cache size of the sequnce.

1.First, query one the transactions which automatic number is jumping and using Help/Diagnostics/Examine, look for the value of Field DOC_SEQUENCE_ID and note it down.

2.Execute the following query to know the name of the sequence.

select db_sequence_name from fnd_document_sequences
where doc_sequence_id = <the number you got in 1)

3.Execute the following query to know the db sequence name:

select sequence_name from dba_sequences
where sequence_name = <the name you got in 2)

4.Finally, alter the sequence cache in order to avoid numbers from jumping:

SQL>alter cache <the name you got in 3> 0;

Hope this helps.
Octavio.