negative transaction_source_id in MMT
In 12.1.3.
In MMT, transaction_source_id are negative, and costed_flag are null. So that Negative_RMA_Receipt.sql cannot work for this issue. Because this datafix script work for costed_flag in ('E','N') transactions.
If we can clear the condition of mmt.COSTED_FLAG IN ('E','N') in datafix script Negative_RMA_Receipt.sql , then run this datafix script to fix negative transaction_source_id?
The script like below:
/* This script fixes the mtl_material_transactions record having Negative value of
transaction_source_id column with correct value.
Following types of transactions are handled :
1.RMA Receipt
------------------------------------------------------------*/
set serverout ON
In MMT, transaction_source_id are negative, and costed_flag are null. So that Negative_RMA_Receipt.sql cannot work for this issue. Because this datafix script work for costed_flag in ('E','N') transactions.
If we can clear the condition of mmt.COSTED_FLAG IN ('E','N') in datafix script Negative_RMA_Receipt.sql , then run this datafix script to fix negative transaction_source_id?
The script like below:
/* This script fixes the mtl_material_transactions record having Negative value of
transaction_source_id column with correct value.
Following types of transactions are handled :
1.RMA Receipt
------------------------------------------------------------*/
set serverout ON
0