Tables
Tables of the Blitz Report schema (XXEN by default), with APPS synonyms of the same name. Read them; change Blitz Report content only through the APIs and the XML import.
Summary
| Table | Description |
|---|---|
| xxen_discoverer_fnd_user | Staging: optional mapping of EBS user ids to user names per Discoverer End User Layer, used instead of fnd_user to resolve workbook owners when the workbooks come from another instance. |
| xxen_discoverer_pivot_fields | Staging: crosstab field placement of Discoverer worksheets, converted into template pivot fields. |
| xxen_discoverer_sheets | Staging: worksheet-level items (layout items, sort, totals, parameter defaults) parsed from the workbook exports in xxen_discoverer_workbook_xmls (eul, doc_id). |
| xxen_discoverer_workbook_xmls | Staging: one row per Discoverer workbook export (.eex) loaded for conversion into Blitz Reports. |
| xxen_discoverer_workbooks | Staging: workbook-level items (parameters, displayed items, conditions, calculations) parsed from the workbook exports in xxen_discoverer_workbook_xmls (eul, doc_id). |
| xxen_report_assignment_users | Users an include assignment is limited to; joins xxen_report_assignments (assignment_id) to fnd_user (user_id). An include assignment without rows here applies to all users at its level. |
| xxen_report_assignments | One row per assignment that makes a report available (include) or unavailable (exclude) at an EBS level, or links it as a drilldown; joins to xxen_reports by report_id. Configuration content. |
| xxen_report_categories_tl | One row per report category and language; category_id identifies the category across languages. Configuration content. |
| xxen_report_category_assigns | Assignment of reports to categories; joins xxen_reports (report_id) to xxen_report_categories_tl (category_id). A report can belong to several categories. |
| xxen_report_columns | One row per report column alias (across all reports) with a translated heading or a number format. Configuration content. |
| xxen_report_columns_tl | Translations of column headings, one row per column_id and language; joins to xxen_report_columns by column_id. |
| xxen_report_default_templates | The default template per report, for all users or for one user; joins to xxen_reports by report_id and xxen_report_templates by template_id. |
| xxen_report_dyn_col_rule_rpts | Assignment of dynamic column translation rules to reports; joins xxen_report_dynamic_col_rules (rule_id) to xxen_reports (report_id). Only rules assigned to a report run for it. |
| xxen_report_dynamic_col_rules | One row per dynamic column translation rule: a query producing column headings that depend on setup data or parameter values, such as descriptive flexfield segment prompts. Configuration content. |
| xxen_report_fonts | Internal reference data: the width of each character per font, size and formatting, used to calculate Excel column widths. |
| xxen_report_license_hash | Internal: license integrity data. Do not modify. |
| xxen_report_license_key | Internal: single row holding the installation's license and version. |
| xxen_report_license_users | Internal: one row per user who ran a report in the last 60 days, used to count active users against the license. |
| xxen_report_lov_counts | Internal: row counts of LOV queries, taken by the concurrent program Blitz Report Update LOV Filter Before Display to set filter_before_display. One row per shared LOV, custom parameter LOV or custom upload column LOV. |
| xxen_report_output | Internal: report output too large for one webservice response, held for the Excel add-in to fetch in batches; deleted after the last batch or after an hour. |
| xxen_report_param_default_vals | One row per saved parameter default of a user or a template; joins to xxen_report_parameters by parameter_id. Exactly one of user_id and template_id is set. |
| xxen_report_param_dependencies | Derived: one row per reference of a parameter's default value or LOV to another parameter (:$flex$.<name>); maintained by the import and the setup form. Joins to xxen_report_parameters twice. |
| xxen_report_parameter_anchors | The anchors declared in a report's SQL; joins to xxen_reports by report_id. Parameter SQL is injected only at registered anchors. Configuration content. |
| xxen_report_parameter_lovs | One row per shared LOV (list of values) usable by report parameters, upload columns and template conditions. Configuration content. |
| xxen_report_parameter_lovs_h | History: one row per stored version of a shared LOV's query; joins to xxen_report_parameter_lovs by lov_id and guid. |
| xxen_report_parameter_lovs_tl | Translation table of xxen_report_parameter_lovs, one row per lov_id and language. |
| xxen_report_parameters | One row per report parameter or parameter sub-row; joins to xxen_reports by report_id, names in xxen_report_parameters_tl. Several rows with the same name form one run-screen parameter: the row with a display_sequence and sub-rows without. Configuration content. |
| xxen_report_parameters_tl | Translation table of xxen_report_parameters, one row per parameter_id and language. |
| xxen_report_run_param_values | Run-time data: the parameter values and run options of a run; joins to xxen_report_runs by run_id. Rows exist only for values that were set. |
| xxen_report_runs | Run-time data: one row per report or upload run, from the run screen, a concurrent request, the Excel add-in or the API; parameter values in xxen_report_run_param_values. |
| xxen_report_sens_labels | One row per sensitivity label (Microsoft Purview information protection) that can be assigned to reports; the label's properties are in xxen_report_sens_lbl_props. Configuration. |
| xxen_report_sens_lbl_props | One row per property of a sensitivity label; joins to xxen_report_sens_labels by label_id. The properties are written into the Excel output as MSIP_Label_<label_id>_<property_name> document properties. |
| xxen_report_shared_strings | Internal: the shared strings (xl/sharedStrings.xml) of an uploaded Excel template workbook, one row per string; joins to xxen_report_templates by template_id. |
| xxen_report_templ_conditions | One row per filter condition a template applies to the report output; joins to xxen_report_templates by template_id. Applied as bound predicates on the template's wrapper select of the report SQL, for reports and upload downloads. |
| xxen_report_templ_excl_params | Parameters hidden from the run screen when a template is used; joins xxen_report_templates (template_id) to xxen_report_parameters (parameter_id). A template default of an excluded parameter is still applied. |
| xxen_report_template_columns | One row per report column a template lists; joins to xxen_report_templates by template_id. Column names are unique per template. |
| xxen_report_template_files | One row per file (zip part) of an uploaded Excel template workbook; joins to xxen_report_templates by template_id. |
| xxen_report_template_pivot | One row per field of a template's built-in pivot table; joins to xxen_report_templates by template_id. |
| xxen_report_template_sharing | One row per level a template is shared with; joins to xxen_report_templates by template_id. A template without sharing rows can be used only by its owner and template super users. |
| xxen_report_template_styles | Internal: cell styles of an uploaded template workbook applied to generated cells; joins to xxen_report_templates by template_id. |
| xxen_report_templates | One row per report template: a column selection, sort, aggregation, pivot and optional Excel workbook for a report; joins to xxen_reports by report_id. Configuration content. |
| xxen_report_zoom_param_vals | Parameter values passed when a report is launched from an assignment: from an Oracle form (Form and Function levels) or as an add-in drilldown (Report level); joins to xxen_report_assignments by assignment_id and xxen_report_parameters by parameter_id. |
| xxen_reports | One row per report or upload definition, keyed by report_id; the name and description are in xxen_reports_tl, the parameters in xxen_report_parameters and, for uploads, the columns in xxen_upload_columns. Configuration content. |
| xxen_reports_h | History: one row per stored version of a report's SQL, written when an import or a save in the setup form changes xxen_reports.sql_text; joins to xxen_reports by report_id and guid. |
| xxen_reports_tl | Translation table of xxen_reports, one row per report_id and language. |
| xxen_ssrs_xmls | Staging: SQL Server Reporting Services report definitions (.rdl files) loaded through the XML upload for conversion into Blitz Reports. |
| xxen_upload_columns | One row per column of an upload's spreadsheet, derived from the upload's main SQL; joins to xxen_reports by report_id. Configuration content. |
| xxen_upload_data | Internal: one row per uploaded spreadsheet row of an upload run (upload_row), with the cell values in columns column1 to column998; joins to xxen_report_runs by run_id. The upload view of each upload reads it. |
| xxen_upload_dependencies | Derived: one row per reference of an upload column's query to another column (:$column$) or a report parameter (:$flex$); maintained by the import and the setup form. Joins to xxen_reports by report_id. |
| xxen_upload_example | Example table written by the shipped example upload; not used by the product otherwise. |
| xxen_upload_parameters | One row per argument of an upload's PL/SQL procedure or interface table column, read from the database object; joins to xxen_reports by report_id and maps arguments to xxen_upload_columns by column_name. |
| xxen_upload_result_stage | Internal: API results an upload request hands to its result report request, one row per upload run (run_id of xxen_report_runs), because the result report runs as a separate request. |
| xxen_upload_sqls | Additional SQL statements of an upload; joins to xxen_reports by report_id. Configuration content. |
Tables
xxen_discoverer_fnd_user
Staging: optional mapping of EBS user ids to user names per Discoverer End User Layer, used instead of fnd_user to resolve workbook owners when the workbooks come from another instance.
| Column | Type | Null | Description |
|---|---|---|---|
| eul | varchar2(30) | not null | End User Layer owner. |
| user_id | number | not null | EBS user id as recorded in the End User Layer. |
| user_name | varchar2(100) | not null | EBS user name. |
| Index | Type | Columns |
|---|---|---|
| xxen_discoverer_fnd_user_u1 | unique | eul, user_id |
xxen_discoverer_pivot_fields
Staging: crosstab field placement of Discoverer worksheets, converted into template pivot fields.
| Column | Type | Null | Description |
|---|---|---|---|
| eul | varchar2(30) | not null | End User Layer owner. |
| doc_id | number | not null | Discoverer workbook document id. |
| sheet_name | varchar2(240) | not null | |
| field_type | varchar2(6) | not null | ROW, COLUMN, FILTER or VALUE. |
| item_key | varchar2(240) | not null | |
| seq_no | number | not null | Order of the field within its area. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_discoverer_pivot_flds_u1 | unique | eul, doc_id, field_type, item_key |
| xxen_discoverer_pivot_flds_u2 | unique | eul, doc_id, sheet_name, field_type, seq_no |
xxen_discoverer_sheets
Staging: worksheet-level items (layout items, sort, totals, parameter defaults) parsed from the workbook exports in xxen_discoverer_workbook_xmls (eul, doc_id).
| Column | Type | Null | Description |
|---|---|---|---|
| eul | varchar2(30) | not null | End User Layer owner. |
| doc_id | number | not null | Discoverer workbook document id. |
| doc_name | varchar2(100) | not null | |
| doc_owner | varchar2(64) | not null | |
| sheet_name | varchar2(240) | not null | |
| view_type | varchar2(8) | not null | Worksheet layout; CrossTab for a crosstab worksheet. |
| item_key | varchar2(240) | ||
| item_name | varchar2(240) | ||
| class | varchar2(30) | not null | Kind of item, e.g. AxisItem, MeasureItem, DisplaySequence, TableSort, SortItems, Totals, Parameter, Condition. |
| item_type | varchar2(30) | ||
| ref_object_key | varchar2(100) | ||
| default_parameter_value | varchar2(4000) | Worksheet default value of a parameter. | |
| sort_order | number | ||
| display_sequence | number | ||
| distinct_flag | varchar2(1) | ||
| subtotals | varchar2(25) | ||
| subtotals_type | varchar2(25) | ||
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_discoverer_sheets_u1 | unique | eul, doc_id, sheet_name, class, item_key, decode(class, 'axisitem', item_type |
xxen_discoverer_workbook_xmls
Staging: one row per Discoverer workbook export (.eex) loaded for conversion into Blitz Reports.
| Column | Type | Null | Description |
|---|---|---|---|
| eul | varchar2(30) | not null | End User Layer owner the workbook belongs to. |
| doc_id | number | not null | Discoverer workbook document id. |
| xml | xmltype | not null | The workbook export. |
| convert_flag | varchar2(1) | Y = selected for conversion; C = converted by the Discoverer import. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_disco_workbook_xmls_u1 | unique | eul, doc_id |
xxen_discoverer_workbooks
Staging: workbook-level items (parameters, displayed items, conditions, calculations) parsed from the workbook exports in xxen_discoverer_workbook_xmls (eul, doc_id).
| Column | Type | Null | Description |
|---|---|---|---|
| eul | varchar2(30) | not null | End User Layer owner. |
| doc_id | number | not null | Discoverer workbook document id. |
| doc_name | varchar2(100) | not null | |
| doc_description | varchar2(4000) | ||
| doc_owner | varchar2(64) | not null | |
| item_key | varchar2(240) | ||
| item_name | varchar2(240) | ||
| item_description | varchar2(4000) | ||
| class | varchar2(30) | not null | Kind of item: Parameter, DisplayedItem, Condition or Calculation. |
| ref_name | varchar2(240) | ||
| ref_type | varchar2(30) | Kind of object the item refers to: EulItem, Calculation or Parameter. | |
| ref_key | varchar2(240) | ||
| ref_item_name | varchar2(4000) | ||
| ref_object_key | varchar2(100) | ||
| display_item_type | varchar2(25) | ||
| expression_string | clob | Discoverer expression of a calculation or condition. | |
| required | varchar2(1) | ||
| prompt | varchar2(80) | ||
| case_sensitive | varchar2(1) | ||
| display_sequence | number | ||
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_discoverer_workbooks_u1 | unique | eul, doc_id, class, item_key, ref_name, ref_key |
xxen_report_assignment_users
Users an include assignment is limited to; joins xxen_report_assignments (assignment_id) to fnd_user (user_id). An include assignment without rows here applies to all users at its level.
| Column | Type | Null | Description |
|---|---|---|---|
| assignment_id | number | not null | |
| user_id | number | not null | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_assign_users_u1 | unique | assignment_id, user_id |
| xxen_report_assign_users_n1 | user_id |
xxen_report_assignments
One row per assignment that makes a report available (include) or unavailable (exclude) at an EBS level, or links it as a drilldown; joins to xxen_reports by report_id. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| assignment_id | number | not null | Primary key. |
| report_id | number | not null | The assigned report (xxen_reports); for a Report level assignment the drilldown target report. |
| include_exclude | varchar2(1) | not null | I = include, E = exclude. |
| assignment_level | varchar2(14) | not null | Site, Application, Request Group, Responsibility, User, Form, Function or Report. |
| id1 | number | not null | Site: 0; Application: application_id; Request Group: request_group_id; Responsibility: responsibility_id; User: user_id; Form: form_id; Function: function_id; Report: report_id of the source report the drilldown starts from. |
| id2 | number | Request Group, Responsibility and Form: application_id of the group, responsibility or form; Report: template_id (xxen_report_templates) the drilldown runs with. | |
| block_name | varchar2(30) | Form and Function levels: Forms block the report is launched from; null for any block. | |
| drilldown_column | varchar2(240) | Report level: column of the source report that offers the drilldown. | |
| matching_column | varchar2(240) | Report level: source report column whose value is tested against matching_value; null tests the drilldown column itself. | |
| matching_value | varchar2(2000) | Report level: value or semicolon-separated values (% wildcards allowed) the tested column must have for the drilldown to apply; null applies to every row. | |
| disabled | varchar2(1) | Y when the assignment is disabled. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_assignments_u1 | unique | assignment_id |
| xxen_report_assignments_u2 | unique | id1, assignment_level, report_id, id2, block_name, drilldown_column, matching_column, matching_value |
| xxen_report_assignments_n1 | report_id |
xxen_report_categories_tl
One row per report category and language; category_id identifies the category across languages. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| category_id | number | not null | Category identifier, referenced by xxen_report_category_assigns. |
| language | varchar2(4) | not null | Language code of this translation. |
| source_lang | varchar2(4) | not null | Language the text was entered in. |
| category | varchar2(120) | not null | Category name in this language. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null | |
| last_update_login | number |
| Index | Type | Columns |
|---|---|---|
| xxen_report_categories_tl_u1 | unique | category_id, language |
| xxen_report_categories_tl_u2 | unique | category, language |
xxen_report_category_assigns
Assignment of reports to categories; joins xxen_reports (report_id) to xxen_report_categories_tl (category_id). A report can belong to several categories.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| category_id | number | not null | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_category_assign_u1 | unique | report_id, category_id |
| xxen_report_category_assign_n1 | category_id |
xxen_report_columns
One row per report column alias (across all reports) with a translated heading or a number format. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| column_id | number | not null | Primary key. |
| column_name | varchar2(251) | not null | Column alias as used in report SQL, lower case. |
| number_format | varchar2(80) | Excel number format for this column wherever it appears. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_columns_u1 | unique | column_id |
| xxen_report_columns_u2 | unique | column_name |
xxen_report_columns_tl
Translations of column headings, one row per column_id and language; joins to xxen_report_columns by column_id.
| Column | Type | Null | Description |
|---|---|---|---|
| column_id | number | not null | |
| language | varchar2(4) | not null | Language code of this translation. |
| translation | varchar2(753) | not null | Column heading in this language. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_columns_tl_u1 | unique | column_id, language |
| xxen_report_columns_tl_n1 | translation | |
| xxen_report_columns_tl_n2 | last_updated_by |
xxen_report_default_templates
The default template per report, for all users or for one user; joins to xxen_reports by report_id and xxen_report_templates by template_id.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| user_id | number | User the default applies to; null = default for all users. | |
| template_id | number | Default template; null on a user row means the user runs without a template although a global default exists. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_default_templ_u1 | unique | report_id, user_id |
xxen_report_dyn_col_rule_rpts
Assignment of dynamic column translation rules to reports; joins xxen_report_dynamic_col_rules (rule_id) to xxen_reports (report_id). Only rules assigned to a report run for it.
| Column | Type | Null | Description |
|---|---|---|---|
| rule_id | number | not null | |
| report_id | number | not null | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_rpt_dyn_col_rule_rpts_u1 | unique | report_id, rule_id |
xxen_report_dynamic_col_rules
One row per dynamic column translation rule: a query producing column headings that depend on setup data or parameter values, such as descriptive flexfield segment prompts. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| rule_id | number | not null | Primary key. |
| rule_name | varchar2(60) | not null | Unique rule name. |
| rule_sql | varchar2(4000) | not null | Query returning column_name and translation pairs; may reference run parameters as :binds. |
| enabled | varchar2(1) | Y when the rule is enabled. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_dyn_col_rules_u1 | unique | rule_id |
| xxen_report_dyn_col_rules_u2 | unique | rule_name |
xxen_report_fonts
Internal reference data: the width of each character per font, size and formatting, used to calculate Excel column widths.
| Column | Type | Null | Description |
|---|---|---|---|
| font_name | varchar2(100) | not null | |
| font_size | number | not null | |
| formatting | varchar2(10) | B = bold; null = regular. | |
| character | varchar2(4) | not null | The character. |
| character_width | number | not null | Width of the character. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_fonts_u1 | unique | font_name, font_size, unistr('\'||asciistr(character |
xxen_report_license_hash
Internal: license integrity data. Do not modify.
| Column | Type | Null | Description |
|---|---|---|---|
| hash | varchar2(128) | ||
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
xxen_report_license_key
Internal: single row holding the installation's license and version.
| Column | Type | Null | Description |
|---|---|---|---|
| company_name | varchar2(100) | Licensed company name. | |
| license_key | varchar2(64) | Encrypted license key. | |
| version | varchar2(10) | not null | Installed Blitz Report version. |
| build_date | date | not null | Build date of the installed version. |
| version_last_update_date | date | not null | Time the installed version was last installed or upgraded. |
| fsg_build_date | date | Build date of the FSG workbook loaded on this instance. | |
| custom_application_short_name | varchar2(50) | not null | Short name of the custom application Blitz Report is registered under. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
xxen_report_license_users
Internal: one row per user who ran a report in the last 60 days, used to count active users against the license.
| Column | Type | Null | Description |
|---|---|---|---|
| user_id | number | not null | fnd_user.user_id. |
| last_run_date | date | not null | Time of the user's last run. |
| Index | Type | Columns |
|---|---|---|
| xxen_report_license_users_u1 | unique | user_id |
| xxen_report_license_users_n1 | last_run_date |
xxen_report_lov_counts
Internal: row counts of LOV queries, taken by the concurrent program Blitz Report Update LOV Filter Before Display to set filter_before_display. One row per shared LOV, custom parameter LOV or custom upload column LOV.
| Column | Type | Null | Description |
|---|---|---|---|
| type | varchar2(13) | not null | LOV (shared LOV, lov_id), Parameter (custom parameter LOV, parameter_id) or Upload Column (custom upload column LOV, report_id and column_name). |
| lov_id | number | ||
| parameter_id | number | ||
| report_id | number | ||
| column_name | varchar2(251) | ||
| query_hash | number | not null | Hash of the query that was counted; a changed query is counted again. |
| request_id | number | not null | Concurrent request that queued the count. |
| session_number | number | not null | Counting session the LOV was assigned to. |
| status | varchar2(9) | not null | Queued, Counting, Counted, Timed Out or Error. |
| filter_change | varchar2(7) | Set or Removed when the count switched filter before display on or off. | |
| row_count | number | Largest row count found. | |
| attempts | number | Number of count queries executed (dependent LOVs are counted with several parent values). | |
| activity_time | timestamp | Time of the last counting activity, used to stop counts running too long. | |
| message | varchar2(4000) | Error message of a failed count. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_lov_counts_u1 | unique | type, lov_id, parameter_id, report_id, column_name |
| xxen_report_lov_counts_n1 | request_id, session_number, status |
xxen_report_output
Internal: report output too large for one webservice response, held for the Excel add-in to fetch in batches; deleted after the last batch or after an hour.
| Column | Type | Null | Description |
|---|---|---|---|
| run_id | number | not null | |
| output_clob | clob | The output data. | |
| batch_size | number | Characters per batch. | |
| total_batches | number | Number of batches. | |
| creation_date | date |
| Index | Type | Columns |
|---|---|---|
| xxen_report_output_u1 | unique | run_id |
| xxen_report_output_n1 | creation_date |
xxen_report_param_default_vals
One row per saved parameter default of a user or a template; joins to xxen_report_parameters by parameter_id. Exactly one of user_id and template_id is set.
| Column | Type | Null | Description |
|---|---|---|---|
| parameter_id | number | not null | |
| user_id | number | User the default belongs to (fnd_user.user_id); null for a template default. | |
| template_id | number | Template the default belongs to (xxen_report_templates); null for a user default. | |
| default_value | clob | The default: the LOV id for parameters with an id LOV, otherwise the display value. | |
| locked | varchar2(1) | Template defaults: Y when the value is fixed for users of the template and cannot be changed on the run screen; users with Developer or System access are exempt. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_param_def_vals_u1 | unique | parameter_id, user_id, template_id |
xxen_report_param_dependencies
Derived: one row per reference of a parameter's default value or LOV to another parameter (:$flex$.<name>); maintained by the import and the setup form. Joins to xxen_report_parameters twice.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| flex_bind | varchar2(100) | not null | The :$flex$ token as written in the dependent's default or LOV. |
| parameter_id | number | not null | The referenced (parent) parameter. |
| is_date | varchar2(1) | Y when the parent parameter is of type Date or DateTime. | |
| dependent_parameter_id | number | not null | The parameter whose default or LOV contains the reference. |
| id_or_value | varchar2(5) | value when the token reads the parent's display value (:$flex$.<name>.value); null when it reads the id. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_param_depend_u1 | unique | dependent_parameter_id, flex_bind |
| xxen_report_param_depend_n1 | report_id | |
| xxen_report_param_depend_n2 | parameter_id |
xxen_report_parameter_anchors
The anchors declared in a report's SQL; joins to xxen_reports by report_id. Parameter SQL is injected only at registered anchors. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| anchor | varchar2(131) | not null | Anchor text as it appears in the SQL, e.g. 1=1, &dff_columns, :p_date; unique per report regardless of case. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_param_anchors_u1 | unique | report_id, lower(anchor |
xxen_report_parameter_lovs
One row per shared LOV (list of values) usable by report parameters, upload columns and template conditions. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| lov_id | number | not null | Primary key. |
| guid | raw(16) | not null | Global identifier of the LOV, identical on every instance; the XML import matches LOVs by it, then by name. |
| lov_name | varchar2(100) | not null | Unique LOV name. |
| filter_before_display | varchar2(1) | Y when the list is searched with a filter before it is listed; set per instance by the concurrent program Blitz Report Update LOV Filter Before Display. | |
| lov_query | clob | not null | The LOV query, returning id (optional), value and description columns. |
| value_to_id_query | varchar2(4000) | Query translating a display value to its id for upload columns using this LOV, used instead of the LOV query. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_parameter_lovs_u1 | unique | lov_id |
| xxen_report_parameter_lovs_u2 | unique | lov_name |
| xxen_report_parameter_lovs_u3 | unique | guid |
xxen_report_parameter_lovs_h
History: one row per stored version of a shared LOV's query; joins to xxen_report_parameter_lovs by lov_id and guid.
| Column | Type | Null | Description |
|---|---|---|---|
| lov_id | number | not null | |
| guid | raw(16) | not null | |
| lov_name | varchar2(100) | not null | |
| lov_query | clob | not null | The LOV query of this version. |
| comments | varchar2(4000) | Version comment. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_param_lovs_h_u1 | unique | lov_id, creation_date |
| xxen_report_param_lovs_h_u2 | unique | guid, creation_date |
xxen_report_parameter_lovs_tl
Translation table of xxen_report_parameter_lovs, one row per lov_id and language.
| Column | Type | Null | Description |
|---|---|---|---|
| lov_id | number | not null | |
| language | varchar2(4) | not null | Language code of this translation. |
| source_lang | varchar2(4) | not null | Language the text was entered in. |
| description | varchar2(2000) | LOV description, shown as hint text where the parameter has none. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null | |
| last_update_login | number |
| Index | Type | Columns |
|---|---|---|
| xxen_report_param_lovs_tl_u1 | unique | lov_id, language |
xxen_report_parameters
One row per report parameter or parameter sub-row; joins to xxen_reports by report_id, names in xxen_report_parameters_tl. Several rows with the same name form one run-screen parameter: the row with a display_sequence and sub-rows without. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| parameter_id | number | not null | Primary key, referenced by run values, defaults and dependencies. |
| report_id | number | not null | |
| display_sequence | number | Position on the run screen; negative = hidden parameter, null = sub-row of the parameter with the same name. | |
| anchor | varchar2(131) | not null | Place in the report SQL the parameter acts on: n=n (sql_text appended as a where condition), &lexical (replaced by sql_text), or :bind (the value is bound directly). |
| sql_text | clob | SQL fragment injected at the anchor when the parameter has a value. | |
| parameter_type | varchar2(30) | Char, Number, Date, DateTime, LOV (Blitz Report LOV or custom query) or LOV Oracle (EBS value set); null on sub-rows. | |
| lov_id | number | Type LOV: xxen_report_parameter_lovs.lov_id of a shared LOV; type LOV Oracle: fnd_flex_value_sets.flex_value_set_id. | |
| free_text | varchar2(1) | Y when values outside the LOV are accepted; otherwise an LOV parameter validates against its LOV. | |
| filter_before_display | varchar2(1) | Y when the LOV is searched with a filter before it is listed; set per instance from the LOV's row count. | |
| lov_query | clob | Custom LOV query when no shared LOV is used; returns id (optional), value and description columns. | |
| id_or_value | varchar2(5) | value = bind the LOV display value instead of the id; null binds the id when the LOV has an id column. | |
| matching_value | varchar2(2000) | LOV id value for which this row's sql_text applies; lets one parameter apply different SQL per selected value. | |
| default_value | varchar2(4000) | Default value: a literal, an expression such as fnd_profile.value('ORG_ID'), or a select statement returning one row; may reference other parameters as :$flex$.<name>. | |
| required | varchar2(1) | Y when the parameter must have a value. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_parameters_u1 | unique | parameter_id |
| xxen_report_parameters_u2 | unique | report_id, display_sequence, nvl2(display_sequence, null, parameter_id |
| xxen_report_parameters_u3 | unique | casewhenanchorlike':%'thenreport_idend, casewhenanchorlike':%'thenanchorend |
| xxen_report_parameters_n1 | lov_id | |
| xxen_report_parameters_n2 | last_updated_by |
xxen_report_parameters_tl
Translation table of xxen_report_parameters, one row per parameter_id and language.
| Column | Type | Null | Description |
|---|---|---|---|
| parameter_id | number | not null | |
| report_id | number | not null | |
| language | varchar2(4) | not null | Language code of this translation. |
| source_lang | varchar2(4) | not null | Language the text was entered in. |
| parameter_name | varchar2(80) | not null | Parameter name shown on the run screen; also the name referenced as :$flex$.<name> (blanks as underscores). |
| description | varchar2(2000) | Parameter description shown as hint text. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null | |
| last_update_login | number |
| Index | Type | Columns |
|---|---|---|
| xxen_report_parameters_tl_u1 | unique | parameter_id, language |
| xxen_report_parameters_tl_n1 | report_id |
xxen_report_run_param_values
Run-time data: the parameter values and run options of a run; joins to xxen_report_runs by run_id. Rows exist only for values that were set.
| Column | Type | Null | Description |
|---|---|---|---|
| run_id | number | not null | |
| parameter_id | number | not null | Positive: xxen_report_parameters.parameter_id, or the condition_id of a prompted template condition; negative: a run option (template name, output format, email and so on), identified by the tag of lookup XXEN_REPORT_TRANSLATIONS meaning RUNTIME_OPTIONS.<option>. |
| value | clob | not null | The value: the LOV id for parameters with an id LOV, otherwise the display value; several values start with <multiple_values> and are separated by semicolons. |
| value_char | varchar2(4000) | The value as varchar2 (first 4000 bytes), used by the multiple values expansion; null for <multiple_values> rows, which are split on use. | |
| manually_changed | varchar2(1) | Y when the user changed the value from its default on the run screen. |
| Index | Type | Columns |
|---|---|---|
| xxen_report_run_param_vals_u1 | unique | run_id, parameter_id, value_char |
xxen_report_runs
Run-time data: one row per report or upload run, from the run screen, a concurrent request, the Excel add-in or the API; parameter values in xxen_report_run_param_values.
| Column | Type | Null | Description |
|---|---|---|---|
| run_id | number | not null | Primary key. |
| report_id | number | not null | The report run (xxen_reports). |
| responsibility_application_id | number | not null | Application of the responsibility the run was made from. |
| responsibility_id | number | not null | Responsibility the run was made from. |
| created_by | number | not null | User who ran the report. |
| creation_date | date | not null | |
| start_date | date | Time the report execution started. | |
| completion_date | date | Time the report execution completed; null while running or after a failure. | |
| completion_message | varchar2(4000) | Message of a run that did not complete normally, e.g. a license or report error. | |
| request_id | number | Blitz Report concurrent request of the run (fnd_concurrent_requests); null for runs outside a concurrent request, e.g. from the Excel add-in. | |
| type | varchar2(1) | Report type at run time (xxen_reports.type), U for uploads. | |
| row_count | number | Number of rows written. | |
| file_size | number | Size of the output file in bytes. | |
| upload_request_id | number | Uploads: concurrent request of the Blitz Upload program that processed this run's rows. | |
| upload_file_name | varchar2(256) | Uploads: name of the uploaded workbook. | |
| upload_errors | varchar2(1) | Y when the upload result contains rows in error. |
| Index | Type | Columns |
|---|---|---|
| xxen_report_runs_u1 | unique | run_id |
| xxen_report_runs_u2 | unique | request_id |
| xxen_report_runs_n1 | report_id, creation_date | |
| xxen_report_runs_n2 | creation_date | |
| xxen_report_runs_n3 | type, creation_date | |
| xxen_report_runs_n4 | created_by, creation_date | |
| xxen_report_runs_n5 | nvl2(completion_date, null, 'y' | |
| xxen_report_runs_n6 | upload_request_id |
xxen_report_sens_labels
One row per sensitivity label (Microsoft Purview information protection) that can be assigned to reports; the label's properties are in xxen_report_sens_lbl_props. Configuration.
| Column | Type | Null | Description |
|---|---|---|---|
| label_id | varchar2(36) | not null | Label GUID as defined in the organization's label policy. |
| enabled | varchar2(1) | Y when the label can be selected. | |
| description | varchar2(240) | Label name shown in the label list; defaults to the label's Name property. | |
| display_sequence | number | not null | Order of the label in the list. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_sens_labels_u1 | unique | label_id |
xxen_report_sens_lbl_props
One row per property of a sensitivity label; joins to xxen_report_sens_labels by label_id. The properties are written into the Excel output as MSIP_Label_<label_id>_<property_name> document properties.
| Column | Type | Null | Description |
|---|---|---|---|
| label_id | varchar2(36) | not null | |
| property_name | varchar2(100) | not null | Property name, e.g. Name, Enabled, Method, SiteId, ContentBits. |
| property_value | varchar2(4000) | Property value. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_sens_lbl_props_u1 | unique | label_id, property_name |
xxen_report_shared_strings
Internal: the shared strings (xl/sharedStrings.xml) of an uploaded Excel template workbook, one row per string; joins to xxen_report_templates by template_id.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| string_id | number | not null | Zero-based index of the string in the workbook. |
| string | clob | not null | String text; for rich text the whole <si> element. |
| string_type | varchar2(1) | R = rich text, E = empty string, null = plain text. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_shared_strings_u1 | unique | template_id, string_id |
xxen_report_templ_conditions
One row per filter condition a template applies to the report output; joins to xxen_report_templates by template_id. Applied as bound predicates on the template's wrapper select of the report SQL, for reports and upload downloads.
| Column | Type | Null | Description |
|---|---|---|---|
| condition_id | number | not null | Primary key, from the parameter id sequence: a prompted condition's run value is stored in xxen_report_run_param_values under this id. |
| template_id | number | not null | |
| display_sequence | number | not null | Order of the condition. |
| column_name | varchar2(251) | not null | Report column the condition filters on. |
| operator | varchar2(11) | not null | Comparison operator, e.g. =, <>, like, >=, is not null. |
| value | varchar2(4000) | Fixed comparison value; for a prompted condition the default. | |
| parameter_type | varchar2(30) | Data type of the value: Char, Number, Date. | |
| lov_id | number | LOV (xxen_report_parameter_lovs) offered for the value. | |
| lov_picked_by | number | User who chose the LOV; null when it was suggested automatically. | |
| lov_picked_date | date | Time the LOV was chosen. | |
| prompt | varchar2(1) | Y when the value is asked on the run screen; otherwise the fixed value applies. | |
| required | varchar2(1) | Y when a prompted value is required. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_templ_cond_u1 | unique | condition_id |
| xxen_report_templ_cond_n1 | template_id |
xxen_report_templ_excl_params
Parameters hidden from the run screen when a template is used; joins xxen_report_templates (template_id) to xxen_report_parameters (parameter_id). A template default of an excluded parameter is still applied.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| parameter_id | number | not null | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_templ_excl_par_u1 | unique | template_id, parameter_id |
xxen_report_template_columns
One row per report column a template lists; joins to xxen_report_templates by template_id. Column names are unique per template.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| display_sequence | number | Position of the column in the output; null hides the column. | |
| column_name | varchar2(251) | not null | Report column alias, upper case. |
| aggregation | varchar2(14) | SUM, COUNT, COUNT_DISTINCT, MIN, MAX or AVG; when any column is aggregated, the output is grouped by every displayed column without aggregation. | |
| sort_order | number | Position in the order by clause; negative = descending. | |
| sheet_break | varchar2(1) | Y when a new worksheet starts for each value of this column. | |
| required | varchar2(1) | Uploads: Y when the column is required in this template. | |
| read_only | varchar2(1) | Uploads: Y when the column is read only in this template. | |
| hidden | varchar2(1) | Y places the column after the visible ones (hidden in uploads); it does not remove it from the output. | |
| freeze_panes | varchar2(1) | Y on the first scrollable column: the columns to its left and the header row are frozen. | |
| default_value | varchar2(4000) | Uploads: default value of the column in this template; for a read only column a semicolon-separated list of allowed values. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_template_cols_u1 | unique | template_id, column_name |
| xxen_report_template_cols_u2 | unique | nvl2(sort_order, template_id, null |
xxen_report_template_files
One row per file (zip part) of an uploaded Excel template workbook; joins to xxen_report_templates by template_id.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| file_name | varchar2(100) | not null | Part name inside the workbook, e.g. xl/worksheets/sheet1.xml. |
| file_data | blob | Content of the part. | |
| sheet_number | number | Worksheet parts: number of the worksheet. | |
| sheet_name | varchar2(31 char) | Worksheet parts: worksheet name. | |
| sheet_type | varchar2(9) | data = the worksheet that receives the report output; parameter = the worksheet that receives the parameter values; null for other parts. | |
| column_header_row_num | number | Data sheet: row number of the column headings. | |
| column_header_start | varchar2(10) | Data sheet: cell of the first column heading, e.g. A1. | |
| custom_last_row | clob | Data sheet: XML of the sheet's last row when it contains formulas (e.g. totals), written below the report data. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_template_files_u1 | unique | template_id, file_name |
| xxen_report_template_files_u2 | unique | template_id, nvl(to_char(sheet_number |
xxen_report_template_pivot
One row per field of a template's built-in pivot table; joins to xxen_report_templates by template_id.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| column_name | varchar2(251) | not null | Report column used as pivot field. |
| field_type | varchar2(6) | not null | FILTER, ROW, COLUMN or VALUE (data field). |
| display_sequence | number | not null | Order of the field within its area. |
| aggregation | varchar2(5) | VALUE fields: SUM, COUNT, AVG or MAX. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_template_pivot_u1 | unique | template_id, column_name, aggregation |
xxen_report_template_sharing
One row per level a template is shared with; joins to xxen_report_templates by template_id. A template without sharing rows can be used only by its owner and template super users.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| id1 | number | not null | Site: 0; Responsibility: responsibility_id; User: user_id. |
| id2 | number | Responsibility: application_id of the responsibility. | |
| sharing_level | varchar2(1) | not null | S = site, R = responsibility, U = user. |
| restricted | varchar2(1) | Y when users at this level may run the report only with this template (or another restricted template), not with the plain report; users with Developer or System access are exempt. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_template_sharin_u1 | unique | id1, sharing_level, template_id, id2 |
| xxen_report_template_sharin_n1 | template_id |
xxen_report_template_styles
Internal: cell styles of an uploaded template workbook applied to generated cells; joins to xxen_report_templates by template_id.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | |
| sheet_type | varchar2(9) | not null | data or parameter, as in xxen_report_template_files. |
| cell_identifier | varchar2(10) | not null | Cell reference (e.g. B16) or column letter for a whole column. |
| style_id | number | not null | Index of the cell style in the workbook's xl/styles.xml. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_template_styles_u1 | unique | template_id, sheet_type, cell_identifier |
xxen_report_templates
One row per report template: a column selection, sort, aggregation, pivot and optional Excel workbook for a report; joins to xxen_reports by report_id. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| template_id | number | not null | Primary key. Negative ids are temporary templates of a single run. |
| guid | raw(16) | not null | Global identifier of the template, identical on every instance; the XML import matches templates by it. |
| template_name | varchar2(240) | not null | Template name, unique per report. |
| report_id | number | not null | |
| distinct_flag | varchar2(1) | Y when the output is reduced to distinct rows (select distinct). | |
| dynamic_columns | varchar2(1) | Y when report columns without a row in xxen_report_template_columns are included in the output; otherwise they are hidden. | |
| description | varchar2(4000) | Template description. | |
| owner_type | varchar2(1) | not null | U = owned by a user, R = owned by a responsibility. |
| owner_id | number | not null | Owning user (fnd_user.user_id) or responsibility (fnd_responsibility.responsibility_id). |
| owner_appl_id | number | Application of the owning responsibility. | |
| file_name | varchar2(256) | File name of the uploaded Excel template workbook. | |
| file_language | varchar2(3) | Language the column headings of the uploaded workbook are written in; headings are translated when the report runs in another language. | |
| pivot_layout | varchar2(1) | T = tabular pivot layout; null = compact. | |
| repeat_labels | varchar2(1) | Y when pivot row labels are repeated on every row. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_templates_u1 | unique | template_id |
| xxen_report_templates_u2 | unique | guid |
| xxen_report_templates_u3 | unique | report_id, template_name |
| xxen_report_templates_n1 | last_updated_by |
xxen_report_zoom_param_vals
Parameter values passed when a report is launched from an assignment: from an Oracle form (Form and Function levels) or as an add-in drilldown (Report level); joins to xxen_report_assignments by assignment_id and xxen_report_parameters by parameter_id.
| Column | Type | Null | Description |
|---|---|---|---|
| assignment_id | number | not null | |
| parameter_id | number | not null | |
| block_name | varchar2(30) | Form and Function levels: Forms block the value is taken from; Report level: Column (value from a source report column) or Parameter (value from a source report parameter). | |
| item_name | varchar2(30) | Forms item, or source report column or parameter name, the value is taken from. | |
| id_or_value | varchar2(5) | id when the form item holds the LOV id; null when it holds the display value. | |
| parameter_value | varchar2(4000) | Fixed value passed when no block and item are given; <null> passes an empty value. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_report_zoom_param_vals_u1 | unique | assignment_id, parameter_id |
xxen_reports
One row per report or upload definition, keyed by report_id; the name and description are in xxen_reports_tl, the parameters in xxen_report_parameters and, for uploads, the columns in xxen_upload_columns. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | Primary key, used by every child table. |
| guid | raw(16) | not null | Global identifier of the report, identical on every instance; the XML import matches reports by it. |
| sql_text | clob | not null | The report SQL, including the parameter anchors (1=1, &lexical, :bind) where parameter SQL is injected at run time. |
| disabled | varchar2(1) | Y when the report is disabled and cannot be run. | |
| type | varchar2(1) | Report type: null = report, U = upload, F = FSG financial statement, D = drilldown, S = system, P = protected. | |
| xdo_application_short_name | varchar2(50) | Application short name of the BI Publisher data definition the report was converted from. | |
| xdo_data_source_code | varchar2(80) | Code of the BI Publisher data definition (xdo_lobs.lob_code) the report was converted from; its data template supplies the default PL/SQL package. | |
| number_format | varchar2(80) | Default Excel number format for the numeric columns of this report. | |
| copied_from_guid | raw(16) | GUID of the report this report was copied from. | |
| db_package | varchar2(128) | PL/SQL package whose beforereport and afterreport triggers run before and after the SQL; it receives each parameter value in a package variable named after the parameter's anchor. When null, the package named in the BI Publisher data template is used. | |
| author_email | varchar2(4000) | Email address of the report author, shown in the setup form. | |
| varchar2(4000) | Default email recipients of the run (the EMAIL run option); either addresses or a select statement returning them. | ||
| output_format | varchar2(5) | Default output format of the run (the OUTPUT_FORMAT run option), e.g. XLSX, CSV, TSV; null = XLSX. | |
| row_limit | number | Default maximum number of rows written (the ROW_LIMIT run option). | |
| time_limit | number | Default maximum run time in minutes after which the run is terminated (the TIME_LIMIT run option). | |
| custom_postprocess | varchar2(240) | Default command run on the output file after the report completes (the CUSTOM_POSTPROCESS run option). | |
| output_file_name | varchar2(240) | Default name of the downloaded or emailed output file (the OUTPUT_FILE_NAME run option); plain text and tokens. | |
| server_output_directory | varchar2(240) | Default server directory a copy of the output is written to (the SERVER_OUTPUT_DIRECTORY run option). | |
| server_file_name | varchar2(240) | Default file name of the server directory copy (the SERVER_FILE_NAME run option). | |
| request_type_id | number | Concurrent request class (fnd_concurrent_request_class.request_class_id) stamped on the report's concurrent requests at submission, so concurrent managers can be specialized by request type. | |
| target_database | varchar2(256) | Database link (user_db_links.db_link) to a database the report runs on instead of the local one; overrides the profile Blitz Report Target Database. | |
| required_parameters | varchar2(4000) | Boolean SQL condition over the parameters (:Parameter_Name) that must be true before the report can be submitted, e.g. (:Ledger is not null or :Operating_Unit is not null); the message shown otherwise is xxen_reports_tl.required_parameters_message. | |
| upload_type | varchar2(1) | Upload processing type: A = PL/SQL procedure (upload_object is the procedure), I = interface table (upload_object is the table). | |
| upload_create_only | varchar2(1) | Y when the upload only creates records; downloaded rows cannot be updated. | |
| upload_delete_condition | varchar2(4000) | Interface table uploads only: where condition deleting rows from the interface table before the upload inserts; may reference :$column$ and :$flex$ tokens. | |
| upload_decimal_places | number | Number of decimal places numeric cells are rounded to before processing; null = profile XXEN_UPLOAD_ROUND_TO_DECIMAL_PLACES, default 5. | |
| upload_object | varchar2(159) | PL/SQL procedure (package.procedure) called once per uploaded row, or the interface table inserted into, depending on upload_type. | |
| upload_post_procedure | varchar2(159) | PL/SQL procedure called after all rows, once per distinct combination of its IN parameters over the successful rows. | |
| upload_excel_validation | varchar2(4000) | Function call validating a whole row in Excel before upload, referencing the row's cells as :$column$ tokens. | |
| upload_object_date | date | Timestamp of the upload_object specification when its parameters were last read into xxen_upload_parameters. | |
| upload_post_procedure_date | date | Timestamp of the upload_post_procedure specification when its parameters were last read into xxen_upload_parameters. | |
| sensitivity_label_id | varchar2(36) | Sensitivity label (xxen_report_sens_labels.label_id) written into the Excel output file. | |
| attribute_category | varchar2(30) | Descriptive flexfield context column for customer use. | |
| attribute1 | varchar2(240) | ||
| attribute2 | varchar2(240) | ||
| attribute3 | varchar2(240) | ||
| attribute4 | varchar2(240) | ||
| attribute5 | varchar2(240) | ||
| attribute6 | varchar2(240) | ||
| attribute7 | varchar2(240) | ||
| attribute8 | varchar2(240) | ||
| attribute9 | varchar2(240) | ||
| attribute10 | varchar2(240) | ||
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_reports_u1 | unique | report_id |
| xxen_reports_u2 | unique | guid |
| xxen_reports_n1 | creation_date |
xxen_reports_h
History: one row per stored version of a report's SQL, written when an import or a save in the setup form changes xxen_reports.sql_text; joins to xxen_reports by report_id and guid.
| Column | Type | Null | Description |
|---|---|---|---|
| report_name | varchar2(240) | not null | Report name at the time of the version. |
| report_id | number | not null | |
| guid | raw(16) | not null | |
| sql_text | clob | not null | The report SQL of this version. |
| comments | varchar2(4000) | Version comment describing the change. | |
| created_by | number | not null | |
| creation_date | date | not null | Time the version was recorded. |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_reports_h_u1 | unique | report_id, creation_date |
| xxen_reports_h_u2 | unique | guid, creation_date |
xxen_reports_tl
Translation table of xxen_reports, one row per report_id and language.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| language | varchar2(4) | not null | Language code of this translation. |
| source_lang | varchar2(4) | not null | Language the text was entered in. |
| report_name | varchar2(240) | not null | Report name in this language, unique per language. |
| description | varchar2(4000) | Report description shown on the run screen. | |
| required_parameters_message | varchar2(2000) | Message shown when the required_parameters condition of xxen_reports is not met. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null | |
| last_update_login | number |
| Index | Type | Columns |
|---|---|---|
| xxen_reports_tl_u1 | unique | report_id, language |
| xxen_reports_tl_u2 | unique | report_name, language |
xxen_ssrs_xmls
Staging: SQL Server Reporting Services report definitions (.rdl files) loaded through the XML upload for conversion into Blitz Reports.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | Identifier of the staged report definition. |
| report_name | varchar2(1000) | not null | Name of the .rdl report. |
| report_path | varchar2(1000) | not null | Path of the .rdl file in the uploaded archive. |
| xml | xmltype | not null | The report definition. |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_ssrs_xmls_u1 | unique | report_name, report_path |
xxen_upload_columns
One row per column of an upload's spreadsheet, derived from the upload's main SQL; joins to xxen_reports by report_id. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| column_number | number | not null | Position of the column in the upload SQL. |
| column_name | varchar2(251) | not null | Column alias in the upload SQL, upper case; framework columns end with an underscore (ACTION_, STATUS_, MESSAGE_, MODIFIED_COLUMNS_). |
| column_type | varchar2(10) | not null | Char, Number, Date, DateTime, LOV, LOV Oracle or Rowid. |
| data_type | varchar2(8) | not null | Data type of the column in the generated upload view: varchar2, number, date or rowid. |
| data_length | number | Maximum length of a varchar2 column in bytes. | |
| lov_id | number | Type LOV: xxen_report_parameter_lovs.lov_id of a shared LOV; type LOV Oracle: fnd_flex_value_sets.flex_value_set_id. | |
| free_text | varchar2(1) | Y when values outside the LOV are accepted. | |
| filter_before_display | varchar2(1) | Y when the LOV is searched with a filter before it is listed. | |
| lov_query | clob | Custom LOV query when no shared LOV is used; may reference other columns as :$column$.<name> and report parameters as :$flex$.<name>. | |
| value_to_id_query | varchar2(4000) | Query translating the cell's display value to the id passed to the procedure, used instead of the LOV. | |
| default_value | varchar2(4000) | Default value of the column for new rows; may reference other columns and parameters. | |
| comments | varchar2(4000) | Comment shown on the column heading; text starting with select or with is executed at download and its result shown. | |
| required | varchar2(1) | Y when the column must have a value. | |
| read_only | varchar2(1) | Y when the column cannot be changed on downloaded rows. | |
| hidden | varchar2(1) | Y when the column is hidden in the workbook. | |
| group_validation | varchar2(1) | Y when rows sharing the same values in all group validation columns fail together if one of them is invalid. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_columns_u1 | unique | report_id, column_name |
| xxen_upload_columns_n1 | lov_id |
xxen_upload_data
Internal: one row per uploaded spreadsheet row of an upload run (upload_row), with the cell values in columns column1 to column998; joins to xxen_report_runs by run_id. The upload view of each upload reads it.
| Column | Type | Null | Description |
|---|---|---|---|
| run_id | number | not null | The upload run (xxen_report_runs.run_id). |
| upload_row | number | not null | |
| column1 ... column998 | varchar2(4000) |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_data_u1 | unique | run_id, upload_row |
| xxen_upload_data_u1 | unique | run_id, upload_row |
xxen_upload_dependencies
Derived: one row per reference of an upload column's query to another column (:$column$) or a report parameter (:$flex$); maintained by the import and the setup form. Joins to xxen_reports by report_id.
| Column | Type | Null | Description |
|---|---|---|---|
| report_id | number | not null | |
| dependency_type | varchar2(17) | not null | Query containing the reference: LOV query, Default value, Value to id query, Excel validation or Comments. |
| flex_bind | varchar2(100) | not null | The token as written in the query. |
| report_parameter_id | number | Referenced report parameter (xxen_report_parameters) for a :$flex$ token. | |
| column_name | varchar2(251) | Referenced upload column for a :$column$ token. | |
| dependent_column_name | varchar2(251) | Upload column whose query contains the reference. | |
| dependent_upload_parameter_id | number | Value to id query: the upload parameter (xxen_upload_parameters) the translation feeds. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_dependencies_u1 | unique | report_id, dependency_type, flex_bind, dependent_column_name, dependent_upload_parameter_id |
| xxen_upload_dependencies_n1 | report_parameter_id |
xxen_upload_example
Example table written by the shipped example upload; not used by the product otherwise.
| Column | Type | Null | Description |
|---|---|---|---|
| id | number | not null | |
| name | varchar2(400) | not null | |
| date_of_birth | date | not null | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_example_u1 | unique | id |
xxen_upload_parameters
One row per argument of an upload's PL/SQL procedure or interface table column, read from the database object; joins to xxen_reports by report_id and maps arguments to xxen_upload_columns by column_name.
| Column | Type | Null | Description |
|---|---|---|---|
| parameter_id | number | not null | Primary key. |
| report_id | number | not null | |
| source | varchar2(1) | not null | U = argument of the row procedure (or interface table column); P = argument of the post procedure. |
| display_sequence | number | not null | Argument position. |
| parameter_name | varchar2(30) | not null | Argument or interface column name. |
| in_out | varchar2(9) | in, out or in/out; null for interface table columns. | |
| parameter_type | varchar2(6) | not null | Char, Number or Date. |
| defaulted | varchar2(1) | Y when the argument has a default in the procedure signature. | |
| column_name | varchar2(251) | Upload column passed to the argument (ACTION_CODE_ and STATUS_CODE_ for the framework action and status codes); null = not passed. | |
| id_or_value | varchar2(5) | value = pass the display value of an LOV column instead of its id. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_parameters_u1 | unique | parameter_id |
| xxen_upload_parameters_u2 | unique | report_id, source, parameter_name |
| xxen_upload_parameters_u3 | unique | report_id, source, display_sequence |
| xxen_upload_parameters_n1 | report_id, column_name |
xxen_upload_result_stage
Internal: API results an upload request hands to its result report request, one row per upload run (run_id of xxen_report_runs), because the result report runs as a separate request.
| Column | Type | Null | Description |
|---|---|---|---|
| run_id | number | not null | |
| result_clob | clob |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_result_stage_n1 | run_id |
xxen_upload_sqls
Additional SQL statements of an upload; joins to xxen_reports by report_id. Configuration content.
| Column | Type | Null | Description |
|---|---|---|---|
| sql_id | number | not null | Primary key. |
| report_id | number | not null | |
| sql_type | varchar2(11) | not null | Success SQL (rows of the result report for successful rows), Error SQL (rows for failed rows, generated when sql_text is null), Order By (order of processing) or Lexical (replaces an anchor of the upload SQL in the result run). |
| anchor | varchar2(131) | Lexical rows: the &anchor the sql_text replaces. | |
| sql_text | clob | The SQL statement or fragment. | |
| created_by | number | not null | |
| creation_date | date | not null | |
| last_updated_by | number | not null | |
| last_update_date | date | not null |
| Index | Type | Columns |
|---|---|---|
| xxen_upload_sqls_u1 | unique | sql_id |
| xxen_upload_sqls_u2 | unique | report_id, sql_type, anchor |
Generated from Blitz Report 3.3.7 on .