JDE caching

Caching is for ensuring data integrity and improving performance. Cache is written to ram. 

When user login to JDE, it's actually environment cache where tables like

 F0009 (general constant) 

 F0010 (company constant)

 F4009 (Distribution and manufacturing constant)

F0092  (Library list - user)

F00921 (user display preference)

* Exceptional - after F009 is changed,,,you need to restart the JDE service or set kernel recycling ; can't re-log in

JDB database cache is loaded when E1 is loaded and BSFN is calling the JDB APIJDB_FetchKeyed(), and F98613 is defined.

What is cached in JAS ?

- JDBJ OCM Cache

- Data dictionary

- row column cache

- JDBJ service cache

- menu cache (F989998, F989999)

- JDBJ security cache

- serialized object

What is cached in Logic /Enterprise server?

-OCM  (F986101)

-database caching (F98613)

-version list (F983051)

-data source master (F98611)

-security workbench (F00950)

How to find database cache ?  P98613 in fatclient or webclient

How to find service cache ? You can get this information from \System_JAR\com\jdedwards\database\services\serviceobj\ on your JAS server to check tables which are members of ServiceCache in OAS (c.f., ...\webclient.war\WEB-INF\lib for WAS).

* Not all tables in cache .......

* Enterprise server =  Logic server + database server

Q10. How to refresh/ reset/ flush Database Cache and Service Cache?

Refreshing/resetting/flushing cache can be vary, for example:

• Database Cache
• Log into a FAT/HTML or WebDev client
• Fast Path to WSJ (Work with Submitted Jobs)
• (Optional) if you have the enhancement bug 11734236 (Form Exit) Advanced (P986116)
• Highlight your logic Server and from ROW menu click on Reset Cache
• Select Database, then click OK. This will flush database caching

Update: EnterpriseOne Tools Release 9.1.2 and above - Two additional options are available to reset database table cache:

• Option 1 - to reset Database Cache in Enterprise Server (through Server Manager)
• Managed Homes and Managed Instances
• (Combo Box) Select View > Clear Table Cache

• Option 2-  to reset Database Cache in Enterprise Server (through HTML client)
• Reset Database Table Cache through P986116D
• GH902 (EnterpriseOne Menus > EnterpriseOne Life Cycle Tools > Application Development > Reset Table Cache (P986116D))

• Service Cache
• Use SAW (Server Administration Workbench) or Server Manager (depending on the Tools Release)
• Find the JAS instance you are working with
• In the Runtime Metrics category (SMC), click on JDBJ Database Caches
• Select JDBj Service Caches and click on Clear Cache to flush Service Cache
• Verify that Cache Size is set to zero