I am thinking that when Retropay by Element is run, it does something to the payroll tables which affects the run result data (for the periods which Retropay is running) and thus invalidates my SQL query (above). It may just be that a small tweak is required to the code.
Yes I've tried that and the function works consistently through pl/sql. I've even tried hard-coding the dates in the formula but still have the problem with Retropay.
Already tried that! I have also tried different employees, in case it was a data issue against a particular employee but the issue is across all employees. I am going to raise an SR with Oracle, but I don't anticipate much help as it is custom code!
Get up and running with Oracle on your existing computer in 5 minutes
Get
up and running with Oracle on your existing computer in 5 minutes!
Alard Consulting Ltd are pleased to offer Oracle R12.1.1 on
your existing computer.
Connect to
Oracle R12 from your computer to do client demonstrations, your own
development work, or test functional setup on a Vision environment without
having to install and maintain Oracle.
Backup your
work before making changes in case things go wrong. Just copy the files to a
new directory before making the changes. If it doesn't work, copy the files
back again, all from Windows. No other skills needed.
As everything
is contained on a single external hard drive, you can take it with you to use
wherever you need it.
For each sale
from HCMAces a portion of the price will go to the running costs of this forum.
Previous Topic
Index