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
841 reports
| Description | Download | ||
|---|---|---|---|
| ECC Admin - Concurrent Programs | List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note KA980 https://support.oracle.com/support/?kmContentId=11154162
The report includes all currently scheduled request_ids and responsibilities for incremental and full loads, to check which ones are already scheduled.
The short code can be used as multiple parameter value entry in other reports, e.g. https://www.enginatics.com/reports/fnd-access-control/ to see which responsibilities or users have access to schedule them, or… full description | Enginatics |   |
| ECC Admin - Data Load Tracking | Enterprise Command Center data load run history, including status, the load SQL and possible error messages in case of failures.
For description of the load process, see ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ | Enginatics, R12 only | |
| ECC Admin - Data Sets | Enterprise Command Centers applications with data sets and load rule DB procedure names for incremental, full and metadata load.
For description of the load process, see ECC Concurrent Programs https://www.enginatics.com/reports/ecc-concurrent-programs/ | Enginatics, R12 only | |
| ECC Admin - Metadata Attributes | Enterprise Command Centers metadata attributes | Enginatics, R12 only | |
| ENG Engineering Change Orders | Engineering change orders (ECOs) with one row per revised item: the ECO header with its type, status, approval status, priority, reason, requestor and dates, and the revised item with its new revision, effectivity, implementation and cancellation dates, use-up item and material disposition. An ECO without revised items is listed once with blank revised item columns.
Change types are those based on the Change Order change category, as on the Engineering Change Orders form.
Show Component Changes adds one row per component the revised item adds, changes or disables. Old Quantity and Old Op… full description | Enginatics | |
| Enginatics Blitz Reports and Uploads | Catalog of standard Enginatics uploads and reports.
All Enginatics report details can be seen here: https://www.enginatics.com/library/?pg=1&category[]=Enginatics | Enginatics | |
| FA Additions By Source | Application: Assets
Source: Additions By Source Report
Short Name: FASASSBS | Assets Enginatics | |
| FA Asset Additions | Imported from BI Publisher
Description: Asset Additions Report
Application: Assets
Source: Asset Additions Report (XML)
Short Name: FAS420_XML
DB package: FA_FAS420_XMLP_PKG | Assets Enginatics | |
| FA Asset Book Details | FA asset books with asset depreciation summary and financial transaction values.
Using parameters 'Show Calendar', 'Show Alternative Ledgers', 'Show Accounting Rules', 'Show Natural Accounts' shows the setup details of book controls. | Assets Enginatics | |
| FA Asset Cost | Asset Costs Summary/Detail Report
Equivalent to Oracle Standard Reports:
Cost Summary Report
Cost Detail Report
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Asset Inventory | Imported Oracle standard asset inventory report
Source: Asset Inventory Report (XML)
Short Name: FAS410_XML
DB package: FA_FAS410_XMLP_PKG | Assets Enginatics | |
| FA Asset Reclassification | Application: Assets
Source: Asset Reclassification Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS740_XML
DB package: FA_FAS740_XMLP_PKG | Assets Enginatics, R12 only | |
| FA Asset Register | Application: Assets
Source: Asset Register Report (XML)
Short Name: FAS600_XML
DB package: FA_FAS600_XMLP_PKG | Assets Enginatics | |
| FA Asset Retirements | Imported from BI Publisher
Description: Asset Retirements Report
Application: Assets
Source: Asset Retirements Report (XML)
Short Name: FAS440_XML
DB package: FA_FAS440_XMLP_PKG
Note: as in the Oracle report, a retirement is listed only once its gain and loss accounting entries exist. | Assets Enginatics | |
| FA Asset Summary (Germany) | Description: Asset Summary Report (Germany)
Application: Assets
This Blitz Report has been extended to allow it to be run across multiple Ledgers and/or Asset Books.
Source: Asset Summary Report (Germany)
Short Name: FASSUMRPT
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Asset Transfers | Asset transfers between distributions (employee, expense account and location), one row per transfer and distribution side.
A transfer closes the From distributions and creates the To distributions. Units, cost and reserve are signed, negative on the From side and positive on the To side, so a transfer nets to zero and a sum by cost center, account or location shows what moved in and out.
Cost, reserve, depreciation expense and revaluation reserve are the amounts the transfer moved between the distributions in the selected book, taken from its accounting adjustments. A back-dated transfer… full description | Assets Enginatics | |
| FA CIP Cost | CIP Costs Summary/Detail Report
Equivalent to Oracle Standard Reports:
CIP Summary Report
CIP Detail Report
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Cost Adjustments | Imported from BI Publisher
Description: Cost Adjustments Report
Application: Assets
Source: Cost Adjustments Report (XML)
Short Name: FAS840_XML
DB package: FA_FAS840_XMLP_PKG | Assets Enginatics | |
| FA Depreciation Projection | Based on Oracle's 'Depreciation Projection Report' FASPRJ
Uses custom DB package call XXEN_FA_FAS_XMLP to launch Oracle standard Depreciation Projection concurrent FAPROJ. The data generation is explained in note:
How Does FA Depreciation Projections Handle Table FA_PROJ_INTERIM_XXX or FA_PROJ_INTERIM_REP ? (KB730395) https://support.oracle.com/support/?kmContentId=1607626 | Assets Enginatics, R12 only | |
| FA Depreciation Reserve | Depreciation Reserve Summary/Detail Report
Equivalent to Oracle Standard Reports:
Reserve Summary Report
Reserve Detail Report
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Journal Entry Reserve Ledger | Imported Oracle standard journal entry reserve ledger report. The Asset Account column and the template 'Pivot: Account Reconciliation Reserve Ledger' cover the Account Reconciliation Reserve Ledger Report (FAS403), which shows the same reserve ledger grouped by asset account instead of depreciation expense account.
Source: Journal Entry Reserve Ledger Report (XML)
Short Name: FAS400_XML
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Revaluation Reserve | Revaluation Reserve Summary/Detail Report
Equivalent to Oracle Standard Reports:
Revaluation Reserve Summary Report
Revaluation Reserve Detail Report
DB package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FA Tax Reserve Ledger | Imported Oracle standard tax reserve ledger report
Source: Tax Reserve Ledger Report (XML)
Short Name: FAS480_XML
DB package: FA_FAS480_XMLP_PKG
Custom Package: XXEN_FA_FAS_XMLP | Assets Enginatics, R12 only | |
| FND Application Context File | Context XML files retrieved from the database | System Enginatics | |
| FND Applications | Shows all applications, their installation status, correponding database schema, application top name and audit status | System Enginatics | |
| FND Attached Documents | FND attachments stored in the fnd_lobs table and their corresponding application entity e.g. sales orders that they are attached to. | System Enginatics | |
| FND Attachment Functions | FND attachment functions, their category assignments, forms blocks and block entities | System Enginatics | |
| 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 columns 'Audit Table Name' and 'Audit Column Exists'.
Oracle's standard audit trail works with a concurrent program 'AuditTrail Update Tables', which creates a set of database triggers for updates, inserts and deletes. The triggers write table changes to an audit table with the name: audited_table_A.
The whole audit trail setup process is describe in this blog:… full description | System Enginatics | |
| 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. | System Enginatics | |
| 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 single row. | System Enginatics | |
| 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 and Concurrent->Manager->Define | System Enginatics | |
| FND Concurrent Program Incompatibilities | Concurrent Program Incompatibilities | System Enginatics | |
| FND Concurrent Programs and Executables | Concurrent programs, executables and program parameters | System Enginatics | |
| 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 between the requested start date and conflict release date.
This might not work 100% (it doesn't consider request set conflicts yet), but should give a good indication of most conflicting scenarios. | System Enginatics | |
| FND Concurrent Requests | Running, scheduled and historic concurrent requests including phase, status, parameters, schedule, timing, delivery and output option information.
For performance analysis of running requests, the report contains sid, currently executed sql_id and sql_text and distribution of wait time on different wait classes.
Use parameter 'Scheduled or Running' to get a list of all currently scheduled or running requests. | System Enginatics | |
| FND Concurrent Requests Summary | Concurrent programs sorted by the sum of their historic execution times | System Enginatics | |
| 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 accounting flexfield combinations that fail an enabled and currently active rule instead, one row per combination and violated element. A combination outside every include range of a rule is shown against element type Include with blank ranges, a combination inside an exclude range with that exclude range. Oracle validates a combination only when it is created, so combinations created before a rule was defined or tightened stay enabled… full description | System Enginatics | |
| FND Data Groups | System Enginatics | | |
| 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 enabled.
Debug and trace settings left on in production slow down processing and fill the FND_LOG_MESSAGES table and the database trace directory.
Profile options are selected by internal names containing DEBUG or TRACE, excluding file, directory and module settings, plus FND: Debug Log Enabled and Initialization SQL Statement - Custom. Values N, No, F, 0, Off and None are not shown. | System Enginatics | |
| FND Descriptive Flexfield Table Columns | Shows all active descriptive flexfield table columns. | System Enginatics | |
| FND Descriptive Flexfields | Descriptive flexfields table, context, column and validation information | System Enginatics | |
| FND Document Categories | Document categories used by document sequence assignments. | System Enginatics | |
| FND Document Sequence Assignments | Document sequence asssignments to application tables, ledgers and categories, including sequence details such as database sequence name and last seqeunce number. | System Enginatics | |
| FND Document Sequences | Document sequence details including database sequence name and last seqeunce number. | System Enginatics | |
| 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 validate the hierarchy for nodes where the child range does not include a single child value.
The query is based on a treewalk through table fnd_flex_value_norm_hierarchy, which contains one record for every parent node, and a range_attribute column to indicate if the child value low/high range should match either parent nodes or child values.
While table fnd_flex_value_norm_hierarchy contains one record for each hierarchy node, table… full description | System Enginatics | |
| 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 responsibilities that the rule is assigned to. | System Enginatics | |
| FND Flex Value Sets, Usages and Values | Value sets and values including usages, validation type, format type, validation table, columns etc. | System Enginatics | |
| 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 which account segment values are not included in any (or a specific) hierarchy yet.
In EBS R12.2., there is new flexfield value security in place, which would require the UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE role to maintain flexfield values.
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',… full description | System Enginatics | |
| FND Form Functions | System Enginatics | | |
| FND Forms Personalizations | Forms personalizations and actions | System Enginatics | |
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…