My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

Purpose

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,

 

Note:

  • 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.

 

 

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
Purpose
Troubleshooting Steps
 Purpose:
 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:
References

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