My Oracle Support Banner

E1: GRID: Working with Grid Formats and Using the User Overrides Application P98950 with 9.1.5 and prior (Doc ID 1082074.1)

Last updated on MARCH 10, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior to 9.1 [Release SP23 and Prior to 9.1]
Information in this document applies to any platform.
For Tools Releases 9.1.5 or prior



User Overrides allow a user to change the appearance of an application. These changes do not impact the application's functions. Grid Formats are a type of User Override. Example of User Override changes are changes to menubar/toolbar options (Fat Client), User Preferences like the width of the Left Navigation menu (Web Client), customizing Grid Formats which includes re-arranging grid columns, Sort Sequence of the Grid, Grid Color and Font, changing Grid column width, etc.

User Overrides are stored in the User Overrides Table (F98950) in the Central Object Data Source for each environment. Beginning with the EnterpriseOne 9.2 Application Release and the user defined object (UDO) enhancement, Grid Formats are no longer stored in F98950 - User Overrides table, but are now stored in the F952440 - Grid Formats Detail table. During an upgrade from a previous application release to the 9.2 Release, the R89952440 Table Conversion UBE is run to convert the existing Grid Formats from the F98950 table to the F952440 table.

For more details on the UDO enhancement and managing objects, view the Oracle Learning Library Managing User Defined Objects videos. For more details on Grid Formats with 9.2 and newer, see <Document 2240087.2> E1: GRID: Working with UDO Grid Format Overrides in 9.2 and Newer Tools Releases

This document discusses the different types of user overrides within the EnterpriseOne software and provides details on working with Grid Formats including creating grid formats, hiding and showing grid columns, freezing columns, rearranging grid columns, setting color, font and width, changing the sort sequence, sharing and deleting grid formats.


This document is intended for system level administrators that will be responsible for maintaining, creating, deleting and training on the functions of User Overrides and specifically Grid Formats in the EnterpriseOne environment. 


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
 Types of User Overrides
 Creating a Grid Format Override
 Hiding and Showing Grid Columns
 Freezing and UnFreezing Grid Columns
 Rearranging Grid Columns
 Setting Grid Color and Font
 Changing Grid Column Width
 Changing Sort Sequence of a Grid
 Sharing a Grid Format
 Promoting Grid Formats
 Deleting a Grid Format Override
 Security on Grid Formats

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