E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne
(Doc ID 944015.1)
Last updated on FEBRUARY 13, 2023
Applies to:
JD Edwards EnterpriseOne Accounts Receivable - Version 9.0 to 9.0 [Release 9.0]JD Edwards EnterpriseOne Address Book - Version 9.0 to 9.0 [Release 9.0]
JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
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 the cache is written to Memory (RAM) it yields better performance (avoiding round trips to the database) and it is Shared Cache (read-only cache) coherency problems are easily avoided (so this may cause Dirty/Phantom Reads) for data that are requested frequently/repeatedly.
This document will briefly explain frequently asked questions from an end-users point of view. This document explains server (as a 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) ? |
| Q32. Information on Rest Processing Option ( P986116|W986116E). |
| References |