on 05-15-2015 7:25 PM
Hi Everyone,
I am creating an inspection lot through QA01 and using flex specs. If I create 30 samples, let's say, and save, it will create 30 physical samples. The problem I am seeing is that sometimes the sample numbers jump around numbers, so I will get 110000936 for the first sample and then 110000950 for the second sample. Does anyone know why the numbers are not in sequential order and/or how to fix this issue?
Thanks,
Hi Joseh,
Actually this is not an error but caused by number range buffering.
Check 62077 which explains the system logic in details.
BR,
Natália
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Joseph,
I really don't know how to estimate the performance loss, but if you deactivate number range buffering, a number is assigned in each case and the table remains locked until the next COMMIT or ROLLBACK. Another disvantage is that you cannot request numbers in parallel.
I don't know for what scenario you want to use this, but for example, then lets say, three users A, B and C click on create PO, then the PO will be created with the number, lets say, 2, 3 and 4 for the users respectively. Now, if user A cancels the PO creation process, then user B whose document number is already generated as 3 will have to be change to 2 and for C whose documnet number was 4 will have to be changed to 3, but then 3 is already in use and all these things can not happen simultanously and will lead to a deadlock situation.
Best regards,
Natália
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.