Case Study

Going Beyond Oracle Forms With the Texas Racing Commission

The Texas Racing Commission is a state government agency that regulates all aspects of pari-mutuel horse and greyhound racing in Texas. It ensures racing safety, integrity, and fairness. It monitors racing-related activities, issues licences, and has the power to enforce rules and regulations.

The agency uses an Oracle database with in-house customized applications built with Oracle Forms and Reports as well as Oracle APEX to license, track and analyze racing activities. It tracks participants, licences, violations, animals, and animal health, as well as dollars wagered. Many administrative functions such as inventory, service requests, and mail logs are also stored in its database.

Challenge

To better fulfill its role as industry regulator, the Commission required functionality beyond the limits of its Oracle Forms-based legacy applications. It needed to

  • Automate time-consuming manual processes
  • Reduce clutter and simplify navigation
  • More easily view all records or a specific record for a licensee, animal, or race
  • More quickly and easily evaluate test results and injuries
  • Improve application security and the ability to view and maintain application authorization

Solution

The Commission initiated a series of projects to migrate key Oracle Forms applications to Oracle Application Express (APEX). These included: Veterinary, Investigations, Rulings, Licensing, and others.

Insum was chosen as a trusted partner to design and deploy these applications, which not only included existing Forms functionality but also many enhancements, a number of which happened to be native to APEX.

Results

The new applications improved performance for users in several areas.

Veterinary Application

Linking all animal records to the maintenance page gives its users a “one stop” application allowing them to quickly see the number of existing records for an animal and easily navigate to those records.

Case Tracking Application

By using APEX Interactive Reports to augment and replace existing Oracle Reports, Insum enabled investigators to quickly access information across applications eliminating excessive navigation through menus or form pages. Interactive Reports also provides easy but powerful tools allowing them to build and customize their own reports.

Rulings Application

Insum automated the manual processes in this application. Search functionality was also added throughout the rulings system. This has sped up processes and increased efficiency. Records are much easier to locate.  New features have improved application functionality and security.

Licensing Application

The application was redesigned to reduce clutter. Adding links for license relationships made navigation simpler and functionality easier to understand.

As of January 2021, the Texas Racing Commission has 12 APEX applications.

“Insum was able to customize the Texas Racing Commission’s ruling system to our specific needs. They took the time to listen to what we wanted and needed from the Ruling system. Any requested changes were done in a timely manner and they paid attention to all the details.”

-Connie Estes, Director of Licensing, Texas Racing Commission

“APEX has brought the Texas Racing Commission into the 21st Century! It can be manipulated in many different ways to help you find exactly what you are looking for, in a place that can hold billions of pieces of data. I am very happy with the new software and would highly recommend it to others.”

Edna C. Griswold, Chief Test Barn Supervisor, Texas Racing Commission

“These applications gave us the ability to more efficiently perform our core mission of ensuring safety and integrity of pari-mutuel racing by giving us the ability to better analyze incidents of catastrophic injuries and to track and analyze data necessary to combat organized crime.”

Chuck Trout, Executive Director, Texas Racing Commission

Looking to Modernize your Oracle Forms?

If you’re concerned about your Oracle Forms and Reports, and are looking for a modernization option that’s adapted to your exact needs, we can help!

Some of our other case studies

Improving the Retail Experience with James Avery Artisan

James Avery Artisan Jeweler needed a POS application to efficiently connect their retail associates to its back-end EBS system for Buy Online, Pickup in store orders. Using APEX, Insum created an application that simplified the transaction and helped staff stay out front with their customers.

Pharmaceutical Regulatory Information

This leading pharmaceutical provider needed a custom application to ensure regulatory compliance. Oracle APEX and Oracle’s Autonomous Database were the answer.

Moving an Airline to the Cloud

The on-site servers hosting an airline’s mission-critical application quickly needed replacement. The cloud proved to be the way to go.

Ivy League University

A large department at an Ivy-league University needed to quickly streamline its mainly manual salary increase process.

CIS Field Reporting System with Oracle APEX

Using Oracle APEX, Insum helped CIS develop a field data capture system for use in large scale fiber optics installation projects. The system is highly regarded in market, and has changed the way fiber utility installation is managed.

Tap 50:50 Raffle System with Oracle APEX

Using Oracle APEX, Insum developed a shopping cart that could securely dovetail with Tap 5050’s existing system and provide a quality user experience.

X