Installing the patch 12360960:CSTQICCG: ITEM COST HISTORY HELP RECORD HISTORY WITH INVALID YEAR LIKE
Hi,
I need to install the patch 12360960 but the documentation is not clear if I should create the index before or after installation.
Readme
======
AD MiniPack "E" plus patch 2177442 (or AD MiniPack "F" or higher)
Patches 5883053, 4639028, 4750921 should be applied before applying this
patch.
Index on table INV.MTL_MATERIAL_TRANSACTIONS with columns
( INVENTORY_ITEM_ID,
TRANSFER_ORGANIZATION_ID,
TRANSACTION_DATE )
should be created and statistics should be gathered for the same.
Following can be used to create the index :
CREATE INDEX INV.MTL_MMT_6073689 ON INV.MTL_MATERIAL_TRANSACTIONS
( INVENTORY_ITEM_ID,
TRANSFER_ORGANIZATION_ID,
TRANSACTION_DATE )
I understand that the prerequisites are: