Skip to content
  • Contact
  • Support
  •  Demo Login
Enginatics Logo
  • Blitz Report
    • Features
    • Pricing
    • Download
    • FAQ
    • Tutorials
    • User Guide
    • Installation Guide
    • Toolkits
      • Cost Accounting
      • Data Management
      • DBA
      • Metrics
      • Operations
      • Setup & Support
    • Changelog
  • Supply Chain Hub
    • Features
    • Download
    • Installation Guide
    • Seeded Reports
  • Library
    • lib items
      Advanced Pricing
      QP Customer Pricing Engine RequestQP Price Lists
      Advanced Supply Chain Planning
      MSC ExceptionsMSC Horizontal PlanMSC Pegging HierarchyMSC Plan OrdersMSC Vertical Plan
      Application Object Library
      FND Access ControlFND Access Control 11iFND Application Context FileFND ApplicationsFND Attached DocumentsFND Attachment FunctionsFND Audit SetupFND Audit Table Changes by ColumnFND Audit Table Changes by RecordFND Concurrent ManagersFND Concurrent Program IncompatibilitiesFND Concurrent Programs and ExecutablesFND Concurrent Programs and Executables 11iFND Concurrent Request ConflictsFND Concurrent Requests
      FND Concurrent Requests 11iFND Concurrent Requests SummaryFND Descriptive FlexfieldsFND FNDLOAD Object TransferFND Flex Hierarchies (Rollup Groups)FND Flex Value HierarchyFND Flex Value Security RulesFND Flex Value Sets, Usages and ValuesFND Flex ValuesFND Form FunctionsFND Forms PersonalizationsFND Help Documents and TargetsFND Key FlexfieldsFND LanguagesFND Lobs
      FND Log MessagesFND Lookup SearchFND Lookup ValuesFND Menu EntriesFND Profile Option ValuesFND Profile OptionsFND Responsibility Menu ExclusionsFND Role HierarchyFND RolesFND Tables and ColumnsFND User Login HistoryFND User Login Page FavoritesFND User Login SummaryFND User ResponsibilitiesFND User Roles
      FND Users
      Applications DBA
      AD Applied PatchesAD Applied Patches 11iAD Applied Patches R12.2
      Assets
      FA Additions By SourceFA Asset AdditionsFA Asset Book DetailsFA Asset CostFA Asset ImpairmentsFA Asset InventoryFA Asset RetirementsFA Asset Summary (Germany)FA CIP CostFA Cost AdjustmentsFA Depreciation ProjectionFA Depreciation ReserveFA Journal Entry Reserve LedgerFA Revaluation ReserveFA Tax Reserve Ledger
      Bills of Material
      BOM Bill of Material StructureBOM Calendar ExceptionsBOM Routings
      Blitz Report
      Blitz Report Application CategoriesBlitz Report AssignmentsBlitz Report Category AssignmentsBlitz Report Column TranslationsBlitz Report Deletion HistoryBlitz Report Execution HistoryBlitz Report Execution SummaryBlitz Report LOV SQL ValidationBlitz Report LOVsBlitz Report License User CountBlitz Report License UsersBlitz Report Parameter Custom LOV ValidationBlitz Report Parameter Default ValuesBlitz Report Parameter Table Alias ValidationBlitz Report Parameter Uniqueness Validation
      Blitz Report SQL ValidationBlitz Report TemplatesBlitz Report User HistoryBlitz Report VPD Policy SetupBlitz Reports
      CRM Foundation
      JTF Grid Datasources
      Capacity
      CRP Available ResourcesCRP Resource Plan
      Cash Management
      CE Bank Account BalancesCE Bank Statement Import ExecutionCE Bank Statement and ReconciliationCE Bank Transaction Codes ListingCE Cash in TransitCE Cleared TransactionsCE General Ledger Cash Account UsageCE General Ledger ReconciliationCE Transactions Available for Reconciliation
      Contracts Core
      OKC Contract Lines Summary
      Cost Accounting
      CAC Accounting Period StatusCAC Accounting Period Status (Financials)CAC Cost vs. Planning Item ControlsCAC ICP PII Inventory and Intransit Value (Period-End)CAC Inventory Out-of-BalanceCAC Inventory and Intransit Value (Period-End)CAC Inventory to G/L Reconciliation (Restricted by Org Access)CAC Inventory to G/L Reconciliation (Unrestricted by Org Access)CAC Item Cost SummaryCAC Item vs. Component Include in Rollup ControlsCAC Margin Analysis Account SummaryCAC Margin Analysis SummaryCAC Material Account SummaryCAC Material Account Summary No SLACAC Receiving Account Detail No SLA
      CAC Receiving Account SummaryCAC Receiving Account Summary No SLACAC User-Defined and Rolled Up CostsCAC WIP Account SummaryCAC WIP Account Summary No SLA
      Cost Management
      CST AP and PO Accrual ReconciliationCST COGS Revenue MatchingCST Cost GroupsCST Detailed Item CostCST Inventory Value - Multi-Organization (Item Costs)CST Inventory Value Report - by Subinventory (Item Cost)CST Item Cost ReportsCST Miscellaneous Accrual ReconciliationCST Period Close Subinventory ValueCST Period Close Subinventory Value SummaryCST Supply Chain Indented Bills of Material CostCST Uninvoiced Receipts
      Database Administration
      DBA AWR Active Session HistoryDBA AWR Blocking Session SummaryDBA AWR Latch SummaryDBA AWR Latch by TimeDBA AWR PGA HistoryDBA AWR SQL Execution Plan HistoryDBA AWR SQL Performance SummaryDBA AWR SettingsDBA AWR System Metrics SummaryDBA AWR System Time SummaryDBA AWR System Time Summary PercentagesDBA AWR System Wait Class by TimeDBA AWR System Wait Event SummaryDBA AWR System Wait Time SummaryDBA AWR Tablespace Usage
      DBA Archive / Redo Log RateDBA Automated Maintenance TasksDBA Blocking SessionsDBA DBMS Profiler DataDBA Dependencies (used by)DBA Dependencies (uses)DBA External Table CreationDBA Feature Usage StatisticsDBA ParametersDBA Performance Benchmark1DBA Performance Benchmark2DBA Performance Benchmark3DBA Result Cache Objects and InvalidationsDBA Result Cache StatisticsDBA SGA Active Session History
      DBA SGA Blocking Session SummaryDBA SGA Buffer Cache Object UsageDBA SGA Memory AllocationDBA SGA SQL Execution Plan HistoryDBA SGA SQL Performance SummaryDBA SGA Target AdviceDBA SGA+PGA Memory ConfigurationDBA SegmentsDBA Table ColumnsDBA Table ModificationsDBA Tablespace UsageDBA Text Search
      Discoverer
      DIS Access PrivilegesDIS Business AreasDIS End User LayersDIS Folders, Business Areas, Items and LOVsDIS Import PerformanceDIS Items, Folders and FormulasDIS UsersDIS Workbooks, Folders, Items and LOVsDIS Worksheet Execution HistoryDIS Worksheet Execution SummaryDIS Worksheet SQLs
      E-Business Tax
      ZX Lines SummaryZX Party Tax ProfilesZX Tax AccountsZX Tax Regimes
      Enterprise Asset Management
      EAM AssetsEAM Weekly ScheduleEAM Work Orders
      Enterprise Command Center
      ECC Admin - Concurrent ProgramsECC Admin - Data Load TrackingECC Admin - Data SetsECC Admin - Metadata Attributes
      General Ledger
      GL Account AnalysisGL Account Analysis (Distributions)GL Account Analysis (Distributions) 11gGL Account Analysis 11gGL BalanceGL Balance (pivot)GL Balance by Account HierarchyGL Daily RatesGL Data Access SetsGL FSG ReportsGL FSG Row OrdersGL Header Categories SummaryGL JournalsGL Ledger SetsGL Ledgers and Legal Entities
      GL Ledgers and OrganizationsGL Summary Templates
      Human Resources
      PER Employee AssignmentsPER Employee Grade ChangesPER Employee Salary ChangePER Organization HierarchyPER Organizations
      Installed Base
      CSI Customer Products SummaryCSI Installed Base Extended Attributes SummaryCSI Installed Base Summary by Organization
      Inventory
      INV Cycle count entries and adjustmentsINV Cycle count hit/miss analysisINV Cycle count listingINV Cycle count open requests listingINV Cycle count schedule requestsINV Cycle count unscheduled itemsINV Cycle counts pending approvalINV Default Category SetsINV Intercompany Invoice ReconciliationINV Inventory ItemsINV Item Category SetsINV Item Default LocatorsINV Item Default SubinventoriesINV Item Import PerformanceINV Item Relationships
      INV Item StatusesINV Item Supply/DemandINV Item TemplatesINV Material Account Distribution DetailINV Material TransactionsINV Material Transactions SummaryINV Onhand QuantitiesINV Organization AccessINV Print Cycle Count Entries Open Interface dataINV Safety StocksINV Stock LocatorsINV SubinventoriesINV Transaction Historical Summary
      Lease and Finance Management
      OKL Termination Quotes
      Legal Entity Configurator
      XLE Establishment and Legal Entity AssociationsXLE Legal Entities
      Master Scheduling/MRP
      MRP End Assembly PeggingMRP ExceptionsMRP Horizontal PlanMRP Item ForecastMRP Pegging
      Order Management
      ONT Order HeadersONT Order Headers and LinesONT Order HoldsONT Recurring Billing PlanONT Transaction Types ListingONT Transaction Types and Line WF Processes
      Payables
      AP Accounted Invoice AgingAP Accounts Payable Negative Supplier BalanceAP Cash RequirementAP ExpensesAP Intercompany Invoice DetailsAP Invoice Audit ListingAP Invoice PaymentsAP Invoice on HoldAP Invoices and LinesAP Invoices with PO, Intercompany and SLA DetailsAP Open Balances RevaluationAP Open Items RevaluationAP Payables Posted Invoice RegisterAP Payables Posted Payment RegisterAP Supplier Statement
      AP SuppliersAP Suppliers 11iAP Suppliers Revenue SummaryAP Trial BalanceAP Trial Balance Report Definitions
      Payments
      IBY Payment Process Request Details
      Payroll
      PAY Employee Payroll HistoryPAY Payroll Element Details
      Process Manufacturing Inventory
      GMI Cycle Count Forms
      Projects
      PA Task Schedule
      Property Manager
      PN GL ReconciliationPN Generate Lease AnalysisPN Generate Lease DetailsPN Generate Portfolio DetailPN Generate Portfolio Summary
      Purchasing
      PO Approval AssignmentsPO Approval GroupsPO Approved Supplier ListPO Document TypesPO HeadersPO Headers 11iPO Headers and LinesPO Headers and Lines 11iPO Internal Requisitions/Deliveries DiscrepancyPO Invoice Price VariancePO Purchase Price VariancePO Purchase Requisitions with PO Details
      Receivables
      AR Aging - 7 Buckets - By Salesperson/AgentAR Aging Buckets and Interest Tiers SetupAR Applied ReceiptsAR Autoinvoice Interface SummaryAR Customer Credit LimitsAR Customer Open Balances Period LookbackAR Customer StatementAR Customers and SitesAR Disputed InvoiceAR European Sales ListingAR Incomplete TransactionsAR Miscellaneous ReceiptsAR Open Balances RevaluationAR Open Items RevaluationAR Past Due Invoice
      AR Payment TermsAR Transaction RegisterAR Transactions and LinesAR Transactions and PaymentsAR Unapplied Receipts Register
      Service Contracts
      OKS Service Contracts Billing HistoryOKS Service Contracts Billing Schedule
      Shipping Execution
      WSH Shipping/Delivery Transactions
      Subledger Accounting
      XLA Distribution Links SummaryXLA Entity ID Mappings
      Work in Process
      WIP Account DistributionWIP Discrete Job ShortageWIP EntitiesWIP Entities SummaryWIP Required ComponentsWIP Value
      Workflow
      WF Activity Status SummaryWF Business Events and Subscriptions
      XML Publisher
      XDO Publisher Data Definitions
  • Customers
  • Blog
    • blog items
      Blitz Report™

      EBS logins geolocation tracking with Blitz Report

      Some time ago I wrote a post about finding an IP address and geolocation of logins to an EBS instance. It can be used to create custom Blitz Reports for Oracle E-Business Suite version and higher. In this post I will show how to visualize the output of such a report using Pivot table and Exc...

      Updated DBA AWR Blitz Reports now work with pluggable databases

      With introduction of container databases Oracle changed the way AWR data is stored and accessed. You can read about that in more detail in this article from Franck Pachot. As we used AWR data in our Diagnostic Pack reports we also had to make some adjustments due to various issues. The first issue w...

      Find an IP address and geolocation of EBS clients' logins

      Introduction Sometimes I see questions how to obtain an IP address for EBS logins. Before EBS it wasn't an easy task. But starting from EBS a new column "clientip" was added to fnd_logins table. So getting this information is very easy now. Many existing and potential customers connect to our EBS D...

      New Release Blitz Report 3.1.8

      Ten (10) new features, 50 minor enhancements/improvements Release contains a number of new features and many enhancements and improvements. We'll also cover some of the enhancements in as this was an interim maintenance release. Global multi-language support Blitz Report supports multi-languages in...

      Simplifying DBA tasks with Blitz Report

      I am an EBS Apps DBA. When I talk with other , it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a query from another DBA’s blog, sometimes I find something useful in a MOS Doc or a bo...

      Blitz Report™ Toolkits

      EBS logins geolocation tracking with Blitz Report

      Some time ago I wrote a post about finding an IP address and geolocation of logins to an EBS instance. It can be used to create custom Blitz Reports for Oracle E-Business Suite version and higher. In this post I will show how to visualize the output of such a report using Pivot table and Exc...

      Asset tracking troubleshooting

      Audience: EBS architects, consultants, and business analysts for asset planning and tracking Article Summary: Understanding the asset integrations, including the Enterprise Command Center and troubleshooting transactions with Blitz Report. Prerequisites: 1. Download and install the free version of ...

      Bringing ASCP into a usable state

      Audience: EBS architects, consultants and business analysts for advanced supply chain planning (ASCP) Making the Planner Workbench usable Many customers of the Oracle module - Advanced Supply Chain Planning (ASCP) are disappointed or just cannot get the planners to use the Planner Workbench (PWB). ...

      How to use EBS audit functionality to speed up operations

      Audience: Master data maintenance, support consultants and operational teams. Related blogs: Can data governance be free? How to track changes using standard audit setup Auditing data in Oracle EBS Auditors are increasingly recommending that high-risk activities be tracked and reported. While Ora...

      Can data governance be free?

      Audience: Master Data Maintenance and data governance teams and support consultants Related Blogs: How to use EBS audit functionality to speed up operations How to track changes using standard audit setup Data Governance and compliance Typically, Oracle E-Business Suite (EBS) implementations have m...

      Oracle Discoverer

      Oracle Discoverer Replacement

      Task: Oracle Discoverer replacement Audience: DBA's, IT consultants and business operations Background Oracle de-supported Discoverer in 2017, which poses a significant challenge for EBS users. The Enginatics team has developed an Oracle Discoverer replacement utility with automated functionality...

      Does Oracle Discoverer 11g work with Oracle Database 19c?

      Lately we see questions about Oracle Discoverer 11g certification with Oracle Database 19c. Oracle officially confirms that Discoverer is not tested or certified on the Oracle Database 19c. We use Discoverer for development purposes only, but were curious if it will work with the 19c version. Recen...

      Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3

      Since we recently developed automated Discoverer report migration into Blitz Report and our development team needed test environment,  we had to integrate Discoverer with Oracle EBS. In this post we share our experience. If you are looking for Discoverer replacement - Blitz Report is the right cho...

      Oracle E-Business Suite

      Launching EBS forms with Java Web Start on MacOS Big Sur and later

      In my previous post on Java Web Start I outlined the required EBS patches and basic cofiguration for Windows end users. But after one of our partners tried to connect to our EBS demo instance from a Mac it turned out that some additional steps are required for MacOS users. So this article will help...

      New Release Blitz Report 3.1.8

      Ten (10) new features, 50 minor enhancements/improvements Release contains a number of new features and many enhancements and improvements. We'll also cover some of the enhancements in as this was an interim maintenance release. Global multi-language support Blitz Report supports multi-languages in...

      Could your organization lose these mission critical EBS assets?

      The case for agile EBS reporting Losing a critical business asset is always hard. It shouldn’t happen. Recently, when discussing our favorite topic, “Oracle EBS Reporting”, an organization confided that they suffered a serious loss. One of their KPI reports was missing. It was a complex SQL s...

      Enhancing the Blitz Report Library, committed to support and service

      Team commitment to service and support Blitz Report has a number of great features that help our EBS customers get the answers they need to make better decisions more quickly. Features like delivering the required data as native Excel files, reduced processing overhead so performance is incredibly ...

      Hands On Tutorial - Oracle EBS - SQL to Excel Reporting for Non-developers

      Hands On Tutorial Many Oracle EBS end users are intimidated by the thought of creating their own reports.  At the same time, users are often frustrated about having to wait for their IT team to fulfill their requests. In order to help demystify the report creation process, we recently hosted an on...

      Oracle Enterprise Command Center

      Simplifying your ECC Upgrade to v7

      Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V7. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...

      Simplifying your ECC Upgrade to v6

      Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V6. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...

      How to create 220 Oracle standard EBS Excel reports in less than 5 minutes

      Audience Relevant for development or supporting consultants and business users that require reports using the same query logic as ECC dashboards Introduction Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Or...

      Simplifying your ECC Upgrade to v5

      Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from V2-V4 to V5. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions of ECC V2 please ...

      Oracle ECC administration and exports to Excel

      Introduction Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Oracle E-Business Suite Dashboards are provided for functional areas such as Supply Chain, Financials, Manufacturing and Procurement. This article ...

      Supply Chain Hub

      A more optimal Supply Chain Hub

      Objective: Inventory supply chain planning optimization Audience: IT consultants, Sales & Operations Planning, Buyers and Customer Service teams Supply Chain Hub overview A key issue faced by Oracle supply chain users is the sheer number of forms and responsibilities to navigate to reach the ri...

      Adding the advanced features to ASCP planning

      The Planners Workbench (PWB) is the daily tool for the planners but it lacks the basic functions needed to make planning analysis optimal. A common problem faced by Oracle ASCP planning users, is how to export large volumes of plan data from the Planner Workbench (PWB). Often several sheets togethe...

  • About
    • Contact
    • Support
    • EBS Tuning
    • Partners
    • Subscribe
    • Demo Login
  • Events
  • Blitz Report
    • Features
    • Pricing
    • Download
    • FAQ
    • Tutorials
    • User Guide
    • Installation Guide
    • Toolkits
      • Cost Accounting
      • Data Management
      • DBA
      • Metrics
      • Operations
      • Setup & Support
    • Changelog
  • Supply Chain Hub
    • Features
    • Download
    • Installation Guide
    • Seeded Reports
  • Library
    • lib items
      Advanced Pricing
      QP Customer Pricing Engine RequestQP Price Lists
      Advanced Supply Chain Planning
      MSC ExceptionsMSC Horizontal PlanMSC Pegging HierarchyMSC Plan OrdersMSC Vertical Plan
      Application Object Library
      FND Access ControlFND Access Control 11iFND Application Context FileFND ApplicationsFND Attached DocumentsFND Attachment FunctionsFND Audit SetupFND Audit Table Changes by ColumnFND Audit Table Changes by RecordFND Concurrent ManagersFND Concurrent Program IncompatibilitiesFND Concurrent Programs and ExecutablesFND Concurrent Programs and Executables 11iFND Concurrent Request ConflictsFND Concurrent Requests
      FND Concurrent Requests 11iFND Concurrent Requests SummaryFND Descriptive FlexfieldsFND FNDLOAD Object TransferFND Flex Hierarchies (Rollup Groups)FND Flex Value HierarchyFND Flex Value Security RulesFND Flex Value Sets, Usages and ValuesFND Flex ValuesFND Form FunctionsFND Forms PersonalizationsFND Help Documents and TargetsFND Key FlexfieldsFND LanguagesFND Lobs
      FND Log MessagesFND Lookup SearchFND Lookup ValuesFND Menu EntriesFND Profile Option ValuesFND Profile OptionsFND Responsibility Menu ExclusionsFND Role HierarchyFND RolesFND Tables and ColumnsFND User Login HistoryFND User Login Page FavoritesFND User Login SummaryFND User ResponsibilitiesFND User Roles
      FND Users
      Applications DBA
      AD Applied PatchesAD Applied Patches 11iAD Applied Patches R12.2
      Assets
      FA Additions By SourceFA Asset AdditionsFA Asset Book DetailsFA Asset CostFA Asset ImpairmentsFA Asset InventoryFA Asset RetirementsFA Asset Summary (Germany)FA CIP CostFA Cost AdjustmentsFA Depreciation ProjectionFA Depreciation ReserveFA Journal Entry Reserve LedgerFA Revaluation ReserveFA Tax Reserve Ledger
      Bills of Material
      BOM Bill of Material StructureBOM Calendar ExceptionsBOM Routings
      Blitz Report
      Blitz Report Application CategoriesBlitz Report AssignmentsBlitz Report Category AssignmentsBlitz Report Column TranslationsBlitz Report Deletion HistoryBlitz Report Execution HistoryBlitz Report Execution SummaryBlitz Report LOV SQL ValidationBlitz Report LOVsBlitz Report License User CountBlitz Report License UsersBlitz Report Parameter Custom LOV ValidationBlitz Report Parameter Default ValuesBlitz Report Parameter Table Alias ValidationBlitz Report Parameter Uniqueness Validation
      Blitz Report SQL ValidationBlitz Report TemplatesBlitz Report User HistoryBlitz Report VPD Policy SetupBlitz Reports
      CRM Foundation
      JTF Grid Datasources
      Capacity
      CRP Available ResourcesCRP Resource Plan
      Cash Management
      CE Bank Account BalancesCE Bank Statement Import ExecutionCE Bank Statement and ReconciliationCE Bank Transaction Codes ListingCE Cash in TransitCE Cleared TransactionsCE General Ledger Cash Account UsageCE General Ledger ReconciliationCE Transactions Available for Reconciliation
      Contracts Core
      OKC Contract Lines Summary
      Cost Accounting
      CAC Accounting Period StatusCAC Accounting Period Status (Financials)CAC Cost vs. Planning Item ControlsCAC ICP PII Inventory and Intransit Value (Period-End)CAC Inventory Out-of-BalanceCAC Inventory and Intransit Value (Period-End)CAC Inventory to G/L Reconciliation (Restricted by Org Access)CAC Inventory to G/L Reconciliation (Unrestricted by Org Access)CAC Item Cost SummaryCAC Item vs. Component Include in Rollup ControlsCAC Margin Analysis Account SummaryCAC Margin Analysis SummaryCAC Material Account SummaryCAC Material Account Summary No SLACAC Receiving Account Detail No SLA
      CAC Receiving Account SummaryCAC Receiving Account Summary No SLACAC User-Defined and Rolled Up CostsCAC WIP Account SummaryCAC WIP Account Summary No SLA
      Cost Management
      CST AP and PO Accrual ReconciliationCST COGS Revenue MatchingCST Cost GroupsCST Detailed Item CostCST Inventory Value - Multi-Organization (Item Costs)CST Inventory Value Report - by Subinventory (Item Cost)CST Item Cost ReportsCST Miscellaneous Accrual ReconciliationCST Period Close Subinventory ValueCST Period Close Subinventory Value SummaryCST Supply Chain Indented Bills of Material CostCST Uninvoiced Receipts
      Database Administration
      DBA AWR Active Session HistoryDBA AWR Blocking Session SummaryDBA AWR Latch SummaryDBA AWR Latch by TimeDBA AWR PGA HistoryDBA AWR SQL Execution Plan HistoryDBA AWR SQL Performance SummaryDBA AWR SettingsDBA AWR System Metrics SummaryDBA AWR System Time SummaryDBA AWR System Time Summary PercentagesDBA AWR System Wait Class by TimeDBA AWR System Wait Event SummaryDBA AWR System Wait Time SummaryDBA AWR Tablespace Usage
      DBA Archive / Redo Log RateDBA Automated Maintenance TasksDBA Blocking SessionsDBA DBMS Profiler DataDBA Dependencies (used by)DBA Dependencies (uses)DBA External Table CreationDBA Feature Usage StatisticsDBA ParametersDBA Performance Benchmark1DBA Performance Benchmark2DBA Performance Benchmark3DBA Result Cache Objects and InvalidationsDBA Result Cache StatisticsDBA SGA Active Session History
      DBA SGA Blocking Session SummaryDBA SGA Buffer Cache Object UsageDBA SGA Memory AllocationDBA SGA SQL Execution Plan HistoryDBA SGA SQL Performance SummaryDBA SGA Target AdviceDBA SGA+PGA Memory ConfigurationDBA SegmentsDBA Table ColumnsDBA Table ModificationsDBA Tablespace UsageDBA Text Search
      Discoverer
      DIS Access PrivilegesDIS Business AreasDIS End User LayersDIS Folders, Business Areas, Items and LOVsDIS Import PerformanceDIS Items, Folders and FormulasDIS UsersDIS Workbooks, Folders, Items and LOVsDIS Worksheet Execution HistoryDIS Worksheet Execution SummaryDIS Worksheet SQLs
      E-Business Tax
      ZX Lines SummaryZX Party Tax ProfilesZX Tax AccountsZX Tax Regimes
      Enterprise Asset Management
      EAM AssetsEAM Weekly ScheduleEAM Work Orders
      Enterprise Command Center
      ECC Admin - Concurrent ProgramsECC Admin - Data Load TrackingECC Admin - Data SetsECC Admin - Metadata Attributes
      General Ledger
      GL Account AnalysisGL Account Analysis (Distributions)GL Account Analysis (Distributions) 11gGL Account Analysis 11gGL BalanceGL Balance (pivot)GL Balance by Account HierarchyGL Daily RatesGL Data Access SetsGL FSG ReportsGL FSG Row OrdersGL Header Categories SummaryGL JournalsGL Ledger SetsGL Ledgers and Legal Entities
      GL Ledgers and OrganizationsGL Summary Templates
      Human Resources
      PER Employee AssignmentsPER Employee Grade ChangesPER Employee Salary ChangePER Organization HierarchyPER Organizations
      Installed Base
      CSI Customer Products SummaryCSI Installed Base Extended Attributes SummaryCSI Installed Base Summary by Organization
      Inventory
      INV Cycle count entries and adjustmentsINV Cycle count hit/miss analysisINV Cycle count listingINV Cycle count open requests listingINV Cycle count schedule requestsINV Cycle count unscheduled itemsINV Cycle counts pending approvalINV Default Category SetsINV Intercompany Invoice ReconciliationINV Inventory ItemsINV Item Category SetsINV Item Default LocatorsINV Item Default SubinventoriesINV Item Import PerformanceINV Item Relationships
      INV Item StatusesINV Item Supply/DemandINV Item TemplatesINV Material Account Distribution DetailINV Material TransactionsINV Material Transactions SummaryINV Onhand QuantitiesINV Organization AccessINV Print Cycle Count Entries Open Interface dataINV Safety StocksINV Stock LocatorsINV SubinventoriesINV Transaction Historical Summary
      Lease and Finance Management
      OKL Termination Quotes
      Legal Entity Configurator
      XLE Establishment and Legal Entity AssociationsXLE Legal Entities
      Master Scheduling/MRP
      MRP End Assembly PeggingMRP ExceptionsMRP Horizontal PlanMRP Item ForecastMRP Pegging
      Order Management
      ONT Order HeadersONT Order Headers and LinesONT Order HoldsONT Recurring Billing PlanONT Transaction Types ListingONT Transaction Types and Line WF Processes
      Payables
      AP Accounted Invoice AgingAP Accounts Payable Negative Supplier BalanceAP Cash RequirementAP ExpensesAP Intercompany Invoice DetailsAP Invoice Audit ListingAP Invoice PaymentsAP Invoice on HoldAP Invoices and LinesAP Invoices with PO, Intercompany and SLA DetailsAP Open Balances RevaluationAP Open Items RevaluationAP Payables Posted Invoice RegisterAP Payables Posted Payment RegisterAP Supplier Statement
      AP SuppliersAP Suppliers 11iAP Suppliers Revenue SummaryAP Trial BalanceAP Trial Balance Report Definitions
      Payments
      IBY Payment Process Request Details
      Payroll
      PAY Employee Payroll HistoryPAY Payroll Element Details
      Process Manufacturing Inventory
      GMI Cycle Count Forms
      Projects
      PA Task Schedule
      Property Manager
      PN GL ReconciliationPN Generate Lease AnalysisPN Generate Lease DetailsPN Generate Portfolio DetailPN Generate Portfolio Summary
      Purchasing
      PO Approval AssignmentsPO Approval GroupsPO Approved Supplier ListPO Document TypesPO HeadersPO Headers 11iPO Headers and LinesPO Headers and Lines 11iPO Internal Requisitions/Deliveries DiscrepancyPO Invoice Price VariancePO Purchase Price VariancePO Purchase Requisitions with PO Details
      Receivables
      AR Aging - 7 Buckets - By Salesperson/AgentAR Aging Buckets and Interest Tiers SetupAR Applied ReceiptsAR Autoinvoice Interface SummaryAR Customer Credit LimitsAR Customer Open Balances Period LookbackAR Customer StatementAR Customers and SitesAR Disputed InvoiceAR European Sales ListingAR Incomplete TransactionsAR Miscellaneous ReceiptsAR Open Balances RevaluationAR Open Items RevaluationAR Past Due Invoice
      AR Payment TermsAR Transaction RegisterAR Transactions and LinesAR Transactions and PaymentsAR Unapplied Receipts Register
      Service Contracts
      OKS Service Contracts Billing HistoryOKS Service Contracts Billing Schedule
      Shipping Execution
      WSH Shipping/Delivery Transactions
      Subledger Accounting
      XLA Distribution Links SummaryXLA Entity ID Mappings
      Work in Process
      WIP Account DistributionWIP Discrete Job ShortageWIP EntitiesWIP Entities SummaryWIP Required ComponentsWIP Value
      Workflow
      WF Activity Status SummaryWF Business Events and Subscriptions
      XML Publisher
      XDO Publisher Data Definitions
  • Customers
  • Blog
    • blog items
      Blitz Report™

      EBS logins geolocation tracking with Blitz Report

      Some time ago I wrote a post about finding an IP address and geolocation of logins to an EBS instance. It can be used to create custom Blitz Reports for Oracle E-Business Suite version and higher. In this post I will show how to visualize the output of such a report using Pivot table and Exc...

      Updated DBA AWR Blitz Reports now work with pluggable databases

      With introduction of container databases Oracle changed the way AWR data is stored and accessed. You can read about that in more detail in this article from Franck Pachot. As we used AWR data in our Diagnostic Pack reports we also had to make some adjustments due to various issues. The first issue w...

      Find an IP address and geolocation of EBS clients' logins

      Introduction Sometimes I see questions how to obtain an IP address for EBS logins. Before EBS it wasn't an easy task. But starting from EBS a new column "clientip" was added to fnd_logins table. So getting this information is very easy now. Many existing and potential customers connect to our EBS D...

      New Release Blitz Report 3.1.8

      Ten (10) new features, 50 minor enhancements/improvements Release contains a number of new features and many enhancements and improvements. We'll also cover some of the enhancements in as this was an interim maintenance release. Global multi-language support Blitz Report supports multi-languages in...

      Simplifying DBA tasks with Blitz Report

      I am an EBS Apps DBA. When I talk with other , it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a query from another DBA’s blog, sometimes I find something useful in a MOS Doc or a bo...

      Blitz Report™ Toolkits

      EBS logins geolocation tracking with Blitz Report

      Some time ago I wrote a post about finding an IP address and geolocation of logins to an EBS instance. It can be used to create custom Blitz Reports for Oracle E-Business Suite version and higher. In this post I will show how to visualize the output of such a report using Pivot table and Exc...

      Asset tracking troubleshooting

      Audience: EBS architects, consultants, and business analysts for asset planning and tracking Article Summary: Understanding the asset integrations, including the Enterprise Command Center and troubleshooting transactions with Blitz Report. Prerequisites: 1. Download and install the free version of ...

      Bringing ASCP into a usable state

      Audience: EBS architects, consultants and business analysts for advanced supply chain planning (ASCP) Making the Planner Workbench usable Many customers of the Oracle module - Advanced Supply Chain Planning (ASCP) are disappointed or just cannot get the planners to use the Planner Workbench (PWB). ...

      How to use EBS audit functionality to speed up operations

      Audience: Master data maintenance, support consultants and operational teams. Related blogs: Can data governance be free? How to track changes using standard audit setup Auditing data in Oracle EBS Auditors are increasingly recommending that high-risk activities be tracked and reported. While Ora...

      Can data governance be free?

      Audience: Master Data Maintenance and data governance teams and support consultants Related Blogs: How to use EBS audit functionality to speed up operations How to track changes using standard audit setup Data Governance and compliance Typically, Oracle E-Business Suite (EBS) implementations have m...

      Oracle Discoverer

      Oracle Discoverer Replacement

      Task: Oracle Discoverer replacement Audience: DBA's, IT consultants and business operations Background Oracle de-supported Discoverer in 2017, which poses a significant challenge for EBS users. The Enginatics team has developed an Oracle Discoverer replacement utility with automated functionality...

      Does Oracle Discoverer 11g work with Oracle Database 19c?

      Lately we see questions about Oracle Discoverer 11g certification with Oracle Database 19c. Oracle officially confirms that Discoverer is not tested or certified on the Oracle Database 19c. We use Discoverer for development purposes only, but were curious if it will work with the 19c version. Recen...

      Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3

      Since we recently developed automated Discoverer report migration into Blitz Report and our development team needed test environment,  we had to integrate Discoverer with Oracle EBS. In this post we share our experience. If you are looking for Discoverer replacement - Blitz Report is the right cho...

      Oracle E-Business Suite

      Launching EBS forms with Java Web Start on MacOS Big Sur and later

      In my previous post on Java Web Start I outlined the required EBS patches and basic cofiguration for Windows end users. But after one of our partners tried to connect to our EBS demo instance from a Mac it turned out that some additional steps are required for MacOS users. So this article will help...

      New Release Blitz Report 3.1.8

      Ten (10) new features, 50 minor enhancements/improvements Release contains a number of new features and many enhancements and improvements. We'll also cover some of the enhancements in as this was an interim maintenance release. Global multi-language support Blitz Report supports multi-languages in...

      Could your organization lose these mission critical EBS assets?

      The case for agile EBS reporting Losing a critical business asset is always hard. It shouldn’t happen. Recently, when discussing our favorite topic, “Oracle EBS Reporting”, an organization confided that they suffered a serious loss. One of their KPI reports was missing. It was a complex SQL s...

      Enhancing the Blitz Report Library, committed to support and service

      Team commitment to service and support Blitz Report has a number of great features that help our EBS customers get the answers they need to make better decisions more quickly. Features like delivering the required data as native Excel files, reduced processing overhead so performance is incredibly ...

      Hands On Tutorial - Oracle EBS - SQL to Excel Reporting for Non-developers

      Hands On Tutorial Many Oracle EBS end users are intimidated by the thought of creating their own reports.  At the same time, users are often frustrated about having to wait for their IT team to fulfill their requests. In order to help demystify the report creation process, we recently hosted an on...

      Oracle Enterprise Command Center

      Simplifying your ECC Upgrade to v7

      Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V7. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...

      Simplifying your ECC Upgrade to v6

      Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V6. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...

      How to create 220 Oracle standard EBS Excel reports in less than 5 minutes

      Audience Relevant for development or supporting consultants and business users that require reports using the same query logic as ECC dashboards Introduction Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Or...

      Simplifying your ECC Upgrade to v5

      Introduction This post describes Oracle Enterprise Co