Oracle upgrade for Insurance Industry from Ireland

Project Overview: EXPinIT Poland recently executed a seamless migration for a prominent insurance client in Dublin, Ireland, upgrading their legacy Oracle Business Intelligence Publisher (BIP) to the latest Oracle Analytics Publisher (OAP) version.

Client's Initial Environment: The client leveraged Oracle BIP to serve two critical functions:

  1. Reporting System:
  • Dedicated to departments such as Actuarial, Risk & Compliance, Controlling, Finance, Sales, and Operations.
  • Reports generated from central systems and data warehouses.
  • User-triggered reports in planned and ad-hoc modes.
  • Stringent permission policies at the report level.
  1. Serial Correspondence Template Repository:
  • BIP used as a repository for serial correspondence templates.
  • Documents created during day-closing processes.
  • A dedicated module querying BIP for templates, filling them with transactional data, and generating PDF files.
  • Physical correspondence printed and mailed to insurance clients across EMEA.

Migration Success: Within a remarkable two-week timeframe, EXPinIT Poland completed the migration to the latest Oracle OAP version. This included the application of patches for the most up-to-date version while preserving all permissions, security levels, report structures, and more.

Results and Benefits:

  • Streamlined and enhanced reporting capabilities.
  • Maintained data security through stringent permission management.
  • Seamless transition to the latest Oracle OAP version.
  • Preserved the entire report structure and security settings.

Next Steps: Curious to learn more about this success story? Dive deeper into the details by reaching out to Mariusz Kamelak Whether you're in the insurance industry or managing Oracle environments, we're here to share our expertise and insights.