Clicking on 'New' button for creating a Funding Entity takes more than 5 seconds to load the new form


Description

Clicking on 'New' button for creating a Funding Entity takes more than 5 seconds to load the new form. This is due to the script InvstFundingEntityTables trying to skip the [invst_investment] table from the list of tables to be shown on the 'Table' [entity_table] filed on the [invst_funding_entity] table, and is taking time to loop through all the tables in system.


Steps to Reproduce

1. Click on the link in the left navigator for loading the Funding Entities list. 
2. Click on the 'New' button to create a new Funding Entity record.

Observe the page takes more than 5 sec just to load the form for creating the funding entity.

Workaround

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases. We do not make this decision lightly, and we apologise for any inconvenience.

The new form is a one-time setup screen where users will create a limited number of funding entities (15-20) at the beginning of an implementation.

If a workaround is necessary, remove the dictionary attribute 'tableChoicesScript=InvstFundingEntityTables' from the 'Table' [entity_table] filed on the [invst_funding_entity] table.



Related Problem: PRB1373680