Social Security Administration
Social Security Administration (SSA) delivers services through a nationwide network of over 1,300 offices that include regional offices, field offices, card centers, teleservice centers, processing centers, hearing offices, the Appeals Council, and their State and territorial partners, the Disability Determination Services. Social Security is the “face of the government” for the public and the rich diversity of their employees mirrors the public they serve.
In June of 2008, SSA commenced an enterprise-wide migration from Oracle E-Business Suite Release 11i to Release 12, a major upgrade within the Oracle Applications family of products. SSA had been using Oracle Discoverer for its financial reporting and had manually built a customized end user layer (EUL) for that tool. Creating the EUL from scratch had been an intensive process, involving multiple joins to appropriately map the data within Oracle 11i to SSA’s customized BI reporting environment.
The SSA project team realized that the Oracle upgrade was going to change the database join structures significantly and would require a rewrite of most of the original mappings. The team reviewed their processes and made the determination that they would prefer to look for a solution which provided maintenance on those joins as part of the product. Working with Discoverer to rewrite all of the reports manually and then continuing to update them manually was not the best option moving forward.
The SSA project team ultimately chose software from Noetix to automatically handle the conversions and database re-mappings required with each new Oracle release. Organizations that select Noetix as the foundation for their reporting needs streamline access to Oracle application data during the implementation phase and then continue to benefit from report protection against data structure changes, as is inherent in the upgrade to Oracle Release 12. Noetix largely eliminates the need to rework reports for Oracle upgrades and minimizes many of the disruptions to essential reporting functions that a migration could cause.
SSA began the Noetix implementation in January 2009 and completed it in April, a few months before the overall Oracle Release 12 migration was finalized. Because SSA was using Noetix to manage the cross-over from old folders in Oracle 11i to new folders in Release 12, the project team was able to start rewriting the reports in Noetix ahead of schedule and before the migration was finalized. This allowed the team to ultimately extend the time it had to rewrite the reports and reduce the risk during the upgrade conversion by having them automatically work in the new version.
Today, about 165 end users from SSA’s centralized accounting department use Noetix for ad hoc query to develop their own financial reports. They now have secure access to additional data in cross-functional reports that they were not able to view using Oracle Discoverer. SSA also purchased Noetix WebQuery to replace Oracle Discoverer and has benefited from that tool’s small footprint on the front-end.
With support from Noetix, SSA had the tools and technology required to meet their deadlines and stay ahead of schedule during a Release 12 migration.