Ellucian
Banner Web General Change Request Resolutions
SYSTEM: Banner Web General
PATCH NAME: pcr-000114541_bwg8060201
DATE: 7/11/2014
NOTE: Be sure all Oracle users are logged off and cannot or will not log on.
If you do this by starting the database in Restricted mode,
then all user IDs used in the installation will need the
Restricted Session system privilege for the duration of this
installation. (For more information refer to the Oracle Server
Administrator's Guide.)
It is advised to shutdown GURJOBS and restart it after the
installation is complete.
COMPLETE BACKUPS OF YOUR EXISTING SYSTEM BEFORE CONTINUING!
Make sure Oracle is down when the backup is taken. This ensures
a consistent backup. Verify that all database files, redo logs,
and control files have been successfully backed up.
======
Change Request (Defect) #: CR-000114541
DEPENDENCIES:
8.6.2.1 of bwgkdis1.sql can replace version 8.6.2
8.6.2.1 ofbwgkdisb.sql can replace version 8.6.2
8.6.2.1 of bwgtwgrinfoi_08060201.sql is new
8.6.2.1 of bwggtvsdaxi_08060201.sql is new
PROGRAM: bwgkdis1.sql
bwgkdisb.sql
bwgtwgrinfoi_08060201.sql
bwggtvsdaxi_08060201.sql
PROBLEM (CR-000114541):
?
YES, I HAVE A DISABILITY (or previously had a disability)
?
NO, I DON’T HAVE A DISABILITY
?
I DON’T WISH TO ANSWER
IMPACT (CR-000114541):
The response text is not identical to the official form
verbiage.
RESOLUTION (CR-000114541):
The layout of the SSB page did not match the format as
defined for form CC-305 (OMB Control Number 1250-0005).
Some of that layout has been changed in addition to the
response text for the Disability Page in SSB is now
being retrieved from Web Tailor Information Text
(bwgkdisb.P_DispDisab) instead of the translations from
the STVDISA form. The INB forms will still show the
STVDISA translations, but Self Service will use Info
Text associated with the STVDISA values, unless it does
not exist, in which case it will use the STVDISA
translations.
In addition, GTVSDAX entries SURVEY/DISABILITY will be
used to define the sequence in which the web page will
display the responses.
NOTE: If you are using different values than delivered
(i.e. DY, DN, NA) you will have to update the Info Text
and GTVSDAX entries to match your own values.
Link:
======
INSTALLATION INSTRUCTIONS:
1.To download and unpack the Change Request patch '.trz',
go to the Ellucian Client Support web site:
and click on
theEllucian Hub button to sign into the Ellucian Hub. Choose the Ellucian
Download Center or the Ellucian Support Center application.
To reach the Download Center from the Ellucian Support Center, click on the
'Banner, PowerCampus, Advance and all other Ellucian products'
link under the Download Code heading on the left.
On the right side of the Ellucian Download Center window, enter the name
of the patch (pcr-000114541_bwg8060201) in the field labeled
'Find Patch / Release by Filename', then click the 'Find It' button.
Check the check box next to the name of the .trz file and click the ZIP
Selected Files button. Click on the 'Click Here to Download the ZIP File'
button to download into your download area. Unzip the file on your PC,
then ftp the .trz file to your server.
2.Position yourself in the subdirectory created when the
posting was unloaded.
3. To give the necessary users DBA roles, invoke SQL*Plus
and run the procedure:
sqlplus /nolog @bwggivedba [Enter]
Note: You will be prompted for the SYSTEM password.
Review: bwggivrole.lst
4. To apply required data do the following:
4a. Invoke SQL*Plus and run the following script:
sqlplus baninst1/password [Enter]
startbwgdr_gendml [Enter]
This will generate the following scripts, which will
be applied in the next part:
bwgrundmlgtvsdaxi_08060201.sql
bwgrundmltwgrinfoi_08060201.sql
4b. This part will apply the scripts generated in the
previous part.
sqlplus baninst1/password [Enter]
startbwgdr_applydml.sql [Enter]
NOTE: You may be prompted for BANINST1 password.
Review:
bwglisdmlgtvsdaxi_08060201.lst
bwglisdmltwgrinfoi_08060201.lst
5. To restore the necessary users to the roles/privileges they had prior to
applying this patch, invoke SQL*Plus and start the procedure:
sqlplus /nolog @bwgresrole [Enter]
Note: You will be prompted for the SYSTEM password.
Review: bwgresrole.lst
6. To apply database procedures, invoke SQL*Plus and
run the procedure:
sqlplus /nolog @bwgdbpr2 [Enter]
Review: bwgdbpr2.lst
7. To compile all functions, views, packages, procedures
and triggers which are in an invalid state.
Invoke SQL*Plus and run the procedure:
sqlplus /nolog @gurutlrp [Enter]
Review: gurutlrp.lst
UNIX PLATFORMS
8. Review bwgmigr.shl for correct directory path names
and make sure the environment variable $BANNER_HOME
is set to the appropriate directory. Then migrate and
link the new objects to your permanent directories
and produce an error log for the migration by typing:
shbwgmigr.shl >bwgmigr.log 2&1 & [Enter]
Review: bwgmigr.log
9. To record this patch in the General gurpost table,
invoke SQL*Plus and run the procedure:
sqlplus general/password [Enter]
startbwginspost [Enter]
Review: bwginspost.lst
MICROSOFT WINDOWS PLATFORMS
8. The file bwgmigr.pl will do the appropriate deletes
and copies. Before running the migration script you
must check the BANENV environment variable. This value
may be determined by executing the SET command from
the DOS prompt.
If BANENV has a value of REG, the value used for
BANNER_HOME will be taken from the registry entry:
HKEY_LOCAL_MACHINE\SOFTWARE\BANNER\BANNER_HOME
If BANENV has a value of ENV, the value for
BANNER_HOME will be taken from the environment
variable BANNER_HOME.
Review the script for correct directory path names.
To run the migration script and produce an error log
for the migration type the following:
perl bwgmigr.pl >bwgmigr.log 2&1 [Enter]
Review: bwgmigr.log
9.To record this patch in the General gurpost table,
invoke SQL*Plus and run the procedure:
sqlplus general/password [Enter]
startbwginspost [Enter]
Review: bwginspost.lst
************************************************************************
Banner , Colleague , PowerCampus , and Luminis are trademarks of Ellucian
Company L.P. or its affiliates and are registered in the U.S. and other
countries. Ellucian ,Ellucian Advance , Ellucian Degree Works , Ellucian
Course Signals ,EllucianSmartCall , and Ellucian Recruiter are trademarks
ofEllucian Company L.P. or its affiliates. Other names may be trademarks of
their respective owners.
2014 Ellucian Company L.P. and its affiliates
Contains confidential and proprietary information of Ellucian and its
subsidiaries. Use of these materials is limited to Ellucian licensees, and
is subject to the terms and conditions of one or more written license
agreements between Ellucian and the licensee in question.
In preparing and providing this publication, Ellucian is not rendering
legal, accounting, or other similar professional services. Ellucian makes
no claims that an institution's use of this publication or the software
for which it is provided will guarantee compliance with applicable federal
or state laws, rules, or regulations. Each organization should seek legal,
accounting and other similar professional services from competent providers
of the organization's own choosing.
Prepared by: Ellucian
4375 Fair Lakes Court
Fairfax, Virginia 22033
United States of America
******************** END OF COVER SHEET *********************