Oracle Forms Migration and Modernization - CLONE

Insum delivered four successful migration phases, converting applications for security management, project tracking, and internal training. APEX’s Universal Theme and AOP reporting ensured usability and consistency.

The Result

• 250+ Forms migrated to APEX
• On-time, on-budget delivery
• Internal teams trained and equipped for future development

“Insum gave us a strong start with APEX, providing the tools, training, and support our developers needed.”
— IT Manager, Federal Agency

A global energy technology provider needed to migrate 323 material management Forms screens to Oracle APEX within 12 months due to an upgrade by their software editor. Many of the screens included complex extensions.

The Challenge

• Maintain existing functionality
• Improve performance and navigation
• Ensure a smooth transition
• Stay on time and on budget

The Results

Despite unforeseen scheduling challenges, the Insum-Talan team delivered successfully, meeting the timeline and budget. Key achievements included:

• Reducing unnecessary applications and features
• Harmonizing the user experience
• Adding advanced search and visualization tools
• Providing expert coaching and advice

A formalized global process, including quality control and change management, was key to the project’s success.

A leading U.S. government-debt collection law firm managing over $10 billion in delinquent accounts needed to update its tax collection systems running on outdated Oracle Forms, Database, and APEX versions.

The Challenge

Outdated systems using a mix of role-based and application-level security required modernization to improve efficiency, UX, and security.

The Priorities

• Enhance service quality through innovation
• Improve user experience
• Achieve strong information security

The Results

After updating the database and applications, Insum migrated 117 Oracle Forms to Oracle APEX, leveraging existing database logic and adding native APEX enhancements without impacting delivery. Outcomes included:

• Streamlined applications and reduced unnecessary features
• Powerful search and visualization tools
• Consistent user experience
• Expert guidance and coaching

The migration leveraged Oracle Real Application Security (RAS)—the latest in Oracle’s application security technology.

A logistics company specializing in trailer leasing and rental needed to modernize its on-premise Oracle Forms ERP to support new business processes and improve data visibility.

The Challenge

• Review and update on-premise Oracle Forms ERP
• Quickly incorporate new business workflows
• Enhance reporting and data visualization

The Priorities

• Modernize while extending existing Forms investments
• Reduce on-site infrastructure
• Improve reporting flexibility and data insights
• Streamline billing and reduce errors

The Results

Insum migrated the Oracle Forms applications to the Cloud and developed secure, high-performance dashboards using Oracle APEX, including Interactive Reports. The solution integrated real-time telematics data with ERP systems, delivering better visibility and efficiency.

A sales and marketing services consultancy specializing in employee recognition and loyalty programs needed to replace Oracle Forms due to outdated web technology, lack of responsive design, and security concerns.

The Challenge

• Replace legacy Forms to improve security and UX
• Enable secure access from anywhere
• Improve customer experience
• Provide developer training and a technology roadmap

The Results

Insum migrated all Oracle Forms to Oracle APEX and:

• Set up a secure, scalable APEX infrastructure
• Designed a Time Entry and Approval app as a proof of concept
• Created a unified design standard with shared themes and components
• Developed remaining applications using this template
• Delivered ongoing knowledge transfer, best practices, and coaching

The project resulted in a secure, user-friendly system and empowered the client’s developers for future growth.

A state government agency regulating the pari-mutuel horse and greyhound racing industry needed functionality beyond its legacy Oracle Forms applications to better fulfill its regulatory role.

The Challenge

• Outdated Forms limiting critical functionality
• Manual processes slowing operations
• Complex navigation and security concerns

The Priorities

• Automate manual workflows
• Simplify and declutter navigation
• Enhance application security

The Results

New APEX applications replicated existing Forms features and introduced many enhancements:

• Streamlined “one-stop” navigation for all animal records
• Reduced excessive navigation in case tracking with powerful, customizable reports
• Automated manual processes and strengthened security in rulings
• Improved licensing application with clearer interfaces and relational links

“Insum customized our ruling system precisely to our needs, listened carefully, and delivered changes quickly and thoroughly.”
— Director of Licensing, Regulatory Agency