Run the Approval Hierarchy Configuration Health Check Script

Use these steps to run the script.

Prerequisites: Log in as Administrator and deselect Use regional settings from the operating system in Edit > Preferences > Formats. You should also set No. of decimals to 2.

To run the script:

  1. Go to Setup > System Setup > > Support Documentation
  2. Double-click Import SQL Statements from the List of Support Types.
  3. Under Target Group, enter 1 in Statement No.
  4. Select Omit Standard Information.
  5. Click Create Documentation.
  6. Select CheckApprovalHierarchySetup.sql and click Open.
  7. After the script finishes running, save the output text file.
  8. Evaluate each row of the output file and test the suggested recommendation to improve performance.