Oracle Projects
Remote Support
Data Warehousing
Certified Training
White Papers
Oracle Projects


  P.O Box 580
  Yorba Linda, CA


Mentor Corporation

Oracle Migration Project Description

Mentor Corporation, a medical device manufacturer located in Goleta, CA contracted with us to migrate their Oracle 8.1.6 Production instances from NT 4.0 to a temporary Windows 2000 server. Informatica would then be brought up on the Windows 2000 Server. This was the first phase of an overall migration strategy, which was migrating all UNIX/Oracle based applications over Microsoft/SQL2005. Our challenge was to keep the original naming conventions the same so that JD Edwards Sales Data Warehouse, which was based on Informatica, did not notice that a server change had occurred. This was also the strategy for the Windows 2000 temporary server. We successfully migrated the server in about two weeks.

The Orange County Transportation Authority (OCTA):

OCTA is Orange County CA's primary transportation agency. Located in Southern California, the OCTA is focused on rail, freeways, streets, and public transportation.  Its primary mission is to create, coordinate, finance, and deliver an easy to use public transportation network which keeps Orange County's 2.8 million people moving.

While Southern California is known for its freeways, more than 200,000 Orange County residents a day rely on OCTA buses to travel to and from work, school, and a variety of other places. OCTA takes this responsibility seriously, placing more than 460 buses on 80 routes during peak hours. This activity generates over 5 million transactions of ridership data per month.

On Time has implemented a Data Warehousing strategy for the OCTA, consisting of Data Marts for Ridership and Pass, Coach Operator management, Incident Tracking, Bus Run Costing, and the Orange County Employees Retirement System (OCERS).  All of the data warehouses/data marts were built in an Oracle 9i environment, using Oracle Warehouse Builder (OWB).

These Data Warehouses capture voluminous amounts of transit, bus operations, and employee/payroll information, which allow detailed analysis of Bus Operations, enabling the OCTA to continually improve its services to the citizens and taxpayers of Orange County. The project has involved extracting transactions from Genfare International's (GFI) Fareboxes, GIRO Inc.'s HASTUS scheduling system, Sun-Gard Bi-Tech IFAS accounting system, and Lawson Software HRIS/Payroll system to provide detail and summarized data that gives a clearer understanding of revenues, costs, utilization, and ridership statistics.  On Time has also created scores of Web-based reports using Oracle 9iDS FORMS and REPORTS on an Oracle 9iAS Server.


What our clients are saying:

" We have found you and your team to be capable (your expertise in Oracle databases and Oracle Warehouse Builder is noteworthy), professional, and a pleasure to work with. I would highly recommend On Time Consulting Services to anyone responsible for prompt, accurate, and successful delivery of Oracle-based projects ."

-- Ray Riggins , Data Management & Applications Support, OCTA

Forms and Reports Samples: Click Here



Oracle 9iAS Installation & Oracle 9IDS FORMS Deployment is a leading business-to-business ticketing solutions provider for live events. The company, with its corporate office in Costa Mesa, Ca. and other offices around the United States and the world, facilitates the sale of tickets by enabling venues and entertainment organizations with proprietary and cutting edge software, retail outlets, kiosks, call centers and an interactive voice response (IVR) systems.

We installed Oracle's 9iAS application server on two new dual-processor, MS Server 2000 servers. However, before we could begin the new installation, we had to uninstall their existing configuration, which had Oracle 9iAS Infrastructure, Mid-Tier and Oracle 9i Development Services incorrectly installed on the same server -- a major performance impedance.

A Oracle Developer worked with our consultant to remove all previous Oracle 9iAS instances. We then installed Oracle 9iAS INFRASTRUCTURE on the smaller of the two servers, and a new, clean installation of Oracle 9IAS Mid-Tier on the second server. We linked the Mid-Tier Installation to the INFRASTRUCTURE and tested their Oracle FORMS. Then we configured their web form using webforms.config on their Mid-Tier server. The form worked better and faster in the properly-configured installation.  Next, we installed Oracle 9iDS on a desktop server and provided training on how to develop and deploy new Oracle FORMS into the production Oracle Mid-Tier environment.

Their new installation is correctly installed and configured, and is compliant with Oracle's Flexible Architecture (OFA). is another satisfied On Time Consulting Services client!


Associated Grocers, Inc.:

Associated Grocers, Inc., is on the leading edge of technology, offering its retailers a full line of services including accounting, advertising, equipment & design services, marketing, retail technology, and procurement & merchandising. Membership has expanded to over 230 retailers in Louisiana, Mississippi and Texas. With over 550 full-time employees and annual sales over $450 million, Associated Grocers, Inc. is a key player in the economy of Louisiana. Associated Grocers' mission remains the same, as it was in 1950: The Survival and Success of the Independent Retail Grocer.

On Time Consulting Services provided Lawson Software and Oracle upgrade services to assist AG's internal Lawson Administrator and Oracle DBA to upgrade 7.2.6 APPS/7.3.3 ENV to 8.0.3 APPS/ 8.0.3 ENV.  We created two Lawson Environments and 4 Product Lines to satisfy their current requirements. Additionally, we created the physical Oracle databases to support the Lawson Product Lines. Our project was to create the Environments, Product Lines and Databases so that AG personnel could begin work on the Lawson upgrade.

We worked closely with AG's Oracle DBA and Lawson Software Administrator to perform Oracle and Lawson setup and configuration tasks.  We have also assisted their Oracle DBA with automated backups, and are providing training and mentoring for routine health checks and maintenance of AG's Oracle database environment.



Oracle Warehouse Builder (OWB) Training/Mentoring

Burlington Resources Inc. is one of the world’s largest independent oil and natural gas exploration and production companies, and ranks among North America’s leading producers. To support their North American Oil and Gas operations, Burlington Resources has developed and executed a sophisticated Business Intelligence strategy, using Oracle Warehouse Builder (OWB) as the ETL tool to collect production and financial data and load it into a data warehouse environment.

On Time sent an OWB expert to Burlington Resources’ Information Technology Services team to provide hands-on training and mentoring for OWB tuning and troubleshooting techniques and to conduct WebEx training sessions with remote locations on advanced OWB topics.  In addition, On Time was asked to make recommendations regarding OWB mapping deployment methodologies and metadata repository administration and management.

On Time worked closely with the Data Management group at Burlington Resources to enhance their proficiency with Oracle Warehouse Builder and help them maximize the benefits of their investment in Oracle technology.


Orange County Register:

The Orange County Register is the largest of 28 daily newspapers operated by Freedom Communications, Inc., a privately-held company that ranks as the nation's 11th largest newspaper company (by daily circulation) and one of the leading media companies in the United States. The Orange County Register, as part of Freedom Orange County Information, also publishes 23 weekly newspapers, including the Spanish-language Excelsior.

On Time was initially engaged by the Orange County Register to provide Oracle PL/SQL export scripts from Lawson Software's GL and AP application, which we did in a few short days. We were also requested to develop a Ceridian Payroll interface, which created multiple intercompany distribution journal entries. We designed a flexible, easy-to-maintain intercompany "to and from" account and accounting unit table, and consolidated eight separate payroll JE files into one. Then we streamlined their payroll and posting process to let the software do most of their intercompany transactions.

What our clients are saying:

"The personnel at On Time were a pleasure to work with! They were very professional and gave us sound technical and business advice even when it was outside of the 'scope' of their engagement. They were quick to look at our processes and made good recommendations that saved us valuable time during our month-end close, which is a critical time for us. They delivered what was promised, or more, in a timely manner.

"On Time was a solid business partner for us during this critical system conversion. I wish that all of our consultants were as reliable!"

-- Kim E. Marcus, Controller, The Orange County Register


Giant Industries, Inc.:

Giant Industries Inc., an Oil and Gas retailer in the Southwestern United States, engaged us to build a new Linux server running Oracle 8i and to upgrade them from 6.1.x to 7.1.x of Lawson Software's Insight II Human Resource Management Suite.

We converted Giant's Chart of Accounts, Process Levels, and Departments into a completely new structure within their Lawson payroll application. We created several dynamic PL/SQL scripts to read the structural changes from an Excel Spreadsheet of OLD to NEW account, sub-account, process level, and departmental mappings and transformed the data.

We worked closely with their IT staff to ensure the successful execution of the data conversion, and with their accounting staff for thorough testing.

What our clients are saying:

"We were very pleased with the services On Time Consulting Services, Inc. provided during a recent data conversion.

"The team at On Time was very knowledgeable about Lawson Software and Oracle, and they were flexible when we ad last minute scheduling changes. We look forward to consulting with On Time on future projects."

-- Garet Burns, Lawson Programmer/Analyst


Yoshinoya West, Inc. :

Yoshinoya West, Inc., is a rapidly expanding "Quick Service" restaurant chain with over 92 locations in the state of California. Beginning in 1979 with its famous Yoshinoya Beef Bowl, now each Yoshinoya restaurant offers a variety of menu choices. Yoshinoya has differentiated itself from typical American fast food by providing customers with something to eat that is truly unique without giving up value and service.

Yoshinoya relies on On Time for Lawson Software and Oracle database upgrade services.  During our long-term relationship with Yoshinoya, we have also provided various ad-hoc Oracle database recovery and performance tuning services for Yoshinoya West, including emergency disc-failure recovery services.

Yoshinoya has engaged On Time a second time for an upgrade to current versions of Lawson Software GL, AP, AR, BL, IC, PO, and OE applications and Oracle database.   The first upgrade included approximately a dozen custom programs, re-integration of their point of sale application, application testing and data verification, and assistance in resolving an inventory valuation reconciliation issue by developing custom software.

What our clients are saying:

"We were very pleased with the services On Time Consulting Services, Inc. provided during a recent data conversion.

"On Time Consulting Services, Inc. successfully delivered a Lawson Software and Oracle database upgrade for Yoshinoya West, Inc. They installed Lawson Software and Oracle 8i on a new UNIX server, upgraded our applications and custom software, and assisted us with testing and troubleshooting. They have done excellent work, and we are very pleased with their Lawson application and technical support.

"Most recently they helped us to mitigate the downtime of our production server during a disc drive failure. Within an hour of my calling, Kenny Herrscher had his team engaged and we began the recovery process. I don't know what we would have done without them. They really made our project a success!"

-- Harry T. Gani , Director of IT


Care Meridian, LLC :

CareMeridian specializes in providing a cost-effective, sophisticated subacute care alternative for catastrophically ill or injured patients. Each CareMeridian residence provides short term, long term, and life care programs with 24-hour skilled nursing coverage. Care Meridian's unique program merges the aesthetics of a residential environment within a framework of state-of-the-art technology and service.

On Time upgraded Lawson Software's 7.0.9 GL, AP, HRMS applications to 7.2.4 and 7.3.3 environment for Care Meridian. We also successfully upgraded their Oracle software to version from 8.0.6 to version 8.1.7 for HPUX 10.20.

Care Meridian utilizes our remote Lawson Software development and administration services. We provide weekly Oracle administration and tuning as well as Lawson patch support. They have expanded our scope of work to include Lotus Notes/Domino server development.

Care Meridian has opted for a few hours per week of our support services rather than hire full-time Lawson and Oracle administrative personnel.


Tri-City Medical Center :

Tri-City Medical Center is dedicated to leadership in providing comprehensive healthcare for North San Diego County residents. Administered by the Tri-City Healthcare District, a California Hospital District, the hospital features nearly 400 acute-care beds and a full range of primary care and medical-surgical services.

The Heart Center at Tri-City Medical Center features advanced imaging, the latest techniques in invasive and non-invasive cardiac procedures, complete orthopedic service for total joint replacement surgery/rehabilitation spine care, sports medicine programs and mobile Positron Emission Tomography (PET) services.

On Time has enjoyed a long-term relationship with Tri-City Medical Center and we have provided support for multiple projects. Notable projects are an upgrade of Lawson Software from 7.0.8 to 7.2.4 Applications and 7.3.3 environment, and a restructuring of the General Ledger chart of accounts.   The Lawson Software upgrade was accomplished in a Windows 2000 environment running SQL2000 database.  The Chart of Accounts restructuring included a design assessment to identify ways to take advantage of new General Ledger structure and features, and also included the optimization of reports to take advantage of the new account structure.



Providence St. Joseph's Medical Center:

Located just north of Los Angeles, Providence Saint Joseph Medical Center with 455 beds is the San Fernando Valley's largest hospital. Founded in 1943 by the Sisters of Providence Health System, Providence Saint Joseph is known for its state-of-the-art technology and the high quality, compassionate care provided. Our 2,000 employees, volunteers, Guild members and 600 plus physicians share a commitment to provide quality care for all. In addition to the acute care facility, the Medical Center also offers services through its Cancer Center, Heart Center, Rehabilitation Services, Home Health and Home Hospice Programs, and Women's and Children's Services.

Providence Saint Joseph Medical Center engaged On Time to convert their Lawson Software applications to an Oracle database environment.   We installed Oracle 8i database software and developed scripts to transfer data into the new database.   The installation and conversion were first accomplished on a test server, which provided an opportunity for training and mentoring on best practices for a Lawson/Oracle installation.

On Time provided guidance to Providence Saint Joseph Medical Center IT personnel in the installation of Oracle 8i on their production server, and in the development of scripts for on-going administration and management of the Oracle database.   At the conclusion of the project, Providence Saint Joseph Medical Center IT personnel were completely self-sufficient in the operation and support of their Oracle database installation.



Founded in 1958 as United Ad Label, Veriad provides everything that has to do with the labeling, filing and organizing of documents, records, inventory and materials to help organize businesses like yours. We are one of America 's leading suppliers of healthcare, veterinary, media and quality assurance labels. Veriad has more than 8,500 stock and custom labels and truly is a one stop shop for labels. Veriad serves the Healthcare, Physician, Veterinary, Media Services, Quality Assurance and many other industries. Veriad is owned by Moore Corporation Limited (TSE, NYSE: MCL) and provides data capture, information design, marketing services, digital communications and print solutions, that enable clients to improve their business processes and increase revenue. Sales in 1999 were more than U.S. $2.4 billion.

On Time used SeeBeyond's e*Gate Enterprise Application Integration (EAI) toolset to provide reliable, real-time transaction exchange between Oracle AR and OE applications and Onyx CRM application, effectively knitting the applications together as though they were one.   The project was centered on Customer address, demographic, and contact information changes that had to be synchronized in real time between Oracle and Onyx applications. After tuning the design to increase performance, the bi-directional synchronization of customer add and change transactions occurred in sub-second time intervals.



This project was managed by Accenture who engaged us to assist them in the "RESA build" project. This project used SeeBeyond's e*Gate application to integrate Tosco's 6000+ locations of Circle K convenience stores, RETEK point of sales audit application, and Oracle's General Ledger.

We developed an Appworx-initiated interface in e*Gate 4.1.1 to feed data from Retek Sales Audit system to Oracle Financials G/L system. We also created an e*Gate schema that uploaded Excel spreadsheet sales codes, edited them for correctness, and updated the RETEK sales audit code master.

Accenture was pleased with On Time's willingness to engage quickly to assist them in bringing this project into production on time, on budget and on expectation.




HOME | Services | Client Projects | About Us | Contact | Search | Products | Resources | Privacy
Copyright © 2002-2007 On Time Consulting Services, Inc. All Rights Reserved.
On Time Consulting Services, Inc. is not a certified business partner of Lawson Software.