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
837 reports
| Description | Download | ||
|---|---|---|---|
| FND Gather Statistics History | History of Oracle EBS statistics gathering (FND_STATS) per schema, table, index or column, with start time, end time and duration.
Gather Schema Statistics and Gather Table Statistics record their runs here. With the default history mode Last Run, each object keeps only its latest gathering. | System Enginatics |   |
| FND Help Documents and Targets | System Enginatics | | |
| FND Histogram Columns | Data from table fnd_histogram_cols, which Oracle uses to identify columns which are expected to have highly skewed data, for example a status column having a large number of closed, but only a small number of open records.
The Gather Schema and Gather Table Statistics concurrent programs use this information to create additional histrogram statistics for these columns.
To add a column to this table, use the following API:
declare
l_table_name varchar2(30):='AP_INVOICES_ALL';
l_column_name varchar2(30):='ORG_ID';
begin
for c in (
select
fpi.application_id
from
fnd_oracle_userid fou,… full description | System Enginatics | |
| FND Key Flexfields | Key flexfields table, structure, column and validation information | System Enginatics | |
| FND Languages | System Enginatics | | |
| FND Log Messages | System Enginatics | | |
| FND Lookup Search | Finds the best matching lookup_type for a given set of lookup_codes in a custom application base table.
Example:
Coding a sql for ap suppliers, the value of column vendor_type_lookup_code should get translated to the user visible meaning instead of the code.
The lookup_type used for translation can be found by this report entering table name AP_SUPPLIERS and column name VENDOR_TYPE_LOOKUP_CODE.
The output contains a column SQL_TEXT which can be used directly in the sql where clause:
=flv.lookup_code(+) and
flv.lookup_type(+)='VENDOR TYPE' and
flv.view_application_id(+)=201… full description | System Enginatics | |
| FND Lookup Values | Lookup types and values, for example to find a lookup type for a particular lookup code value or meaning. | System Enginatics | |
| FND Menu Entries | System Enginatics | | |
| FND Messages | System Enginatics | | |
| FND Nodes | FND_NODES stores information about the nodes that are used to
install and run Oracle Application at your site. Each row includes
the name of the node and the platform code. The column name
NODE_NAME is the given name used to refer to the machine or node
at the site. The column PLATFORM_CODE specifies the make of the
machine or node (e.g. DEC VMS, Sequent Ptx, etc.). This
information is used to associate a concurrent manager with a
specific node to support distributed processing. | System Enginatics | |
| FND OAF Personalizations | Oracle Application Framework (OAF) page personalizations stored in the MDS repository (JDR tables), with the personalization level and the page or region they apply to.
Level Name shows the responsibility, user, operating unit or function, or the stored level value where it is not an id, for example for localization or portlet.
A personalization document can be exported with the JDR_UTILS.printDocument procedure or the XMLExporter utility for migration to another instance. | System Enginatics | |
| FND Profile Option Values | Profile option values on all setup levels.
Unlike Oracle's SQL script from note 201945.1, this report also shows the user visible profile option value in addition to the internal system profile option value. | System Enginatics | |
| FND Profile Options | FND profile option definition | System Enginatics | |
| FND Request Groups | FND request groups and their assigned units, such as concurrent programs, request sets or applications | System Enginatics | |
| FND Responsibilities | Active responsibilites with active user count and related setup information such as menus, data access sets, security profiles and associated ledgers and operating units. | System Enginatics | |
| FND Responsibility Access | Responsibilites and related data such as users, concurrent programs, menus, functions, forms, data access set and security profiles and associated ledgers and operating units.
This report basically answers all system access related questions. It shows which users or responsibilities have acess to which functions, forms, concurrent programs, ledgers, operating units or inventory organizations.
Depending on parameter selection, this report shows for example:
- responsibilities and related menus and request groups
- responsibilities, menus, included forms, functions and their full menu… full description | System Enginatics | |
| FND Responsibility Menu Exclusions | Responsibility menu exclusions | System Enginatics | |
| FND Role Hierarchy | User Management (UMX) role hierarchy to manage role-based access control (RBAC).
When run for a specified role, the report shows all hierarchies that contain or lead to inheriting that role. | System Enginatics | |
| FND Roles | Report of all User Management (UMX) roles, including number of active users for each role to help managing role-based access control (RBAC) | System Enginatics | |
| FND Rollup Groups | Flex value sets with rollup groups (FND Flex Hierarchies) | System Enginatics | |
| FND SOA Runtime Error | System Enginatics, R12 only | | |
| FND User Login History | Audit history of application user logins.
EBS user logon audit is controlled by profile 'Sign-On:Audit Level'.
The most detailed audit level setting is 'FORM'.
Unfortunately, this audit tracks access to individual forms only, but not to different JSPs (HTML / OAF / ADF Pages).
As a workaround, the report SQL also joins to icx_sessions, which contains a record for each login (in fact, it also stores a record for each access to the login page before login. These records are marked with guest='Y').
The function retrieved from icx_session however, just shows the latest OAF function accessed by… full description | System Enginatics | |
| FND User Login Page Favorites | User's HTML favourites from table icx_custom_menu_entries | System Enginatics | |
| FND User Preferences | User preferences from table fnd_user_preferences | System Enginatics | |
| FND User Responsibilities | Similar to report FND Responsibility Access, but also shows inactive / end dated user responsibilities while FND Access Control shows currently active assigned responsibilities only.
Same as Oracle's 'Active Users' report. | System Enginatics | |
| FND User Roles | Report for User Management (UMX) roles and their assigned users to manage role-based access control (RBAC).
User uoles are maintained from the User Management responsibility, but you would require the UMX|SECURITY_ADMIN role for this. If you do not have this role but apps DB access, you can add it from the backend:
begin
wf_local_synch.propagateuserrole(
p_user_name=>'ANDY.HAACK',
p_role_name=>'UMX|SECURITY_ADMIN'
);
commit;
end; | System Enginatics | |
| FND Users | Listing of all EBS users, their status, responsibility count, and if they were using blitz reports | System Enginatics | |
| 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 | |
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…