Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
46 reports
| Description | Download | ||
|---|---|---|---|
| GL Account Analysis | Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency.
Show Open/Close Balances adds a ledger currency opening balance row for the first selected period and a closing balance row for the last selected period per account combination, marked as Balance in the Record Type column. Balance rows follow the ledger, period and account filters, not journal level filters such as Source or Category. The chosen value controls whether balance rows appear only for accounts with journal activity in… full description | General Ledger Enginatics |   |
| GL Balance | Summary GL report including one line per accounting period for each account segment level, including product code, with amounts for opening balance, debits, credits, change amount, ending balance. | General Ledger Enginatics | |
| GL Balance (pivot) | Summary GL report including one line per account segment level, including product code, with opening balance, total transaction amount per month for each period selected, and closing balance (trial balance). | General Ledger Enginatics | |
| GL Balance by Account Hierarchy | Summary GL report including one line per GL account. This report has multiple collapsible/expandable summary levels based on the GL account hierarchy, with starting balance, total amount per month, ending total and YTD balance.
Parameter 'Additional Segment' can be used to include additional segments e.g. cost center or balancing segment. | General Ledger Enginatics, R12 only | |
| GL Chart of Accounts Mapping Rules | Lists the segment mapping rules and code combination mappings defined for a Global Consolidation System (GCS) chart of accounts mapping. Converted from the Oracle BI Publisher report 'Chart of Accounts - Mapping Rules (XML)' (GLXCOCRR_XML). | General Ledger Enginatics, R12 only | |
| GL Code Combinations | Parameter 'Show Misclassified Accounts' can be used to identify code combinations, which have a different account type than their flexfield value setup.
There is an Oracle note explaining the implications of correcting these:
R12: Troubleshooting Misclassified Accounts in General Ledger (KB706390) https://support.oracle.com/support/?kmContentId=872162 | General Ledger Enginatics | |
| GL Daily Rates | Daily currency conversion rates | General Ledger Enginatics | |
| GL Data Access Sets | Master data report showing ledger security.
Listing of all GL data access sets and the ledgers or ledger sets that each access set can access.
Show Responsibilities adds one row per responsibility using the access set through the GL: Data Access Set profile set at responsibility or application level. Responsibilities inheriting the site level value are not listed.
Summary Accounts Allowed shows Yes when the responsibility's menu grants the Summary Accounts form and the access set gives full read and write access to the whole ledger. Otherwise the form's Ledger list does not offer the ledger… full description | General Ledger Enginatics, R12 only | |
| GL FSG Reports | Financial Statement Generator reports | General Ledger Enginatics, R12 only | |
| GL FSG Row Orders | Financial Statement Generator row order listing | General Ledger Enginatics, R12 only | |
| GL Financial Statement and Drilldown (FSG) | The GL Financial Statement and Drilldown (FSG) Report empowers users to generate comprehensive reports on financial balances while providing detailed insights through drilldown capabilities. This tool allows users to link Excel cells directly to Oracle data via built-in functions, ensuring that data can be refreshed as needed to reflect the most up-to-date information.
Key features include:
1. Balance and Detail Reporting: Generate high-level balance reports and drill down into the details, including journal entries and subledger transactions.
2. Oracle Data Integration: Seamlessly link Excel… full description | General Ledger Enginatics | |
| GL Header Categories Summary | Master data report showing ledger, category and source definitions across multiple ledgers. | General Ledger Enginatics | |
| GL Journal Upload | GL Journal Upload
Templates are provided for the following Journal Types
- Functional Actuals
- Foreign Actuals
- Budget Journals
- Encumbrance Journals
Submit for Approval
---------------------------
Imported Journals requiring approval can be submitted for approval after import if they are eligble.
Submit Journal Post
---------------------------
Imported Journals can be submitted for immediate posting after import if they are eligible.
In order to submit journals for posting, the current responsibility must have access to post journals. | General Ledger Enginatics, Upload | |
| GL Journals | GL batches and journals report, including amounts and attachments. One row per journal line.
The Knocked Off flag marks journal lines whose equal and opposite accounted amounts on the same account combination and batch fully cancel to zero; Exclude Knocked Off Journal Lines removes them from the output.
Exclude Reversed Journals removes a reversal and its reversed journal only when both fall within the selected period range, so a reversal whose original journal lies outside the range stays visible and the period totals remain complete.
Show Open/Close Balances adds a ledger currency… full description | General Ledger Enginatics | |
| GL Ledger Sets | Master data report showing GL ledger sets and included ledgers. | General Ledger Enginatics, R12 only | |
| GL Ledgers and Legal Entities | Master data report showing ledger set, ledger name, ledger category, currency, legal entity, and balancing segment across all ledgers and legal entities. | General Ledger Enginatics, R12 only | |
| GL Ledgers and Organizations | Master data report showing business group, ledger set, ledger, ledger category, currency, chart of accounts name, operating unit, organization code, country, legal entity, ledger id, chart of accounts code. It also includes support elements such as chart of accounts ID, operating unit ID, and organization ID. | General Ledger Enginatics | |
| GL Oracle FSG Converter | ** This report is used by the GL Financial Statement and Drilldown report, to migrate financial statement reports from Oracle FSG. **
The GL Oracle FSG Converter is used for migration of financial statement reports from Oracle Financial Statement Generator (FSG) into the GL Financial Statement and Drilldown (FSG) report. This converter simplifies the process of transferring the existing Oracle FSG reports, allowing users to leverage advanced reporting and drilldown capabilities with minimal setup.
This version supports DB versions above 12c. To apply the converter, the profile 'Blitz FSG… full description | General Ledger Enginatics | |
| GL Periods | Geleral ledger calendars and accounting periods | General Ledger Enginatics, R12 only | |
| GL Recurring Journal and Budget Formulas | Lists Oracle General Ledger recurring journal and budget formula definitions - batches, journal entries, lines and each line's formula steps - with the account code combinations exploded into one column per Accounting Flexfield segment.
Each row is one formula step. The line account, which is the account the generated journal posts to, and the formula account, which is the account a step reads a balance from, are both shown segment by segment. Company, Department, Account, Sub-Account and the remaining segments of your chart of accounts therefore become individual columns that can be sorted… full description | General Ledger Enginatics | |
| GL Summary Templates | Master data report showing GL summary and concatenation templates based on ledger, company, department, account, sub-account, and product segments, and including information for the group, ledger set, ledger, ledger category, currency and chart of accounts. | General Ledger Enginatics | |
| GL Trial Balance - Detail | Imported from Concurrent Program
Description: Detail Trial Balance (XML)
Application: General Ledger
Source: Trial Balance - Detail (XML)
Short Name: GLTRBALD
DB package: | General Ledger Enginatics, R12 only | |
| GL effective vs accounting vs period start and end date comparison | For developers to understand the GL data: Shows the relationship between effective, accounting and period start and end dates by counting how many records exist where the effective date is before or after the accounting date. | General Ledger Enginatics, R12 only | |
| XLA Distribution Links Summary | Summary of subledger distribution links for developers to understand which source_ids are populated for which subledger table sources.
The link to subledger tables for different source_distribution_type values is described e.g. MOS Doc IDs for:
AP KB202448 https://support.oracle.com/support/?kmContentId=813968
FA KB721213 https://support.oracle.com/support/?kmContentId=2002464
PA KB160029 https://support.oracle.com/support/?kmContentId=1274575
For GMF, there is
AP and PO Accrual Reconciliation Report Debugging from OPM Financials KB775263… full description | General Ledger Enginatics, R12 only | |
| XLA Entity ID Mappings | Shows the column link between table xla_transaction_entities and subledger source tables such as and AP invoice_id or AR customer_trx_id, used when writing queries linking GL to subledger such as the GL Account Analysis report www.enginatics.com/reports/gl-account-analysis/ | General Ledger Enginatics, R12 only | |
| XLA Entity Types and Event Class Attributes | Subledger event types and their attributes, for example reporting view | General Ledger Enginatics, R12 only | |
| XLA OPM Event Type Summary | General Ledger Enginatics, R12 only | | |
| XLA Subledger Accounting Rules Detail Listing | Lists the complete Subledger Accounting rule setup in one flat grid, combining the seven separate queries of the Oracle standard XLASARDLR Subledger Accounting Rules Detail Listing BI Publisher report.
There is one row per journal line type and account derivation rule priority, so the accounting method, application accounting definition, event class and type, journal line definition, journal line type, segment, derivation rule, its priority, condition and derived value all sit on the same row and can be filtered and pivoted directly.
Journal line type and account derivation rule conditions… full description | General Ledger Enginatics, R12 only | |
| XLA Subledger Period Close Exceptions | Imported from BI Publisher
Description: This report extracts all those events which are either untransferred or are not accounted for.
Application: Subledger Accounting
Source: Subledger Period Close Exceptions Report
Short Name: XLAPEXRPT
DB package: XLA_PERIOD_CLOSE_EXP_PKG | General Ledger Enginatics, R12 only | |
| GL Account Analysis (Drilldown) | ** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. **
Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency.
For drilldown to the transaction screen please ensure the column View Transaction is present in the Displayed Columns
View Transaction | General Ledger Enginatics, R12 only | |
| GL Account Analysis (Drilldown) (with inventory and WIP) | ** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. **
Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This also has inventory and WIP details. | General Ledger Enginatics, R12 only | |
| GL Account Analysis 11g | Backwards compatible version (for 11g databases) of the detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. | General Ledger Enginatics | |
| GL Account Distribution Analysis | Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency.
The report includes VAT tax codes and rates for AR and AP transactions. | General Ledger Enginatics, R12 only | |
| GL Account Upload | This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations. | General Ledger Enginatics, Upload | |
| GL Account Upload 11i | This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations. | General Ledger Enginatics, Upload | |
| GL Balance Drilldown | Shows GL balance details by code combination. Uses gl_balances for standard queries, gl_je_lines when filtering by journal source/category or using JED balance types. | General Ledger Enginatics | |
| GL Balances (Drilldown) | ** This report is used by the GL Financial Statement and Drilldown report, to show Balance details per code combination. **
Shows GL balance amounts (Opening Balance, Debit, Credit, Net, Closing Balance) grouped by code combination, with drill-to-journal capability.
Supports all balance types: PTD, YTD, QTD, PJTD, FYS, FYE, CTD.
The Drill To Journal column allows further drilldown into journal details. | General Ledger Enginatics | |
| GL Budget Amounts Upload | GL Budget Amounts Upload
===================
This can be used to upload GL Budget Amounts | General Ledger Enginatics, Upload | |
| GL Daily Rates Upload | GL Daily Rates Upload
==================
Use this upload to upload new or update existing GL Daily Exchange Rate Conversions.
If exchange rates do not already exist for the entered data, they will be created.
If exchange rates do already exist for the entered data, they will be updated. | General Ledger Enginatics, Upload | |
| GL Journals (Drilldown) | ** This report is used by the GL Financial Statement and Drilldown report, to show Journal details. **
GL batches and journals report, including amounts and attachments.To enable next level drilldown below columns should be present in Display columns of the custom templates
Drill To Subledger
Drill To Journal Attachment
Drill To Full Journal | General Ledger Enginatics, R12 only | |
| GL Journals (Drilldown) 11g | GL batches and journals report, including amounts and attachments.This report is used by the GL Financial Statement and Drilldown report, to show subledger details. | General Ledger Enginatics | |
| GL Journals 11i | GL batches and journals report, including amounts and attachments | General Ledger Enginatics | |
| GL Oracle FSG Converter 11g | ** This report is used by the GL Financial Statement and Drilldown report, to migrate financial statement reports from Oracle FSG. **
The GL Oracle FSG Converter is used for migration of financial statement reports from Oracle Financial Statement Generator (FSG) into the GL Financial Statement and Drilldown (FSG) report. This converter simplifies the process of transferring the existing Oracle FSG reports, allowing users to leverage advanced reporting and drilldown capabilities with minimal setup.
This version supports DB versions 11g and 12c. To apply the converter, the profile 'Blitz FSG… full description | General Ledger Enginatics | |
| GL Period Status | Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an accounting period should be opened, use the CAC Accounting Period Status report, as it has more reporting options and features. | General Ledger Enginatics | |
| GL Setup Upload | Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options.
Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is… full description | General Ledger Enginatics, R12 only, Upload | |
| GL Summary Account Upload | This upload can be used to import Summary Account Templates. | General Ledger Enginatics, R12 only, Upload | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…