Home › Discussions › Questions & Answers › Oracle Enterprise Command Center Framework upgrade to V7

Oracle Enterprise Command Center Framework upgrade to V7

Avatar photoCustomer Questions & Answers 11 replies

We are preparing for the Oracle Enterprise Command Center Framework upgrade to V7. As this involves a significant change in the ECC infrastructure, what is the strategic importance of using specialized tools for prerequisite checks and data validation?

11 replies

  • Support Enginatics

    For complex infrastructure changes like an ECC upgrade, utilizing the Blitz Report Project Implementation and Upgrade Toolkit is highly recommended. This toolkit provides necessary diagnostic and data migration reports (like BR100 extracts and Database Health/AWR checks) crucial for pre- and post-upgrade validation.

  • What is the fastest way to confirm that all technical prerequisites (e.g., specific ECC patches or underlying EBS patches) are correctly applied before starting the V7 upgrade application cycle?

  • Support Enginatics

    You should use a custom Blitz Report that executes the AD_PATCH.IS_PATCH_APPLIED function. This allows you to quickly query the status of all required bug numbers simultaneously directly from the EBS Forms interface, serving as an immediate patch checklist.

  • If the upgrade introduces new ECC dashboards, we will need to quickly create operational reports based on the underlying logic for non-ECC users.

  • Support Enginatics

    You can rapidly create these reports by leveraging the validated ECC SQLs. Blitz Report supports developing proven EBS reports using Oracle Enterprise Command Center SQLs in under 5 minutes , ensuring fast deployment of new operational reports.

  • We need to ensure that the ECC data exports, which may contain sensitive transactional data, are secure.

  • Support Enginatics

    Data security is maintained by enforcing Oracle VPD security policies at the database level. Additionally, for ECC, ensuring that your environment is running securely over HTTPS/TLS is critical for protecting data transmission during administration and use.

  • After the upgrade, we need to conduct a financial integrity check, specifically looking at GL balances and Cost Accounting figures.

  • Support Enginatics

    The financial reporting capabilities of Blitz Report support complex reports like GL Account Analysis and Simple And Effective Cost Accounting Reporting. Running pre-saved comparison reports ensures you quickly ‘ungarble’ the post-upgrade financial data to verify YTD totals and hierarchical structures.

  • If our DBA team needs to diagnose concurrent request performance during the post-upgrade smoke test, what tool should they use?

  • Support Enginatics

    They should rely on the Concurrent Request Monitoring and Alert Reporting tool. This provides the ability to filter requests running longer than an expected timeframe and extract the active SQL text for immediate performance tuning analysis.

  • You must be logged in to reply to this post.