Oracle Optimization Project leads to Ongoing Support and Maintenance

The Client

Public Sector Organization

This project involved optimizing and enhancing the implementation of an Oracle Financials application for our client. Modules included General Ledger and Accounts Payable at the 11.5.8 release level.

The Technology

Oracle Financials Version: 11.5.8

  • General Ledger
  • Accounts Payable

The Challenge

Our client needed experienced Technical Developers to support the implementation.

The Solution

We were optimizing and enhancing the implementation of an Oracle Financials application, version 11i system. Our team is responsible for all aspects of technical support for the applications above the DBA, operating system, and network levels. Specific responsibilities include: applications performance tuning; research and resolution of error and warning conditions on concurrent requests; and general technical assistance and/or troubleshooting in response to user requests.

We were also responsible for all aspects of technical support for the applications above the DBA, operating system, and network levels. Specific responsibilities included:

  • Applications performance tuning at both the database level and the individual program level.
  • Research and resolution of error and warning conditions on concurrent requests.
  • Review and enhancement of the technical aspects of General Ledger and Accounts Payable setups (e.g., accounting flexfield definitions, profile option settings, concurrent program registrations, etc.)
  • General technical assistance and/or troubleshooting in response to user requests.

The Squires Team also designed and developed several extensions, including the following:

  • A bi-directional interface between the General Ledger application and an in-house data warehouse application. This interface insures that all applicable data flow correctly between these two systems, and that the two systems remain in balance.
  • Several database views which are used to provide custom reporting capabilities to the client via the Discoverer reporting tool. These views accumulate and summarize ledger balances to the proper level for reporting.
  • A custom solution for AP vendor security. This solution provides for distinct entry and approval functions for AP vendor data, which is a capability that Oracle Payables does not provide generically. Custom security code was added to the custom.pll file, along with database triggers to generate security-related email messages.

The Success

The client was able to significantly improve financial reporting. Our team accomplished this goal by adding several extensions, including a bi- directional interface between the General Ledger application and an in- house data warehouse application and several database views which are used to provide custom reporting capabilities to the client via the Discoverer reporting tool. These views accumulate and summarize ledger balances to the proper level for accurate financial reporting. In addition, we provided a custom solution for AP vendor security. This solution provides for distinct entry and approval functions for AP vendor data, which is a capability that Oracle Payables does not generically provide. In addition a custom security code was added to the custom.pll file, along with database triggers to generate security-related email messages, significantly enhancing the security of the overall module.


Download this case study


Leave a Reply

Your email address will not be published.