This content has been marked as final. Show 6 replies
For the start if you have not yet used the find feature: From Menu > Program > Find and Replace in PL/SQL try to search for "G_LINE_TOTAL".
As you are getting the following error : "Column 'G_LINE_TOTAL' : PL/SQL formula returned invalid value" there should be some reference of "G_LINE_TOTAL" somewhere in your report. Try to find that out.
Yes, I had already tried that. The PL/SQL search returns nothing at all. Right now, I'm admittedly stumped. Thanks for the suggestion.
Any gurus have any ideas?
There can be two possibilities
1. That you have function in your report called G_LINE_TOTAL you can find in report Object Navigator>Programs Units.
2. As you said you have group called G_LINE_TOTAL then might be on that group you choosed Filter Type to PL/SQL. You can access that by clicking on group and press F11 or open property and click PL/SQL Filter.
Now if you find code any one of them above. Then check where you missed the RETURN. Because function always should return value.
I appreciate the feedback. Those are all the things I have looked at already. I think this problem is being masked by another problem. The report works most of the time. The existence of certain transactions is causing the report to fail and to provide a misleading error message. I have never seen a GROUP column ( doesn't really exist!). The datavalues from these other transactions are exceedingly large. I'm going through each funtion now and increasing the return sizes. The error message keeps shifting around to other columns almost as if the report is somewhat corrupt ... still runs thoug for most invoice printing. I'll keep hacking away at this.
Check the datatype & size of all formula columns (property) with return variable (trigger) under group G_LINE_TOTAL
Edited by: user1003341 on Nov 6, 2012 3:15 AM