Transact Move Orders Form Creates Duplicate Rows In MMTT (Doc ID 437054.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Inventory Management - Version 11.5.9 to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.

Symptoms

Problem

Find duplicate records can be created in the MTL_MATERIAL_TRANSACTIONS_TEMP (MMTT) table

Steps

The issue can be reproduced at will with the following steps:
1st case using Lot Numbers:

1. Create Move Order with type “Move Order Transfer”
2. Create one entry for Move order Line. Use the item with Lot control. Enter quantity which is less than the overall available quantity on this location. (I entered 2 meanwhile the available quantity is 100).
3. Approve Move Order
4. Form Transact Move Orders: check the line and press Allocate.
5. Check ‘Select’
6. Press View/Update Allocations
7. Press Lot/Serial. There is a record for lot with quantity 2.
8. Press Done.
9. Press Transact in new window
10. The concurrent request is submitted . But the line doesn’t leave the block in form.
11. Not check ‘Select’
12. Press View/Update Allocations
13. Press Lot/Serial – there is a record for Lot with quantity 2.
14. Press Done
15. Press transact
16. The concurrent request is submitted .But the line doesn’t leave the block in form.
17. Not check ‘Select’
18. Press View/Update Allocations
19. Press Lot/Serial – there is no records. Enter the record for Lot with quantity 2.
20. Press Done
21. Press transact
22. The concurrent request is submitted.
23. There is one record in MTL_MATERIAL_TRANSACTIONS_TEMP meanwhile all necessary records are in MTL_MATERIAL_TRANSACTIONS

The 2nd case using Serial Numbers:
1. Create Move Order with type “Move Order Transfer”
2. Create two entries for Move order Lines. Use the one item with Serial control for both lines.
3. To the first line enter quantity which is less than the overall available quantity on this location. (for example enter 6 meanwhile the available quantity is 100).
4. To the second line enter quantity which is less than the overall available quantity on this location (for example enter 2 meanwhile the available quantity is 100).
5. Approve Move Order
6. In the Transact Move Orders form check both lines and press Allocate.
7. Check ‘Select’ on the first line.
8. Press View/Update Allocations.
9. Press Lot/Serial
10. Enter in individual mode 6 serial numbers.
11. Press Done.
12. Press Transact.
13. The concurrent request is submitted .But the line doesn’t leave the block in form so there are still two lines in the form.
14. Now check ‘Select’ on the second line.
15. Press View/Update Allocations.
16. Enter in individual mode 2 serial numbers.
17. Press Done
18. Press transact
19. The concurrent request is submitted. But the line doesn’t leave the block in form.
20. Not check ‘Select’
21. Press View/Update Allocations
22. Press Lot/Serial – there are records for Serial Numbers.
23. Press Done
24. Press transact
25. The concurrent request is submitted .But the line doesn’t leave the block in form.
26. Not check ‘Select’
27. Press View/Update Allocations
28. Press Lot/Serial – there are no records for Serial Numbers. Enter in individual mode 2 records for serial_numbers.
29. Press Done
30. Press transact
31. The concurrent request is submitted.
32. There is one record in MTL_MATERIAL_TRANSACTIONS_TEMP meanwhile all necessary records are in MTL_MATERIAL_TRANSACTIONS.
Moreover the serial numbers which are associated to the MTL_MATERIAL_TRANSACTIONS_TEMP rows are no longer available (the fields GROUP_MARK_ID, LINE_MARK_ID, LOT_LINE_MARK_ID are not null).


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms