Duplicate Inspection lots being created
I have a problem with duplicate Inspection Lots being created in PRD system after a MB_CREATE_GOODS_MOVEMENT and a MB_POST_GOODS_MOVEMENT are called (from handheld scanner transaction).
This is only happening very rarely and we can not replicate the issue in QA system.
Anybody have any ideas on why duplicates might be created?
My own idea is:
There is a COMMIT WORK AND WAIT line in the code after the MB_POST_GOODS_MOVEMENT call.
When I debug in QA, I can see that the QALS table (Inspection lots) is only updated after the COMMIT WORK line.
Could it be a timing issue in PRD? - if I add another COMMIT WORK after the MB_CREATE_GOODS_MOVEMENT,
would this have any effect?
As the issue is not happening in DV or QA, I can't test.
Any suggestions would be appreciated!