Session ID: 11151

Abstract: Many organizations have Oracle Payroll and multiple timekeeping systems. This situation often leads to duplication of effort, data divergence, and error. We used Oracle Application Express to solve the problems of tedious, time-consuming and error-prone processes involved with integrating 3rd party timekeeping systems with Oracle Payroll. We will examine the application and see how it allows for editing and overtime explosion using Oracle APIs and custom PL/SQL packages to eliminate duplication of time entry. As a bonus, the application provides enhanced reporting and graphing capabilities.

Objective 1: Demonstrate the ability to create a custom application leveraging existing PL/SQL skills

Objective 2: Highlight the ease of developing extensions to the E-Business Suite using Application Express

Objective 3: Demonstrate the power of a free Oracle development tool

Audience: Developer