Page 1 of 1
transaction no in Ar
Posted: Tue Jan 20, 2009 2:06 am
by 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
Posted: Tue Jan 20, 2009 9:08 am
by 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.