Resetting Database Table Cache

Dynamic cache refresh enables you to dynamically refresh cache for a specific table. This method uses application P986116D|W986116DA to reset database table cache for a specific table.

To reset a specific database table cache:

  1. In EnterpriseOne, either Fast Path to P986116D|W986116DA, or select Navigator from the toolbar, and then select EnterpriseOne Menus | EnterpriseOne Life Cycle Tools | Application Development | Reset Database Table Cache to launch the 986116D|W986116DA application.

  2. Enter the name of the table in the Table Name field, and then click the Reset Cache button.

    You can also click the Visual Assist on the Table Name field, then search and select the table, and then click the Reset Cache button. This table should be cached in F98613. Otherwise, you will get an error message. Also, if the clear cache fails, you will get an error message.

The P98613 - Work with Database Caching application lists the tables that are registered for database caching. An administrator can add a new table to the P98613 application to make it available for caching. If a new table is added, the EnterpriseOne server will need to be restarted.

To register a table for table cache:

  1. Fast Path to P98613.

  2. Click Add.

  3. Enter the table information to register the table.

  4. Click Save, then exit the application.

Note: If a new table is added, the EnterpriseOne server will need to be restarted.