My Oracle Support Banner

E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne (Doc ID 944015.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Address Book - Version 9.0 to 9.0 [Release 9.0]
JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Purpose

The purpose of JD Edwards' JDB Database Caching is for Data Integrity/Coherency and Performance Improvement. Since cache is written to Memory (RAM) it yields better performance (avoiding round trips to database) and it is Shared Cache (read-only cache) coherency problems are easily avoided (so this may cause Dirty/Phantom Reads) for data which are requested frequently/repeatedly.

This document will briefly explain frequently asked questions from an end-user's point of view. This document explains server (as response for a certain request) and client (issuing request) based on HTML client configuration.

For cache information and troubleshooting the different scenarios, causes and resolutions for caching issues in Server Manager, refer to <Document 866662.1> - Cache Information And Troubleshooting Caching Issues In Server Manager.

Questions and Answers

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
Questions and Answers
 Q1. What is Environment Cache and what tables belong to this cache?
 Q2. When is the JDB Database Cache Loaded?
 Q3. When is the JDB Database Cache Used?
 Q4. What kind of information is cached in JAS (Java Application Server)?
 Q5. What kind of information is cached in Logic Server (where BSFNs and UBEs run)?
 Q6. Are any other tables cached on the Server other than for object cache?
 Q7. Can a custom Service Cache and/or Database Cache be defined?
 Q8. Where to find information on Database Caching and Service Cache?
 Q9. Is there a full list of tables for Database Cache and Service Cache?
 Q10. How to refresh/ reset/ flush Database Cache and Service Cache?
 Q11. How does it make use of the caching data in programming?
 Q12. What does "cache can not be updated" mean?
 Q13. What is the impact on applications if you remove any table (Ex: F0008) from F98613 and not re-add it?
 Q14. How to determine whether a certain application is making use of cache or not?
 Q15. How to trace Cache Manager through logging?
 Q16. Can database cache be reset/flushed when multiple users are connected to a data source you want to reset?
 Q17. What kind of BSFN/API will cache tables?
 Q18. Is it possible to cache a certain range of data (not the entire table) in calling CacheTableForUBE?
 Q19. Is there a way to force subsystem process/jobs to pick up changes to UDCs that occurred since the subsystem UBE was first submitted?
 Q20. What is the memory area name in JDE?
 Q21. Which are other types of caches used? Other Industry caches.
 Q22. Will the data in table Company Constant (F0010) be cached?
 Q23. What are the common errors you may get that are caused by uncompleted Cache Refreshing which is related to data in F0010?
 Q24. How to debug when the issue appears to be caused by data in F0010?
 Q25. How does the system make use of runtime cache when submitting a UBE to the Server?
 Q26. Unable to see changes to tables F0006 and F0901 listed in P98613 after they are updated. Is there any impact to these tables if they are removed from P98613?
 Q27. What does the message "System cache is full" in the server JDE.LOG mean?
 Q28. Is there any manual steps to delete cache and reload javascript in JAS?
 Q29. What is JSP Cache and how to clear JSP Cache?
 Q30. Can both JDBj Service Cache in JAS and Database Cache in Logic Server can be flushed even when these connection has active users associated?
 Q31. In Tools Release 8.9, How can we clear single Database Table Cache (Say for F0010) ?
References

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