My Oracle Support Banner

E1: ENV: Dynamic Cache - Resetting Database Table Cache Using a Pre-Configured Application (Doc ID 1617534.1)

Last updated on JUNE 07, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.


This document is to explain enhancements made for Resetting Database Table Cache Using a Pre-Configured Application which is available as of EnterpriseOne Application Release 9.1 Update 2 and above.  If your application meets this update, you can reset database cache per table depending on your business requirement.

This document covers:

Dynamic Cache feature is to work only when,




  • To enable TBLREFR through P99410
    • Add a new DD alias TBLREFR (TableCacheAutoRefresh)
    • Then go to P99410 and click Add
  • Currently the table F99410 is sitting in System Data Source which impact all environment. So in case you need to test it in testing environment first, create F99410 in different data source and map it accordingly.
  • Development used a code in which clearTableCacheByEnvironmentMessage" function opens SMC URL and  performs login and clear cache. So system needs to perform Signon to SM Console to use the clearTableCacheByEnvironmentMessage API. So SM Console needs to be up and running for this to work.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 List of Pre-Configured applications:
 Example of implementation (Case of P400951 (Default Location & Printers))
 Business Function - Example of B4098610
 List of Database Cache for comparison
 Question and Answers:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.