Featured Projects
Implementation of Oracle Payables and integration with non-Oracle Purchasing System:
The client required integration between Oracle Payables and a non-Oracle purchasing and inventory management system to enable 3-way matching between the invoice, purchase order and receipts. The external system also required on-line GL account and project validation. The integration was performed using database links, flexfield API’s, Purchasing API’s and package procedures to maintain the Oracle Purchasing tables in the background. The integration was performed seamlessly and has been in production for over 10 years, including several Oracle application upgrades and replacement of the original supply chain management system.
Web Query to Enable Payables, Purchasing and Project Data Access
A large number of business users across the country required access to invoice and commitment status information for the departments and projects for which they were responsible. In addition, vendors and buyers needed payment scheduling information related to their invoices. Prior to the Alaris solution, a help desk in the AP department was used to respond to all inquiries. Alaris worked with the users and Payables management to design a series of web-enabled, guided queries. The web queries were carefully designed to provide optimal performance (often faster than Oracle forms) and intuitive navigation for the end-user. The information can be viewed on-line or downloaded to Excel for further analysis. The solution saved the company a significant amount of licensing costs compared to provided users with Oracle Payables Inquiry access.
Implementation of Oracle Receivables to Provide Financial Subledger for External Billing System
Alaris was challenged to integrate a high-volume, non-Oracle billing system with Oracle Receivables to provide GAAP and statutory reporting for financial users. Key requirements included financial AR aging and management, earned and unearned revenue analysis, cash management, legal entity accounting, and reconciliation to GL account balances. The incoming data was mapped to provide the correct accounting entries and summarized to a level that would be meaningful for reporting needs. The resulting accounting records were integrated with a data warehouse to provide drill-down to lower-level details as needed. Having the data warehouse reconciled to the company’s financial records is a key benefit to the users from various corporate departments.
Implementation of Oracle TCA as an online contact registration system
We defined a project that would allow internet users the ability to register an account with this client. The user would fill out the new account information and submit this data. When they did this the information was populated into Oracle TCA in real-time. Specific business constraints were implemented at the web front end to help keep the data clean and legitimate. As you can imagine all kinds of junky data would be entered by folks using the internet. In addition to storing the TCA data orders could be placed for product after registering. Of course this part would require validation by the business the following day. Orders were also enabled for credit card processing. All of which is still continuing to be integrated with the TCA portion of Oracle. The order processing system is a non-oracle applications module. During the implementation it was necessary to perform a lot of data cleansing. For this the DQM process was leveraged. DQM de-dup rules were used to help clean, merge, and remove data that was not worthy of storing. An extensive use of the TCA APIs was leveraged to get this implementation in place. There were points where the JAVA version of the TCA APIs was necessary to tightly fit into the business website. All-in-all, this project is one that uses the Oracle TCA to such an extent that their entire business is stored here. Sales contacts, tasks, contracts, and many other elements of the contact are stored. We have never seen a business use the TCA to the degree this project took it. Wow, what a project and what fantastic results.
Depot Repair and Service Implementation
Alaris exclusively led a global implementation of Oracle’s Service Suite for a large high technology, discrete manufacturing company. Modules included: Depot Repair, Teleservice, iSupport, Installed Base, and Service Contracts. Over 300 Million dollars of annual repair and field service business were moved from a variety of legacy systems, and consolidated onto Oracle. This fully integrated the service division with Finance and Supply Chain, enabling efficiencies such as streamlined service parts replenishment, automated order and shipment processing, and consolidated financial reporting. Additionally, with the rollout of iSupport, the company further leveraged benefits of Oracle’s integration in providing customers with a web-based portal to log service requests.
Project and Financials Implementation
Implemented Oracle Project Costing and Billing, Project Contracts, OTL and Financials modules for a major DoD contractor. Key success factors included compliance with CAS and FAR regulations, total time accounting for labor costing, TCI and Value Added G&A methods, automation of federal Government billing formats (SF1034, SF1035, DD250, SF1443, T&M, etc.), billing by CLIN/ACRN, progress billing, and interface to Wide Area Workflow (WAWF). Leveraged multiple project and organization hierarchies to accumulate transaction detail into a simplified Datamart to support management reporting, audit requests, incurred cost submission, and other schedules. Additional business units are being added to the core infrastructure to increase the return on original investment.
Financials Upgrade
Performed an upgrade for a major health insurance provider. Reviewed new features with module leads to increase productivity and eliminate customization. Examples included XML Publisher for various documents and reports, General Ledger journal approval workflow, and Report Manager repository. Refined technical migration path and minimized downtime using three passes in a test environment in preparation for final production cutover. Trained technical staff on new development tools and modifications to custom-developed code. Assisted end users with development and coordination of comprehensive test plans. Logged issues encountered and assigned responsibility for resolution and retesting as necessary. Managed service requests logged with Oracle Support and tracked necessary patches.
