I have a WF program that generates an Oracle SQL using parameters supplied by a user entry screen.
The generated SQL runs in WF and returns records, but one of the calculated columns is incorrect. When I paste that same query in PL/SQL, it returns the correct value.
e.g 1702.89 / 15000 = .11353 - this is the result in PL/SQL. When the query is run in WF the result is .03
Ani ideas would be greatly appreciated!This message has been edited. Last edited by: Kerry,
September 28, 2012, 03:10 PM
Dan Satchell
One possibility: If the calculation is being performed in a COMPUTE or a DEFINE that cannot be passed to the Oracle database for execution, then it's possible the calculation is being performed at the aggregate level by WF instead of the detail level by Oracle.
WebFOCUS 7.7.05
October 01, 2012, 02:48 AM
GamP
But to be sure of that, we need to see the code, don't we?
