Search This Blog

Tuesday, November 23, 2010

Need to delete fhe record from the MTL_MATERIAL_TRANSACTIONS_TEMP

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 = ****

1 comment: