Skip to content

JTF Grid Datasources

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

JTF Grid Datasources

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
JTF Grid Datasources.sql
JTF Grid Datasources.sql
 
 
README.md
README.md
 
 

README.md

layout default
title JTF Grid Datasources | Oracle EBS SQL Report
description JTF grid (CRM spreadtable) datasource and column definition – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, JTF, Grid, Datasources, jtf_grid_datasources_vl, jtf_grid_cols_vl
permalink /JTF%20Grid%20Datasources/

JTF Grid Datasources – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

JTF grid (CRM spreadtable) datasource and column definition

Report Parameters

Datasource Name

Oracle EBS Tables Used

jtf_grid_datasources_vl, jtf_grid_cols_vl

Report Categories

Enginatics

Related Reports

Blitz Report Security, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), AR Aging, GL Account Distribution Analysis

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output JTF Grid Datasources 23-May-2018 140447.xlsx
Blitz Report™ XML Import JTF_Grid_Datasources.xml
Full SQL on Enginatics www.enginatics.com/reports/jtf-grid-datasources/

JTF Grid Datasources - Case Study & Technical Analysis

Executive Summary

The JTF Grid Datasources report is a technical configuration report for the Oracle CRM Foundation (JTF) framework. It documents the setup of "JTF Grids" (also known as Spreadtables), which are the dynamic, spreadsheet-like tables used in many Oracle CRM web applications (like Sales Online, Service Online).

Business Challenge

Customizing or debugging Oracle CRM web pages requires understanding the underlying data structures.

  • UI Customization: "We want to add a new column to the 'My Opportunities' table. Which datasource controls that grid?"
  • Performance Tuning: "The 'Service Request' list is loading slowly. What SQL query is behind it?"
  • Hidden Columns: "Is there a 'Profit Margin' column available in the grid that is just hidden by default?"

Solution

The JTF Grid Datasources report lists the definition of these grids. It exposes the SQL query, column definitions, and data types.

Key Features:

  • Datasource Definition: Shows the underlying SQL or View used by the grid.
  • Column Metadata: Lists every available column, its data type, and whether it is sortable or filterable.
  • Customization Visibility: Shows if the grid has been customized by the user or administrator.

Technical Architecture

The report queries the JTF Grid metadata tables.

Key Tables and Views

  • JTF_GRID_DATASOURCES_VL: The header definition of the grid datasource.
  • JTF_GRID_COLS_VL: The definition of columns within the grid.

Core Logic

  1. Retrieval: Selects the datasource definition based on the name.
  2. Detailing: Joins to the column table to list all fields.
  3. Analysis: Can be used to compare the standard seeded definition against any custom overrides.

Business Impact

  • Development Efficiency: Accelerates the customization of CRM UIs by providing a map of the backend data.
  • Troubleshooting: Helps identify why data is not appearing correctly in the web interface.
  • Upgrade Analysis: Helps identify customizations that might be overwritten during an upgrade.

Useful Links

© 2026 Enginatics