Open-source Java Reporting Solution
A collection of simple, easy to use Java frameworks to support a variety of enterprise reporting applications surrounding an Oracle E-Business Suite applications for HR, Payroll, and Benefits. Frameworks include:
- Various reports as Excel spreadsheets
- Single button press automation of routine systems reports
- Interactive web queries for rapid and deep visibility into the Oracle database
- Common routines
Excel Reports Framework
Generate attractively formatted Excel fiscal year to date reports from complex SQL queries from the Oracle application database. Reports include:
- OTRS Exceptions (otrs)
- Salary Basis (salb)
- Retirement Status (rtrm)
- NSU Foundation Employee Information (nsuf)
- Benefits Audit Report (enrl)
- FYTD Leave Accruals (leav)
Also includes an easy to use framework for adding new reports. A typical report consisting of two to three moderately complex queries can be added in two to three working days.
PL/SQL Stored Procedures
Provides a framework to execute PL/SQL stored procedures from a Java application to run routine reports needed on a regular monthly basis.
Current hosting applications for
- Payroll GL Costing
- 403B Contribution Report
- OTRS Remittance Report
This framework includes all of the systems functions involving transferring files and sending email to make these "single button press" operations.
Interactive Web Queries
Provides an interactive web interface to quickly browse Employees, Assignments, Jobs, Organizations and Positions, within the context of the different hierarchies maintained in the Oracle E-Business Suite. This is a currently an internal tool, and intended only for use by developers and system administrators.
Common Utilities and Routines
Contains a collection of utilities, tools, and base objects used by all of the different projects.