java.lang.NumberFormatException: For input string: "null" Unable to run enhanced Oracle report in SCT Banner 7.0.
 
 
HelpInfo
Unable to run enhanced Oracle report in SCT Banner 7.0.
Cause of Problem

The problem occurs because the SCT Banner 7.0 is not configured to run Oracle reports.
Solution Summary

Login to SCT Banner. Open the 'GUAUPRF' form. Click 'Directory Options'. Locate 'Enter the name of your Oracle Reports server'. Enter name of Oracle Reports server. Locate 'Enter the name of your Oracle Reports Service Name'. Enter location of the appropriate Oracle Reports Service. Save changes.
Solution Details

Job submission module in SCT Banner 7.0 allows you to create new reports, configure default parameter settings, and run banner reports. The Oracle Report window can be used to view and change the parameters defined for the job. The Oracle Report window is available from forms such as Standard Billing 270 Form (FRR270B) and other forms in which you can enter the appropriate data directly into the form. SCT Banner must be configured to run the enhanced Oracle reports.
To run enhanced Oracle reports:
1) Open the Internet browser.
2) Enter the appropriate URL and press ENTER.
3) Enter the appropriate user name and password.
  NOTE: If the environment requires, enter the appropriate database.
4) Press Enter. (The 'SCT Banner' main menu appears.)
  'SCT Banner' main menu
5) In the 'Go To' box, enter 'GUAUPRF'.
6) Press Enter. (The 'General User Preferences Maintenance GUAPRF' form appears.)
  'General User Preferences Maintenance GUAUPRF' form
7) Click the 'Directory Options' tab. (The 'Directory Options' tab appears.)
8) Locate the 'Enter the name of your Oracle Reports server' entry.
9) If you cannot view the appropriate information, enter the name of your Oracle Reports server, which includes the environment's machine name and the port value.
10) Locate the 'Enter the name of your Oracle Reports Service Name' entry.
11) Enter the location of the appropriate Oracle Reports Service, for example, ref_makname.
12) Save the changes.
Applies to Software Version

SCT Banner