|
Oracle Rep-159 is an internal error generated by oracle reports. Oracle Rep-159 is generated in multiple situations which cannot be documented in detail, but a few of the situations that I have run into are listed below..
Oracle Rep-159
Multiple Situations in Which Oracle Rep-159 was generated...
1. When I try to generate a report as a PDF format, I have an Reports Builder internal code error (REP-159).
2. Running report through form on 9iAS and passing more than one run
time parameter. using Paramer list by RUN_REPORT_OBJECT(report_id,
Parameter_List) yields REP-159 error. When passed paramet through
SET_REPORT_OBJECT_PROPERTY(paraform=NO p_date=JUN-2006 p_remarks=Trial
Run) yields REP-159 error. It is due to blank between p_remarks
character string. The remarks parameter will contain some of the
blanks.
In case 1, we found that oracle rep-159 was clearly related to
Bug 2639586 which is fixed in Oracle Application Server Reports 10g (9.0.4)
In case 2, the issue was related to passing a parameter in 9iAS with a space. The best way to eliminate this oracle rep-159 is through the encoding of the parameter. Space is represented as %20 in html encoding and representing the value of Trial Run as Trial%20Run will eliminate the rep-159 error.
|
