Search Results jtf_grid_datasources_b_u1

Overview

JTF.JTF_GRID_DATASOURCES_B is a seed data table in the Oracle E-Business Suite (12.1.1 and 12.2.2) that defines the metadata backing configurable grid (spreadtable) user interface components within the JTF framework. Each row identifies a named data source — a logical set of grid metadata — and binds it to an underlying database view that supplies the queryable content. Oracle's own documentation flags this object as internal use only and does not support direct customer access except through standard Oracle Applications programs, so any integration or reporting against it should respect that constraint and treat the table as read-mostly.

The table is stamped with FND Design Data and resides in the APPS_TS_SEED tablespace, which confirms its role as definition/seed metadata rather than transactional data. From a Data Vault modeling perspective, the mined relationship structure classifies this object as hub-leaning: GRID_DATASOURCE_NAME functions as the natural business key, and the table's foreign keys to FND_APPLICATION and FND_SECURITY_GROUPS indicate it sits downstream of reference hubs rather than acting as a pure transaction link.

Key Information Stored

The most operationally significant columns are:

• GRID_DATASOURCE_NAME (VARCHAR2 30) — the unique name identifying the set of grid metadata; this is the primary key column supporting JTF_GRID_DATASOURCES_B_PK and the unique index JTF_GRID_DATASOURCES_B_U1.
• DB_VIEW_NAME (VARCHAR2 30) — the database view from which grid rows are retrieved.
• APPLICATION_ID — foreign key to FND_APPLICATION, indicating the owning application.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling row-level access.
• DEFAULT_ROW_HEIGHT — the number of lines rendered per grid row by default.
• MAX_QUERIED_ROWS — the ceiling on rows returned by the grid query.
• WHERE_CLAUSE (VARCHAR2 2000) — an optional filter appended to the generated query; the keyword "WHERE" must not be included, as it is prepended automatically.
• ALT_COLOR_CODE and ALT_COLOR_INTERVAL — the alternating row shading color and interval used in the spreadtable UI.
• FETCH_SIZE — the batch size for row retrieval.
• ZD_EDITION_NAME — the editioning column used by EBS 12.2 online patching.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Note that in the 12.2.2 physical schema the unique index JTF_GRID_DATASOURCES_B_U1 spans GRID_DATASOURCE_NAME plus ZD_EDITION_NAME, reflecting edition-aware uniqueness, while the documented index in the excerpted detail lists GRID_DATASOURCE_NAME alone.

Common Use Cases and Queries

Typical scenarios include enumerating all registered grid data sources for an application, auditing which database views are exposed through the grid layer, and troubleshooting grid display behavior (row height, alternating colors, fetch size, and query limits). A representative query:

• SELECT g.GRID_DATASOURCE_NAME, g.DB_VIEW_NAME, a.APPLICATION_SHORT_NAME, g.WHERE_CLAUSE, g.MAX_QUERIED_ROWS FROM JTF.JTF_GRID_DATASOURCES_B g, FND_APPLICATION a WHERE g.APPLICATION_ID = a.APPLICATION_ID;
• To find the columns configured for a data source: join to JTF_GRID_COLS_B on GRID_DATASOURCE_NAME.
• To identify custom grids overriding defaults: join to JTF_CUSTOM_GRIDS or JTF_DEF_CUSTOM_GRIDS on GRID_DATASOURCE_NAME.

Because the table is seed metadata, reporting should be restricted to read access, and any modification must go through supported Oracle setup or concurrent programs.

Related Objects

The most significant dependents and references, based on documented foreign keys, include:

• FND_APPLICATION — referenced via APPLICATION_ID; identifies the owning application.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs data security grouping.
• JTF_GRID_COLS_B — child table holding column definitions, joined on GRID_DATASOURCE_NAME.
• JTF_GRID_SORT_COLS — child table defining default sort columns for the grid.
• JTF_GRID_DATASOURCES_TL — translation table keyed on GRID_DATASOURCE_NAME.
• JTF_CUSTOM_GRIDS and JTF_DEF_CUSTOM_GRIDS — define customer-specific and default customized grids.
• IEU_UWQ_NODE_DS — links interaction/universal work queue nodes to a data source via DATASOURCE_NAME.