23Understanding Dynamic JDB Table Cache Refresh

Understanding Dynamic JDB Table Cache Refresh

The JDB (JD Edwards Database) Cache feature improves performance by caching specific tables in the Call Object Kernel, Subsystem UBEs and UBEs. With tables cached in JDB, any update or delete of a record in a cached table requires a clear of the cache on all kernels across all enterprise servers for the data to be available to all users.

Dynamic cache refresh allows a specific JDB table cache registered in the F98613 table to be cleared across kernel processes and across all enterprise servers as long as they are managed by the same server manager. All enterprise servers no longer need to be bounced in order to clear cache. Because there is no table caching in JAS, there isn't any need to clear cache in the JAS servers.

For example (for a single table), at the end of an accounting period a person in the finance department needs to update the current period in the Company Constants application. The current period value is important for all financial processes within EnterpriseOne and must be accurate to ensure proper processing. Application P0010 updates the Company Constants (F0010) table, which is a table that is normally cached. Currently within EnterpriseOne, a system administrator must log off all current users and restart the enterprise server in order for all users to have the most current data available for their applications. Each user must sign off the system while it is being reset, then sign back in when it is completed. This causes a disruption of normal business operations. A user may have hundreds of companies that need to have their current period changed on a monthly basis, causing even more disruption.

There are two methods available for a user to dynamically refresh cache for a specific table:

  1. Reset database table cache for a specific table using P986116D.

  2. Reset database table cache using a pre-configured application.

Resetting Database Table Cache

Dynamic cache refresh enables you to dynamically refresh cache for a specific table. This method uses application P986116D|W986116DA to reset database table cache for a specific table.

To reset a specific database table cache:

  1. In EnterpriseOne, either Fast Path to P986116D|W986116DA, or select Navigator from the toolbar, and then select EnterpriseOne Menus | EnterpriseOne Life Cycle Tools | Application Development | Reset Database Table Cache to launch the 986116D|W986116DA application.

  2. Enter the name of the table in the Table Name field, and then click the Reset Cache button.

    You can also click the Visual Assist on the Table Name field, then search and select the table, and then click the Reset Cache button. This table should be cached in F98613. Otherwise, you will get an error message. Also, if the clear cache fails, you will get an error message.

The P98613 - Work with Database Caching application lists the tables that are registered for database caching. An administrator can add a new table to the P98613 application to make it available for caching. If a new table is added, the EnterpriseOne server will need to be restarted.

To register a table for table cache:

  1. Fast Path to P98613.

  2. Click Add.

  3. Enter the table information to register the table.

  4. Click Save, then exit the application.

Note: If a new table is added, the EnterpriseOne server will need to be restarted.

Resetting Database Table Cache Using a Pre-Configured Application

Cache can be cleared for a specific table using an application that has been pre-configured with the JDB_ClearTableCache Tools API. These pre-configured applications and tables work in conjunction with:

  • The TBLREFR - Table Cache Auto Refresh configuration control setting in the P99410 Work With EnterpriseOne System application.

  • Tables that have been registered using the P98613 - Work with Database Caching application.

  • Applications that have been configured in the 00/RF UDC.

The pre-configured application will check the Table Cache Auto Refresh environment constant value. In order to automatically clear the cache, the F99410 system constant value must be set to on (set to Yes), the table has been registered using P98613 and the application is enabled in the 00/RF UDC.

The following procedures will need to be performed by the system administrator.

To set the system configuration setting:

  1. Fast Path to P99410.

  2. Enter TBLREFR into the Data Item QBE field and click the Visual Assist.

  3. Select the TBLREFR - Table Cache Auto Refresh record for TBLREFR and set to Yes to enable or No to disable this functionality. This will activate or deactivate the clear cache feature at the system level for all pre-configured applications.

Figure 1. Table Cache Auto Refresh System Constant Activation (P99410)
This image is described in the surrounding text.

Enable/Disable Clear Cache Applications Using UDC

The system configuration setting turns on database table caching availability at the system level. Each pre-configured clear cache application then needs to be enabled/disabled using the 00/RF UDC.

The 00/RF UDC will govern:

  1. If the application will clear cache.

  2. Whether or not to display an informational message.

To setup 00/RF UDC:

  1. Fast Path to UDC.

  2. Enter 00 for Product Code.

  3. Enter RF for User Defined Codes.

  4. Click Find.

  5. Select the application to enable/disable.

  6. To enable the feature, set the first digit of the Special Handling field for an application to a value of "1". To disable the feature, set the first digit of the Special Handling field to a value of "0".

  7. To enable/disable the informational message, the second digit of the Special Handling field will be used. A value of "1" will enable and a value of "0" will disable the display of the informational message.

    The informational message is only available on the applications that allow the user to update multiple applications. An example of an application where the informational message will be displayed is Work with Business Units (P0006) as you can update multiple business units with this application. An example of an application where the informational message will not be displayed is Advanced Cost Accounting Constants as you can only update one record.

Figure 1. Work With User Defined Codes
This image is described in the surrounding text.

Clear Cache Informational Message

A clear cache informational message is available to remind users that changes to the data may not be available to users until the application is closed.

Description

Close Application to Update Data.

Cause

Changes to the data may not be available to users until the application is closed.

Resolution

Close the application in order for the system to update the modified data and make it available to all users.

Figure 1. Clear Cache Informational Message
This image is described in the surrounding text.

Pre-configured Applications

The EnterpriseOne pre-configured applications are listed in the following table:

App

App Description

Cached Table

Table Description

P0000

System Setup

F0010

Company Constants

P0001

Co/BU Tree Structure

F0006

Cost Center Master

P0006

Business Units

F0006

Cost Center Master

P00071

Workday Calendar

F0007

Work Day Calendar

P0008

Fiscal Date Patterns

F0008

Date Fiscal Patterns

P0010

Companies

F0010

Company Constants

P001001

Alternate Tax Rate/Area Assign

F0006

Cost Center Master

P001001

Alternate Tax Rate/Area Assign

F0010

Company Constants

P001012

Fixed Asset Constants

F0010

Company Constants

P001012

Fixed Asset Constants

F1200

Fixed Asset Constants

P0013

Currency Codes

F0013

Currency Codes

P0014

Payment Terms

F0014

Payment Terms

P0014

Payment Terms

F00141

Advanced Payment Terms

P00145

Advanced Payment Terms

F0014

Payment Terms

P00145

Advanced Payment Terms

F00141

Advanced Payment Terms

P00218

Invoice Voucher Co Tax Const

F0010T

Company Constants Tag Table

P0022

Tax Rules

F0022

Tax Rules

P0025

Ledger Type Master Setup

F0025

Ledger Type Master File

P0026

Job Cost Constants

F0026

Company Constants - Job Cost

P059051A

Business Unit Constants

F0006

Cost Center Master

P059116

Pay Type,Ded, Benef, Accrual

F069116

Payroll Transaction Constants

P059117

Advanced DBA Information

F069116

Payroll Transaction Constants

P059118

Basis of Calculation

F069116

Payroll Transaction Constants

P07RSW

Rollover Setup Window

F069116

Payroll Transaction Constants

P1609

Advanced Cost Acct Const

F1609

Cost Management Constants

P17001

S&WM System Constants

F17001

Service/Warranty Constants

P1724

Contract Coverage

F1724

Service Contract Coverage

P17506

Work With Provider Groups

F1752

Case Types

P17506

Work With Provider Groups

F1753

Case Priority

P1790

Product Family/Model

F1790

Product Family/Model Master

P3009

Manufacturing Constants F3009

F3009

Job Shop Manufact Constants

P3009

Manufacturing Constants F3009T

F3009T

Manufacturing Constants Tag File

P400951

Default Location & Printers

F40095

Default Locations/Printers

P40204

Order Activity Rules

F40203

Order Activity Rules

P40205

Line Type Constants

F40205

Line Type Control Constants

P4071

Price Adjustment Type

F4071

Price Adjustment Type

P41001

Branch/Plant Constants

F4009

Distrib/Manufact Constants

P41001

Branch/Plant Constants

F41001

Inventory Constants

P41002

Unit Meas Convers - Item

F41002

Item Unit Meas Convers Factor

P42460

Sales Order Constants

F90CA000

CRM Constants Table

P48091

Service Billing Constants

F48091

Billing System Constants

P49002

Transportation Constants

F49002

Transportation Constants

P49003

Load Types

F49003

Load Type Constants

P49004

Mode of Transport Constants

F49004

Mode of Transport Constants

P4950

Routing Entries

F4950

Routing Entries

P4950

Routing Entries

F4953

Routing Hierarchy

P4970

Work With Rating Info

F4973

Rate Structure Definition

P4970

Work With Rating Info

F4978

Charge Code Definitions

P4972

Work With Rate Detail Info

F4973

Rate Structure Definition

P4978

Work With Charge Codes

F4978

Charge Code Definitions

P51006

Job Cost Master

F0006

Cost Center Master

P7306

Quantum Sales Use Tax Const

F7306

Quantum Sales Use Tax Const

P90CA000

CRM Constants

F90CA000

CRM Constants Table

R4950

Batch Routing Rate Update

F4950

Routing Entries