I'm getting the above error message for printing of certain invoices. Most invoices work/print just fine. What's puzzling to me is that this error message says that COLUMN 'G_LINE_TOTAL' returns an invalid value. However, I don't have a column called G_LINE_TOTAL. I do have a group called G_LINE_TOTAL. I've looked at all functions within that group but can't find anything. I've got exception handling in all of the functions but no exception get's listed. Does anyone have any idea how I can go about troubleshooting/fixing this problem?
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.
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.