Resetting Database Table Cache Using a Pre-Configured Application
Cache can be cleared for a specific table using an application that has been pre-configured with the JDB_ClearTableCache Tools API. These pre-configured applications and tables work in conjunction with:
The TBLREFR - Table Cache Auto Refresh configuration control setting in the P99410 Work With EnterpriseOne System application.
Tables that have been registered using the P98613 - Work with Database Caching application.
Applications that have been configured in the 00/RF UDC.
The pre-configured application will check the Table Cache Auto Refresh environment constant value. In order to automatically clear the cache, the F99410 system constant value must be set to on (set to Yes), the table has been registered using P98613 and the application is enabled in the 00/RF UDC.
The following procedures will need to be performed by the system administrator.
To set the system configuration setting:
Fast Path to P99410.
Enter TBLREFR into the Data Item QBE field and click the Visual Assist.
Select the TBLREFR - Table Cache Auto Refresh record for TBLREFR and set to Yes to enable or No to disable this functionality. This will activate or deactivate the clear cache feature at the system level for all pre-configured applications.
