There is new utility in HFM 11.1.2.3.500 – PSE 18921957–  It checks the corresponding HFM database and reports the index issues and its corresponding actions to be taken!

In a recent patch set update, Oracle provides a new utility that will analyze HFM Indexes.

This is for release 11.1.2.3.500 via Patch Set Exception (PSE): 18921957.  However, you can use this utility on any 11.1.2.x version. The patch:

  • Examines the indexes on the database tables and compare them against the required indexes to see if any changes should be made
  • Can be used to repair an issue that may have been caused by certain versions of the HFM Copy Application utility

Link to the patch: https://updates.oracle.com/Orion/Services/download?type=readme&aru=18120702

“The index update utility operates in three modes.  The first is to examine the existing database table indexes on an HFM application and generate a report outline any potential problems that may exist.  The second option will generate a report and a file of SQL commands to drop and recreate any possibly missing or incorrect indexes. The third form generates a report and instantly executes the commands to drop/recreate indexes.”

Blog by Prakash Chandran of Key Performance Ideas

Recent Posts

Successful Reconciliation Compliance with Oracle Cloud

Would you like to learn how Key Performance Ideas can help you utilize Oracle’s Account Reconciliation Compliance Module that saves time, rework, and improves accuracy?  How about seeing the same time savings and accuracy every month?  Would you like to have real-time...

read more
Schedule Time With Us