| layout | default |
|---|---|
| title | Blitz Report Column Translations | Oracle EBS SQL Report |
| description | – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Report, Column, Translations, xxen_report_columns, xxen_report_columns_tl, fnd_languages_vl |
| permalink | /Blitz%20Report%20Column%20Translations/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
None
Column Name like, Language Code, Language, Last Updated By, Last Update Date From, Show obsolete only
xxen_report_columns, xxen_report_columns_tl, fnd_languages_vl
GL Account Analysis, CST Item Standard Cost Upload, GL Account Distribution Analysis, CAC Cost vs. Planning Item Controls, AP Invoices and Lines
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.
| Resource | Link |
|---|---|
| Excel Example Output | Blitz Report Column Translations 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Column_Translations.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-column-translations/ |
Blitz Report Column Translations is a localization maintenance report. It lists the column headers for Blitz Reports and their translations for enabled languages. This report is essential for translators and administrators managing a multi-language reporting environment.
- Translation Gaps: When a developer adds a new column to a report, they often forget to provide translations for other languages used in the company.
- Consistency: Ensuring that common terms (e.g., "Invoice Date") are translated consistently across all reports.
- Review: Providing a list of terms to external translation agencies or internal business users for validation.
This report dumps the column headers and their translations.
- Audit: Filter by "Last Updated By" to see recent changes or by "Show obsolete only" to find translations for columns that no longer exist.
- Export: Can be exported to Excel, sent to a translator to fill in the blanks, and then potentially re-uploaded (using a separate upload tool).
XXEN_REPORT_COLUMNS: The master list of columns.XXEN_REPORT_COLUMNS_TL: The translation table.FND_LANGUAGES_VL: To provide human-readable language names.
The query joins the columns with their translations. It can filter based on the language code to show specific translations.
- Column Name like: Search for specific terms (e.g., "%Date%").
- Language Code: Filter for a specific language (e.g., 'F').
- Language: Filter by language name (e.g., 'French').
- Last Updated By: Audit changes made by specific users.
- Last Update Date From: See translations changed after a certain date.
- Show obsolete only: Identifies translations that are orphaned (the underlying column was deleted or renamed).
- 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
© 2026 Enginatics