Search Results jtf_grid_sort_cols




Overview
Explore in AI Chat

Overview

JTF_GRID_SORT_COLS is a configuration table owned by the JTF schema within the CRM Foundation module (JTF) of Oracle E-Business Suite. Its documented purpose is to store "the default columns and priority of the columns for the current set of meta data, used for sorting the data displayed in a spreadtable UI component." In practical terms, the table defines the default sort behavior applied to a Spreadtable (a grid-style user interface element widely used in CRM and iStore pages) when a given datasource is rendered. Each row associates a grid datasource with up to three ordered sort columns, giving the page a deterministic default ordering without requiring end-user interaction.

From a data-modeling perspective, the ETRM metadata classifies this object heuristically as a link (Data Vault classification: link). This is consistent with its structure: the table does not represent a business entity in its own right, but rather records associations between a grid datasource and the column definitions that participate in sorting. It resolves the many-to-many-style relationship between datasources and grid columns, carrying the sort priority as dependent descriptive data. In Oracle EBS 12.1.1 and 12.2.2 this table remains valid and is delivered as part of the CRM Foundation schema.

Key Information Stored

The table contains 11 documented columns. The most significant are:

The surrogate primary key is JTF_GRID_SORT_COLS_PK (on GRID_DATASOURCE_NAME). The documented business-key candidate is the unique index JTF_GRID_SORT_COLS_U1 on (GRID_DATASOURCE_NAME, ZD_EDITION_NAME), reflecting the EBR requirement that editions be distinguished.

Common Use Cases and Queries

Administrators and developers query this table when diagnosing why a Spreadtable renders rows in an unexpected order, or when configuring a default sort for a customization. It is also useful for auditing which datasources have custom sort definitions versus the delivered defaults.

A representative query retrieves the sort definition for a specific datasource, joining to the column definition table to resolve aliases to actual column metadata:

SELECT s.GRID_DATASOURCE_NAME, s.GRID_SORT_COL_ALIAS1, s.GRID_SORT_COL_ALIAS2, s.GRID_SORT_COL_ALIAS3, s.LAST_UPDATED_BY, s.LAST_UPDATE_DATE
FROM JTF.JTF_GRID_SORT_COLS s
WHERE s.GRID_DATASOURCE_NAME = :p_datasource;

For inventory-style reporting, a listing of all configured datasources and their primary sort columns can be produced by ordering on the datasource name and filtering by security group. Because the table is small and configuration-oriented, queries are typically lightweight and suitable for direct reporting or extract into a configuration migration script.

Related Objects

The table is tightly coupled to the grid metadata model within the JTF schema. The documented foreign key relationships reference the following objects:

  • JTF_GRID_DATASOURCES_B — the base table of grid datasources. Joined on GRID_DATASOURCE_NAME; each sort definition must correspond to a defined datasource.
  • JTF_GRID_COLS_B — the grid column definition table. Referenced three times, once each via GRID_SORT_COL_ALIAS1, GRID_SORT_COL_ALIAS2, and GRID_SORT_COL_ALIAS3, joined together with GRID_DATASOURCE_NAME. This confirms that each sort alias must resolve to a defined column belonging to the same datasource.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, providing the security-group context for the definition.

Together these relationships establish JTF_GRID_SORT_COLS as a link table connecting datasources, columns, and security groups, enabling the Spreadtable UI component to apply consistent, metadata-driven default sorting across Oracle EBS CRM and related applications in both 12.1.1 and 12.2.2.