program that creates tr_trnbr in case of so shipment.

[shafee212]

I am facing a problem . While shipment , when th eprogram terminates without completion , i mean if user just presses ctrl+ brk during so shipment , then the transaction gets roll back , but the tr_trnbr gets incremnted . can any one tell me which programs generates the transaction no . Can any one give me a solution on this .
mfivtr.i creates tr_hist record.
it calls ictrans.i

but form where tr_trnbr is getting assigned . ???

 

[Kishor Chari]

Why are you worried about loosing a transaction nbr? It is done using single line "sequence" statement, if you understand sequences you cannot re trace. Note if you try to tamper it, you can corrupt the table easily ( I did it !!! )

 

[sphipp]

I am facing a problem . While shipment , when th eprogram terminates without completion , i mean if user just presses ctrl+ brk during so shipment , then the transaction gets roll back , but the tr_trnbr gets incremnted . can any one tell me which programs generates the transaction no . Can any one give me a solution on this .
mfivtr.i creates tr_hist record.
it calls ictrans.i

but form where tr_trnbr is getting assigned . ???

The reason you can't roll back is this:

If you have 2 processes A and B that both create transactions, 
then you could have:
1. Process A creates a transaction and sets tr_trnbr = 100
2. Process B creates a transaction and sets tr_trnbr = 101
3. Process A is backed out
4. Process B completes successfully
 
How do you back out the transaction sequence? You can't go back to 100 because 
101 has been used. So, the best thing is to let the sequence continue and 
accept that you sometimes get numbers that do not have a corresponding 
transaction.

 

[shafee212]

but as per standard , it should not happen , i mean to say that if my whole shipment transaction gets roll backed , then y tr_number is not getting roll backed....