EBS R12.2.12 / A resolution is provided but there is no patch for it
A standard procedure, used for running All Inventories Value report, is also used in an in-house extract for inventory value. This procedure, however takes a very long time one of its specific queries. Oracle has provided a resolution for it (Doc ID 3019502.1). The solution it offers, is to create an index on 3 columns. I find this index already existing but it is only on the first column. So, recreated this index in a test instance. The solution works very well in test instance.
The question is should the same thing be done in production - that is, manually recreate the index? Is this the official way of doing it? I believe there is no patch for this otherwise it would have been mentioned in the document. And once applied manually, is there a possibility that this change gets erased from any ODFs/patches applied in future?