Oracle EBS Application Object Library Reports
63 ready-to-run SQL reports for Oracle E-Business Suite Application Object Library, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Application Object Library tables in these reports are fnd_application_vl, fnd_concurrent_programs_vl, fnd_responsibility_vl, hr_all_organization_units_vl, fnd_form_functions_vl, fnd_flex_value_sets.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Application Object Library SQL Reports
| Report | Description |
|---|---|
| FND Application Context File | Context XML files retrieved from the database |
| FND Applications | Shows all applications, their installation status, correponding database schema, application top name and audit status |
| FND Attached Documents | FND attachments stored in the fndlobs table and their corresponding application entity e.g. sales orders that they are attached to. |
| FND Attached Documents (Operating Unit Secured) | Attachments of operating unit striped documents: sales orders and lines, purchase orders, lines, shipments and releases, requisitions, AP invoices, AR… |
| FND Attachment Functions | FND attachment functions, their category assignments, forms blocks and block entities |
| FND Audit Setup | FND audit setup validation report including audit groups, audit tables and audited columns, and a check if the corresponding audit tables are created in… |
| FND Audit Table Changes by Column | Reports all changes to an audited application table. The report has one row per audit transaction and audited column showing the old and new audit column value. |
| FND Audit Table Changes by Record | Reports all changes to an audited application table. The report has one row per audit transaction showing the old and new values for all audited columns in a… |
| FND Concurrent Managers | Concurrent managers’ setup and current status, e.g. processes and requests running, pending etc. Shows the same information as Concurrent->Manager->Administer… |
| FND Concurrent Program Incompatibilities | Concurrent Program Incompatibilities |
| FND Concurrent Programs and Executables | Concurrent programs, executables and program parameters |
| FND Concurrent Request Conflicts | Lists concurrent requests that were held by the conflict resolution manager and shows their conflicting / blocking requests which were running at the time… |
| FND Concurrent Requests | Running, scheduled and historic concurrent requests including phase, status, parameters, schedule, timing, delivery and output option information. For… |
| FND Concurrent Requests Summary | Concurrent programs sorted by the sum of their historic execution times |
| FND Cross-Validation Rules | Cross-validation rules of key flexfield structures, one row per rule element (include or exclude range). Show Violating Combinations lists the enabled… |
| FND Data Groups | |
| FND Debug and Trace Settings | Profile option values that switch on debug logging, SQL trace or a custom initialization SQL statement, at any level, and concurrent programs with SQL trace… |
| FND Descriptive Flexfield Table Columns | Shows all active descriptive flexfield table columns. |
| FND Descriptive Flexfields | Descriptive flexfields table, context, column and validation information |
| FND Document Categories | Document categories used by document sequence assignments. |
| FND Document Sequence Assignments | Document sequence asssignments to application tables, ledgers and categories, including sequence details such as database sequence name and last seqeunce… |
| FND Document Sequences | Document sequence details including database sequence name and last seqeunce number. |
| FND FNDLOAD Object Transfer | Generates FNDLOAD download and upload linux commands for automated setup transfer between environments |
| FND Flex Hierarchies (Rollup Groups) | Flex value sets with rollup groups |
| FND Flex Value Hierarchy | Flexfield value hierarchy showing a hierarchical tree of parent and child relations and child ranges. Parameter ‘Parents without Child only’ can be used to… |
| FND Flex Value Security Rules | Flexfield value security rules, rule elements (included or excluded flexfield value ranges), flexfields where the secured value set is used and… |
| FND Flex Value Sets, Usages and Values | Value sets and values including usages, validation type, format type, validation table, columns etc. |
| FND Flex Values | Report for all flex values and the hierarchies they are included in. Column ‘Hierarchy Position’ can be used to validate your account hierarchy setup and check… |
| FND Form Functions | |
| FND Forms Personalizations | Forms personalizations and actions |
| FND Gather Statistics History | History of Oracle EBS statistics gathering (FNDSTATS) per schema, table, index or column, with start time, end time and duration. Gather Schema Statistics and… |
| FND Help Documents and Targets | |
| FND Histogram Columns | Data from table fndhistogramcols, which Oracle uses to identify columns which are expected to have highly skewed data, for example a status column having a… |
| FND Key Flexfields | Key flexfields table, structure, column and validation information |
| FND Languages | |
| FND Lobs | Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc. |
| FND Log Messages | |
| FND Lookup Search | Finds the best matching lookuptype for a given set of lookupcodes in a custom application base table. Example: Coding a sql for ap suppliers, the value of… |
| FND Lookup Values | Lookup types and values, for example to find a lookup type for a particular lookup code value or meaning. |
| FND Lookup Values Comparison between environments | Compares lookup values between the local and a remote database environment |
| FND Menu Entries | |
| FND Menus | Lists all Oracle E-Business Suite menus (FNDMENUS) together with the number of responsibilities that reference each menu. The Responsibility Count column shows… |
| FND Messages | |
| FND Nodes | FNDNODES 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… |
| 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… |
| 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… |
| FND Profile Options | FND profile option definition |
| FND Request Groups | FND request groups and their assigned units, such as concurrent programs, request sets or applications |
| FND Responsibilities | Active responsibilites with active user count and related setup information such as menus, data access sets, security profiles and associated ledgers and… |
| 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… |
| FND Responsibility Menu Exclusions | Responsibility menu exclusions |
| 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… |
| 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) |
| FND Rollup Groups | Flex value sets with rollup groups (FND Flex Hierarchies) |
| FND SOA Runtime Error | |
| FND Tables and Columns | Registered FND tables, columns, primary keys and their flexfields |
| 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’… |
| FND User Login Page Favorites | User’s HTML favourites from table icxcustommenuentries |
| FND User Login Summary | Active application user count per month |
| FND User Preferences | User preferences from table fnduserpreferences |
| 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… |
| 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… |
| FND Users | Listing of all EBS users, their status, responsibility count, and if they were using blitz reports |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH