Search Results jtf_grid_sort_cols_u1

Overview

JTF.JTF_GRID_SORT_COLS is a seed data table in the Oracle E-Business Suite JTF (Java Technology Foundation) schema that stores the default sort configuration for grid and spreadtable user interface components. Each row defines, for a named grid data source, the ordered set of columns on which the grid's data will be sorted by default when rendered. The table resides in the APPS_TS_SEED tablespace, which is characteristic of reference and metadata seed tables that are populated at installation and updated only through standard Oracle Applications programs or patches.

The object carries a heuristic Data Vault classification of link, mined from its foreign key structure. This suggests modeling the table as a connection between grid data source metadata and the individual grid column definitions, rather than as a pure descriptive satellite. The classification is a modeling suggestion only; the table functions natively as a configuration store within the JTF grid framework.

Oracle flags this object as Internal Use Only: supported access is through standard Oracle Applications programs, not direct SQL against application data.

Key Information Stored

The table is narrow, with eleven documented columns, and its semantics center on one business key plus three sort-order attributes.

• GRID_DATASOURCE_NAME (VARCHAR2(30), mandatory) — the unique name identifying a set of metadata, i.e., the grid data source whose default sort behavior is being defined. This is the single-column primary key (JTF_GRID_SORT_COLS_PK) and the leading column of the unique index JTF_GRID_SORT_COLS_U1.
• GRID_SORT_COL_ALIAS1 (VARCHAR2(30)) — the first column on which the spreadtable UI component's data is sorted by default.
• GRID_SORT_COL_ALIAS2 (VARCHAR2(30)) — the second default sort column.
• GRID_SORT_COL_ALIAS3 (VARCHAR2(30)) — the third default sort column.
• ZD_EDITION_NAME (VARCHAR2(30)) — the editioning discriminator used by the Online Patching / edition-based redefinition framework. It is the second column of JTF_GRID_SORT_COLS_U1, making the documented business-key candidate the composite (GRID_DATASOURCE_NAME, ZD_EDITION_NAME). This reflects the 12.2.x editioning model rather than the 12.1.1 schema.
• SECURITY_GROUP_ID (NUMBER) — security group identifier, used when hosting with VPD (Virtual Private Database) enabled.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, populated automatically by the framework for audit and concurrency purposes.

The surrogate primary key is therefore the data source name itself (or its edition-qualified composite in 12.2.x), while the unique index JTF_GRID_SORT_COLS_U1 documents the business-key candidate. Three nonunique indexes (JTF_GRID_SORT_COLS_N1 through N3) support lookup by GRID_SORT_COL_ALIAS1, ALIAS2, and ALIAS3 respectively, enabling reverse queries such as identifying which grids sort on a given column.

Common Use Cases and Queries

Typical usage is diagnostic and reporting-oriented: administrators and support engineers inspect which columns a given grid sorts by default, confirm that a patch delivered the expected seed row, or audit the set of grids that reference a particular column alias.

• Retrieve the default sort configuration for a named data source:
  SELECT grid_sort_col_alias1, grid_sort_col_alias2, grid_sort_col_alias3 FROM jtf.jtf_grid_sort_cols WHERE grid_datasource_name = :p_name;
• Identify all data sources whose primary sort column matches a given alias, using the N1 index:
  SELECT grid_datasource_name FROM jtf.jtf_grid_sort_cols WHERE grid_sort_col_alias1 = :p_alias;
• Audit who last changed a configuration row, joining the WHO columns back to FND_USER via LAST_UPDATED_BY.
• Compare sort metadata across editions in 12.2.x by filtering on ZD_EDITION_NAME.

Because the object is Internal Use Only, such queries should be restricted to read-only diagnostics and should not be used to drive application behavior.

Related Objects

Foreign key relationships establish the table's position within the JTF grid metadata model.

• JTF.JTF_GRID_DATASOURCES_B — the parent grid data source definition, joined on GRID_DATASOURCE_NAME. This is the principal dependency and the hub side of the heuristic link classification.
• JTF.JTF_GRID_COLS_B — the grid column definitions table, referenced multiple times from GRID_DATASOURCE_NAME. It supplies the column metadata that the alias columns in this table resolve against.
• FND.FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, supporting VPD-based security group filtering.
• FND.FND_USER — implicit referent of CREATED_BY and LAST_UPDATED_BY for audit joins.
• FND.FND_LOGINS — implicit referent of LAST_UPDATE_LOGIN.

Together these relationships confirm that JTF_GRID_SORT_COLS is a configuration link table that binds grid data sources to their default sort columns while participating in the standard EBS security and audit framework.