Creating Payroll Variance Reports with Oracle Discoverer
Posted by Ben Lamb | Filed under Oracle
Overview I have had many clients ask me whether they can create Pay Variation reports in Oracle Discoverer, and how much effort is involved. It is possible and it is quite easy once you know how. To create Pay Variance reports in Oracle Discoverer you only need access to Discoverer Administrator, and either Discoverer Desktop [...]
Tags: Discoverer, Oracle, payroll, Payroll Variance, Variance
Oracle Application Server Timezone Changes – No time like the present
Posted by Matt Barker | Filed under Oracle
Have you ever had trouble with daylight savings? No, I’m not talking about sleeping in and being an hour late for work. Have you ever had your system show the wrong time, scheduled jobs in Alesco or Oracle not run when they’re meant to, or seen conflicting reports of what the current time is in [...]
Tags: Alesco, java, Oracle, server, technology
Scheduling Discoverer Reports to Save You Time
Posted by Ben Lamb | Filed under Oracle
Overview Discoverer reports can take take a long time to run. To run the report manually and then wait for the report to finish can sometimes be a timely and frustrating exercise. An easier way to get the reports you want without the long wait is to schedule them. Discoverer offers functionality to schedule reports [...]
Tags: Discoverer, manage workbook, Oracle, Schedule, v_$parameter
Oracle DBMS_METADATA Package
Posted by Matt Barker | Filed under Oracle
A recent archiving exercise for a client saw the need to recreate a number of objects in the database. You could search through an find the object definitions in your source code, then cut and paste to recreate the objects in the correct order. But why not make Oracle work for you and use the [...]
Tags: dbms_metadata, Oracle, sql
Discoverer returning inconsistent data
Posted by Peter Forbes | Filed under Oracle
A customer recently emailed us saying that one of the Discoverer reports we had written was returning inconsistent data each time they ran the report. This lead them to use the report less and was also picked up by their auditors when they were checking employee salaries. On investigation, we found the report was showing [...]
Tags: Discoverer, Oracle, reporting
Installing the Oracle ODBC Driver
Posted by Ben Lamb | Filed under HRIS, Oracle
The Oracle Instant Client is a simple way to setup ODBC connections to Oracle databases. This is great for PC support people as in the past installing ODBC for Oracle has not been a simple task. Instant Client also comes with a command line SQL*Plus utility. Instant Client was released in Oracle 10g but can [...]
