JTF Grid Datasources – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: CRM Foundation · all CRM Foundation reports
Overview
JTF grid (CRM spreadtable) datasource and column definition
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Datasource Name
Oracle EBS Tables Used
jtf_grid_datasources_vl, jtf_grid_cols_vl
Report Categories
Related Reports
Blitz Report Security, GL Account Analysis, AR Aging, GL Account Distribution Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), AR Transactions and Lines, AR Incomplete Transactions, AR Customers and Sites
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | JTF Grid Datasources 23-May-2018 140447.xlsx |
| Blitz Report™ XML Import | JTF_Grid_Datasources.xml |
| SQL Source | JTF Grid Datasources.sql |
| Full Report 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
- Retrieval: Selects the datasource definition based on the name.
- Detailing: Joins to the column table to list all fields.
- 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
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH