Scenario : I had many old record in the mtl_material_transactions_temp
I checked with Inventory team that there is no need for this transaction
to Pushed to mtl_material_transaction as
Inventory and Adjustment done. Can records from be deleted ?
RESOLUTION FOR THIS:
Step 1: Backup
CREATE TABLE BACKUP. MMTT_2009 AS
SELECT * FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_SOURCE_TYPE_ID = **
AND ACCT_PERIOD_ID = ****
Step 2: Clear old records
DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE TRANSACTION_SOURCE_TYPE_ID = **
AND ACCT_PERIOD_ID = ****
birkin bag
ReplyDeletecheap jordans
yeezy supply
golden goose francy
supreme clothing