Docstoc

AR - Excel

Document Sample
AR - Excel Powered By Docstoc
					Product                      Readme File Name                Module Release Patch Date
Banner-Accounts Receivable   p1-3k616f_tas80000_readme.txt          8.0.0.1   8/20/2008




Banner-Accounts Receivable   p1-3k616f_tas80000_readme.txt             8.0.0.1    8/20/2008




Banner-Accounts Receivable   p1-3uc71n_tas80000_readme.txt             8.0.0.1    9/29/2008




Banner-Accounts Receivable   p1-42heib_tas80000_readme.txt   Overall   8.0.0.1    12/9/2008


Banner-Accounts Receivable   p1-42hgrq_tas80000_readme.txt             8.0.0.1    1/22/2009




Banner-Accounts Receivable   p1-497qur_tas80000_readme.txt   Overall   8.0.0.1   12/10/2008




Banner-Accounts Receivable   p1-4ka4cf_tas80000_readme.txt             8.0.0.1     2/4/2009
Banner-Accounts Receivable      p1-4kg6ip_tas80000_readme.txt   Overall   8.0.0.2   2/11/2009

Last Revised: 6/19/09 7:45 pm
AR 8.x Patches
Defect         Object(s)
1-3K616F       tfamass.fmb




1-3K6171       tsamass.fmb




1-3UC71N       tgrappl.pc, tvkarfn.sql, tvkarf1.sql,




1-42HEIB       tsr1098.pc


1-42HGRQ       tsrrfnd.pc




1-497QUR       tsrtraf..pc




1-4KA4CF       tfamisc.fmb, tsamisc.fmb
1-4KG6IP   tsr1098.pc,tsrtraf.pc
Problem
Attribute should be 'FORM' not 'FORMS' for the following message:
G$_NLS.Get. Arguments: 'X','FORMS','Accounts Receivable hold
exists.
Do you want to process this transaction?'

Attribute should be 'FORM' not 'FORMS' for the
following message:
G$_NLS.Get. Arguments: 'X','FORMS','Accounts Receivable
hold exists. Do you want to process this transaction?')

The FSA regulations regarding paying prior year charges
using a credit balance created by Title IV funds have
changed for disbursements made on or after July 1,
2008. The regulations stipulate that no more than $200
of the current year’s funds may be applied to prior
year charges. The Banner Accounts Receivable
Application of Payments Processes (TGRAPPL) is being
enhanced to support this regulation. This will be
posted as a 7.3.0.1 patch via electronic download, and
may be used with Accounts Receivable releases 7.2 or
7.3.

1098T regulatory updates for calendar year 2008 requires
modification toTSR1098 for changes to the T-record of
the IRS file and one parameter that is no longer
reported.

The TSRRFND job crashes hard with an unhandled win32
exception in Banner 8 Windows environment.

The trailor record being produced in the flat file by
tsrtraf.pc contains commas, which causes the file to be
unacceptable by the third party processor of the 1098-T
forms.

System allowed transaction on TFAMISC and TSAMISC forms
(TBRMISD Table) to be saved when debits do not equal
credits. Transaction is out of balance. Block-Clear
navigation.

The irs1220.dat file produced by TSR1098 is unable to
convert unconventional characters from the UTF-8
character set that are being entered into the name,
address or city fields in the student’s SPRIDEN and
SPRADDR records. The IRS rejects the irs1220.dat file,
because the sequence number in record does not start in
position 500.
Impact
The re-key process was run on this object in order for error
messages to be properly sequenced.




The re-key process was run on this object in order for
error messages to be properly sequenced.




.Modification for TIV max limit changes. A maximum
amount of $200 from a current year fund may be used
to satisfy prior award year charges.
PY authorization is not required for institutional
charges that consist of tuition, fees, room,
or board. PY authorization is required for other
educationally-related expenses.




Regulatory changes to the file format for 1098T
reporting to IRS.




TSRRFND will not execute in Banner 8.0 WIndows
environment, due to unhandled win32 exception.

The third party processor may reject a file if the
trailor record contains commas.




Form may save records where debits do not equal credits
when navigating with Block-Clear, resulting in
out-of-balance condition.


Non-ASCII characters in the database may cause data in
the flat file to be shifted out of place, leading to
rejection of the file.
Product                        Readme File Name                Module   Release




Banner-Employee Self-Service   p1-3nv3q5_bwp80000_readme.txt            8.0.0.1




Banner-Employee Self-Service   p1-3nv3q5_bwp80000_readme.txt            8.0.0.1


Banner-Employee Self-Service   p1-3v3a9f_bwp80000_readme.txt            8.0.0.1


Banner-Employee Self-Service   p1-3v3a9f_bwp80000_readme.txt            8.0.0.1


Banner-Employee Self-Service   p1-3v3a9f_bwp80000_readme.txt            8.0.0.1


Banner-Employee Self-Service   p1-3v3a9f_bwp80000_readme.txt            8.0.0.1
Banner-Employee Self-Service   p1-3v3a9f_bwp80000_readme.txt                    8.0.0.1




Banner-Employee Self-Service   p1-3wqv7h_bwp80101_readme.txt   Salary Planner   8.1.1.1




Banner-Employee Self-Service   p1-3ym2lp_bwp80101_readme.txt                    8.1.1.1




Banner-Employee Self-Service   p1-44aj5j_bwp80101_readme.txt                    8.1.1.2




Banner-Employee Self-Service   p1-4af8kj_bwp80101_readme.txt                    8.1.1.1




Banner-Employee Self-Service   p1-4bkb4n_bwp80101_readme.txt                    8.1.1.1
Banner-Employee Self-Service   p1-4ocj0h_bwp80101_readme.txt                    8.1.1.3




Banner-Employee Self-Service   p1-4sfm3p_bwp80101_readme.txt   Salary Planner   8.1.1.1




Banner-Employee Self-Service   p1-4sfm3p_bwp80101_readme.txt   Salary Planner   8.1.1.1




Banner-Employee Self-Service   p1-56sfsd_bwp80100_readme.txt                    8.1.1.4




Banner-Employee Self-Service   p1-56sfsd_bwp80100_readme.txt                    8.1.1.4
Banner-Employee Self-Service   bwp80000d_readme.txt
Banner-Employee Self-Service   bwp80000u_readme.txt
Banner-Employee Self-Service   bwp80100d_readme.txt
Banner-Employee Self-Service   bwp80100u_readme.txt
Banner-Employee Self-Service   bwp80101d_readme.txt
Banner-Employee Self-Service   bwp80101u_readme.txt
Last Revised: 6/19/09 7:45 pm
           Employee SS 8.x Patches
Patch Date Defect                    Object(s)




 8/18/2008 1-3NV3Q5                  bwpkepaf.sql




 8/18/2008 1-3NYIUD                  bwpkepd1.sql


 8/18/2008 1-3V3A9F                  bwpkdoe1.sql


 8/18/2008 1-3V3ACT                  bwpkepc1.sql


 8/18/2008 1-3V3AEN                  bwpkeps1.sql


 8/18/2008 1-3V3AJD                  bwpkepu1.sql
 8/18/2008 1-3V3K07   bwpkfsl1.sql




 4/13/2009 1-3WQV7H   bwpksjo1.sql




 6/17/2009 1-3YM2LP   bwpktais.sql




 1/31/2009 1-44AJ5J   efc.ear




  5/1/2009 1-4AF8KJ   bwpktai1.sql




12/19/2008 1-4BKB4N   efc.ear
3/13/2009 1-4OCJ0H   efc.ear




 3/6/2009 1-42BTSC   bwpksds1.sql




 3/6/2009 1-4SFM3P   bwpksds1.sql




 5/8/2009 1-4STM0X   efc.ear




 5/8/2009 1-56SFSD   efc.ear
Problem
Cannot submit a transaction to terminate a default
earning on the day after the last paid date. Process is
verifying against the effective date and the fact the
employee has been paid, the process forces the user to
have the effective date greater than the last paid
date. And, the End Date edit is forcing the date to be
one day greater than the effective date. Thus, the end
date of the default routing is two days after the last
paid date.




Electronic Approvals within Employee Self-Service does
not allow you to enter multiple default earnings where
the earn code is the same, but the effective dates are
different, within the same epaf. After the earnings
are entered, you save and receive the error "Duplicate
Earnings Found".




Message type should be 'SQL' for the following messages:


Message type should be 'SQL' for the following messages:


Message type should be 'SQL' for the following messages:


Message type should be 'SQL' for the following messages:
Message type should be 'SQL' for the following messages:
The internal area that holds NTRSALA information needs
to be increased. If the volume of NTRSALA data exceeds
the size, a "Page Not found" error will display when
trying to use the Job Detail or Employee Position links
in Salary Planner.


Leave Request/Leave Reports and timesheets from past
time periods in pending status are displaying in the
Time Approval channel once the pay period is open for
time entry. The approver is seeing these because the
Leave Requests were not approved prior to the timesheet
opening. No action can be taken on the leave requests
by the approver to remove them from the channel which
is causing some confusion.

The extract process is taking a long time to run when
creating a large number of effort reports.


Performance issues when approving timesheets in CURSOR
orgn_cr.




The routing queue is not created, and the disposition of
the transaction is set incorrectly when the PIDM field
is populated in the Finance tables, but is invalid.
The routing queue should not be created, the
disposition should remain at 47, and an error message
should be produced, in both the INB forms PHAADJT and
PHAREDS, and in the Flex ECLR application.




A defect was identified in
ThirdPartyAccessPasswordEncoder that resulted in
database connections not being closed

The Encumbrance Override End Date field is shown as:
Encumbrance Override End Date: Mon DD, YYYY




The error "HTTP 404 page not found" will display if
Luminis Channels are used and you are trying to access
the Salary Planner Distribution page from the Employee
Detail or Position Detail web pages.

When adding a member to the routing queue via the Add
Member button, that user, or someone acting as that
users' proxy is unable to act on the report. When this
user or his proxy accesses the effort report, the
action button is not visible to them.




When established as a proxy, and acting as a superuser,
an error message "Current user is not to act as a
superuser" is displayed. See Attachment for steps to
recreate.
Impact
The layout of the Default Earnings area of the
Self-Service page has been updated to provide the
ability to default in the current record and allow it
to be updated. The process will now accept the
effective date of the “current record” when it is
submitted to the database. A check box has been added
to provide the ability to easily remove a record when
it is saved and the box has been checked.
The error message has been improved to include the
earnings code and the date of the record where there
are errors.
Users will now be able to enter an end date that is
one day after the Last Paid Date and will not receive
an error message. The transaction can be submitted and
can then be applied to the database. This change will
enable clients to begin Default Earnings on the first
day of a new pay period as opposed to the second.
Additionally, the process has been updated to check
the required indicator on the Electronic Approval Type
Rules form, NTRAPTY. If the Required checkbox is
checked, the field will be required before it can be
submitted to the approval queue.
RESOLUTION (1-3NV3Q5):
Users will be able to submit transactions for Default
Earnings that contain different effective-dated records
for the same earning code.




Changes were made to convert to ISC standards for
internationalization purposes.

Changes were made to convert to ISC standards for
internationalization purposes.

Changes were made to convert to ISC standards for
internationalization purposes.

Changes were made to convert to ISC standards for
internationalization purposes.

This posting affects one item in an Employee Self
Service page for the Faculty Load and Compensation
module. It is a technical change only to properly
format the label 'Lock Status' on the Employee Status
Summary page. A statement is being revised to translate
the label properly.

The user was unable to access the Employee Position or
the Job Detail pages in Employee Self-Service Salary
Planner, when the NTRSALA data is to large.
This correction expands the amount of data that can
be retreived, so that the data will display properly in
Salary Planner.

This posting includes multiple objects that relate to
processing Time Sheets, Leave Reports and Leave
Requests. In the past, when a period is closed for
employees and approvers to act on time records, records
that were initially started by the employee (In
Progress status) or those that were submitted for
Approval (pending) were inaccessible for processing.


Several changes, including commit by report, have been
implemented to improve lengthy run times for large
numbers of effort reports.

Poor performance issues have been reported for the
supervisor/approver when accessing the Approve or
Acknowledge Time selection, within Web Time Entry. When
timesheets were being accessed through Employee Self
Service by the approver, the compilation of the data
for an Organization took a long time to respond with
the resulting list of employee timesheets. The CURSOR,
orgn_cr, was revised to promote faster performance. An
additional correction was made to insure that Not
Started time records were available for the Approver
and Superuser.
RESOLUTION (1-4AF8KJ):
An error message will be displayed to the user when the
routing queue can not be created due to an error with
the Financial Manager data in the Finance Tables. This
error condition can be caused because the PIDM field
for the Financial Manager has been populated, but is
invalid. An error message is produced to convey the
error in building the routing queue in the Flex ECLR
application. The transaction disposition will remain
at 47 until the data error is resolved.

The ThirdPartyAccessPasswordEncoder contained a defect
that prevented open database connections from being
closed appropriately.

In Salary Planner, the Encumbrance Override End Date
field on the Account Distribution has a Date Display
Format and a Date Input Format that can be set in the
Web Tailor Rules. The Display Format is being
displayed rather than the Date Input Format. Therefore,
if the Date Input Format is different from the Date
Display Format, the user can't tell what format is
required to enter the Encumbrance Override End Date.
If the date is entered in the wrong format, an error
message is displayed: "Encumbrance Override End Date is
invalid. Format is MM/DD/YYYY."
The date format suggested next to the field should
match the data format that the field actually needs.

If using Luminis Channels and trying to access Salary
Planner Distribution page from either the Employee
Detail or Position Detail, you receive an error HTTP
404 page not found.

Users added to the routing queue via the "Add Member"
button we not able to act on the report. This happend
if the user was acting as himself, or if another user
was proxied as the user who was added to the queue.
Now, the user who was added to the queue on the fly,
can act on the report, when logged in and acting as
themselves, or if another user is logged in and proxies
as the on the fly queue member.

When the logged in user who is not an effort reporting
superuser proxies as a user who is a superuser,
security is checked for the logged in user, not as the
proxied person. This is producing a message "Current
user is not that the user does not have the proper
security for the report.
This modification will check the security of the
proxied individual, and if that person is a superuser,
will allow the report to be opened.
Product                                   Readme File Name                Module Release

Banner-Faculty and Advisor Self-Service   p1-4y4mu7_bwl80101_readme.txt          8.1.1.1
Banner-Faculty and Advisor Self-Service   bwl80000d_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80000u_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80001d_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80001u_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80100d_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80100u_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80101d_readme.txt
Banner-Faculty and Advisor Self-Service   bwl80101u_readme.txt
        Faculty SS 8.x Patches
Patch
Date    Defect                   Object(s) Problem
                                           Some links in Faculty Self-Service allow faculty to
4/4/2009 1-4Y4MU7                          access a CRN regardless of whether they are assigned
                                 bwlkfmg1.sql,bwlkffg1.sql It is possible via URL manipulation to
                                           that CRN or not.
Impact
Clients can manipulate the URL and add a CRN parameter
and get to Mid Term and Final Grade and update any
grade.
Product          Readme File Name                   Module             Release Patch Date




Banner-Finance   b_0608_forms_fin80000_readme.txt   General Ledger     8.0.0.1    7/9/2008




Banner-Finance   b_0608_forms_fin80000_readme.txt   General Ledger     8.0.0.1    7/9/2008


Banner-Finance   b_0608_forms_fin80000_readme.txt   Stores Inventory   8.0.0.1    7/9/2008




Banner-Finance   b_0608_forms_fin80000_readme.txt   General Ledger     8.0.0.1    7/9/2008




Banner-Finance   b_0608_forms_fin80000_readme.txt   General Ledger     8.0.0.1    7/9/2008




Banner-Finance   p1-3k60y3_fin80000_readme.txt                         8.0.0.1   8/12/2008
Banner-Finance   p1-3k60y3_fin80000_readme.txt                  8.0.0.1   8/12/2008




Banner-Finance   p1-3k60y3_fin80000_readme.txt                  8.0.0.1   8/12/2008




Banner-Finance   p1-3k60y3_fin80000_readme.txt                  8.0.0.1   8/12/2008




Banner-Finance   p1-3k60y3_fin80000_readme.txt                  8.0.0.1   8/12/2008




Banner-Finance   p1-3k60y3_fin80000_readme.txt                  8.0.0.1   8/12/2008




Banner-Finance   p1-3mbt2j_fin80000_readme.txt   Fixed Assets   8.0.0.1   7/22/2008




Banner-Finance   p1-3o3jm5_fin80000_readme.txt   Budgeting      8.0.0.1    7/1/2008
Banner-Finance   p1-3sljrh_fin80000_readme.txt                      8.0.0.1   7/25/2008




Banner-Finance   p1-3uqi4p_fin80000_readme.txt   Accounts Payable   8.0.0.1   8/13/2008




Banner-Finance   p1-3uqi4p_fin80000_readme.txt   Accounts Payable   8.0.0.1   8/13/2008
Banner-Finance   p1-3wqzo4_fin80000_readme.txt   Purchasing                      8    9/5/2008




Banner-Finance   p1-3wqzo4_fin80000_readme.txt   Purchasing            8.0.0.1        9/5/2008




Banner-Finance   p1-3z3in0_fin80000_readme.txt   Research Accounting   8.0.0.1       10/8/2008




Banner-Finance   p1-407316_fin80000_readme.txt                         8.0.0.1       10/8/2008
Banner-Finance   p1-3ypmpm_fin80100_readme.txt   Research Accounting   8.1.0.1   11/17/2008




Banner-Finance   p1-3yzaez_fin80100_readme.txt   Purchasing            8.1.0.1   11/18/2008




Banner-Finance   p1-42rcj6_fin80100_readme.txt                         8.1.0.1   11/11/2008




Banner-Finance   p1-44e6ts_fin80100_readme.txt   Purchasing            8.1.0.1    12/1/2008




Banner-Finance   p1-40f9sf_fin80200_readme.txt                         8.2.0.1     2/5/2009




Banner-Finance   p1-48d55b_fin80200_readme.txt   Operations            8.2.0.1     4/2/2009




Banner-Finance   p1-4c88fl_fin80200_readme.txt   Accounts Payable      8.2.0.1    5/22/2009




Banner-Finance   p1-4c88fl_fin80200_readme.txt   Accounts Payable      8.2.0.1    5/22/2009
Banner-Finance   p1-4c88fl_fin80200_readme.txt   Accounts Payable   8.2.0.1   5/22/2009




Banner-Finance   p1-4c88fl_fin80200_readme.txt   Accounts Payable   8.2.0.1   5/22/2009




Banner-Finance   p1-4i063r_fin80200_readme.txt   Accounts Payable   8.2.0.1   3/30/2009




Banner-Finance   p1-4isxfx_fin80200_readme.txt   General Ledger     8.2.0.1    2/5/2009




Banner-Finance   p1-4jdqyp_fin80200_readme.txt   Purchasing         8.2.0.1   2/10/2009




Banner-Finance   p1-4m7skf_fin80200_readme.txt   Accounts Payable   8.2.0.1   4/14/2009
Banner-Finance   p1-4m7skf_fin80200_readme.txt   Accounts Payable      8.2.0.1   4/14/2009




Banner-Finance   p1-4mfkiy_fin80200_readme.txt   Fixed Assets          8.2.0.1   4/16/2009




Banner-Finance   p1-4ns1wt_fin80200_readme.txt   Accounts Payable      8.2.0.1   5/22/2009




Banner-Finance   p1-4pmvmh_fin80200_readme.txt   Accounts Payable      8.2.0.1   2/19/2009




Banner-Finance   p1-4pnrh0_fin80200_readme.txt   Research Accounting   8.2.0.1    4/3/2009




Banner-Finance   p1-4pnrh0_fin80200_readme.txt   Research Accounting   8.2.0.1    4/3/2009
Banner-Finance   p1-4pnrh0_fin80200_readme.txt   Research Accounting   8.2.0.1    4/3/2009




Banner-Finance   p1-4zzml9_fin80200_readme.txt                         8.2.0.2   3/19/2009




Banner-Finance   p1-54lflr_fin80200_readme.txt                         8.2.0.1   6/12/2009




Banner-Finance   p1-55hc31_fin80200_readme.txt   Operations            8.2.0.1   5/13/2009




Banner-Finance   p1-56pi83_fin80200_readme.txt   Accounts Payable      8.2.0.1   5/14/2009




Banner-Finance   p1-5i0jzp_fin80200_readme.txt   Research Accounting   8.2.0.1   5/27/2009
Finance 8.x Patches
Defect                Object(s)




1-3NYXA9              fgadcsr.fmb




1-3O2RDP              fgiglac.fmb, fgitbsr.fmb, fgitbal.fmb,


1-3PDJSS              fsareqn.fmb




1-3PZSTT              fgioenc.fmb




1-3Q798A              fgiencb.fmb




1-3K60Y3              fgitbal.fmb
1-3K60Y3   fgitbal.fmb




1-3K60YR   fxiencd.fmb




1-3KWJDS   fpablar.fmb




1-3MMJ6U   ffkedi1.sql




1-3MMJ7I   fbabprc.fmb




1-3MBT2J   ffpoext.pc, ffamast.fmb, ffaadjf.fmb




1-3O3JM5   fgibavl.fmb
1-3SLJRH   fgkb_jvhead1.sql




1-3UF1IJ   faainve.fmb, fakb_invacctg_r1.sql,




1-3UQI4P   faainve.fmb, facicon.fmb, fakb_invitem0.sql,
1-3UN0Z3   fpapurr.fmb




1-3WQZO4   fpapurr.fmb




1-3Z3IN0   fraprop.fmb




1-407316   fragrnt.fmb
1-3YPMPM   frc08091.sql, frc08092.sql, frc08093.sql




1-3YZAEZ   fpapurr.fmb




1-42RCJ6   fam1099.pc




1-44E6TS   fpapord.pc,fpabidd.pc




1-40F9SF   fgrglex.pc, fgrgrbd.pc




1-48D55B   fgrtrni.pc




1-4C88FL   faainve.fmb,fakb_invacctg_r1.sql




1-4WW3ZD   faainve.fmb
1-4YIZL9   faainve.fmb




1-56PWJO   fakb_invacctg_r1.sql




1-4I063R   fpapurr.fmb,fpareqn.fmb




1-4ISXFX   fgractg.pc




1-4JDQYP   foqrpls.pll




1-4M7SKF   fam1099.pc,fapdird.pc,fapcdir.pc
1-50LS75   fapdird.pc




1-4MF1KY   ffkata1.sql




1-4NS1WT   farwhld.pc,farwhly.pc




1-4PMVMH   faivndh.fmb




1-4PNRH0   fraevga.fmb,frpbill.pc,fgractg.pc




1-4YQ619   frrbrev.pc
1-4YQ645   frrbill.pc




1-4ZZML9   fgrgrbd.pc




1-54LFLR   fparrim.fmb,fakb_invhead1.sql




1-55HC31   fgpbody.pc,fgractg.pc




1-56PI83   faqinvp.fmb,fakp_invoice1.sql




1-5I0JZP   frc09051.sql,frc09052.sql,frc09053.sql
Problem
Banner 8 FGADCSR - the following defect corrections were
originally posted in Banner 7.4.0.1 this is the
migration of corrections to Banner 8.
CMS-DFCT70299 - Able to save record in FGADCSR with a
seq_ no that already exists. When the document reaches
posting it will abort with unique constraint error.

Banner 8 corrections for defects originally fixed in
version 7.4.0.1
CMS-DFCT82640
The Index code or Acct code fields on FGIGLAC are not
getting cleared, when navigating from FGIBDST or
FGIBDSR or FGITRND to FGITBSR or FGITBAL and then to
FGIGLAC or when navigating from FGIBDST or FGIBDSR or
FGITRND to FGIGLAC. The Index that was used on the
earlier FGIBDST/FGIBDSR/FGITRND query is displayed in
the key block of FGIGLAC along with the Fund/Acct
associated with that Index.




FSAREQN - NSF checking at Error Level can be
circumvented by re-accessing a document in progress.

Migration of original defect 1-6SUF8 fixed in 7.4.0.1.
On FGIOENC the Fund and Orgn Titles are not changing
when the COA value is changed when the same Fund Code
or Orgn Code exists for both Charts. Mousing out of the
COA field does not reset the description and executing
the query does not reset the description.

FGIENCB displays zero balances for current POs and no
balance at all for prior year POs. Original Defect
CMS-DFCT41041

Attribute 'FORM' missing for the following message:
G$_NLS.Get. Arguments: 'x','x','** Invalid Fund **')
Please check ALL messages in this form for errors
making sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"
Attribute 'FORM' not spelled correctlyfor the following
message:
G$_NLS.Get. Arguments: 'X','FROM','Field must be entered'
Please check ALL messages in this form for errors
making sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Wrong message type for several messages, type needs to
be changed to 'FORM'.
See Attachements for details.

Please review the code to verify if G$_NLS.get should be
removed or replaced by G$_NLS.FormatMsg for following
msg:

Please review the code to verify if G$_NLS.get should be
removed or replaced by G$_NLS.FormatMsg for following
msg:
G$_NLS.FormatMsg('x','FORM',SQLERRM) (occurs 8
times)

Apply 7.4.0.1 defect corrections to Banner 8.0.0.1
FFPOEXT.pc - 1-2B7SEF , CMS-DFCT96735
FFAMAST.fmb
CMS-DFCT51258, CMS-DFCT103386,
FFAADJF.fmb - 1-BX2DU, 1-L8DBA,
CMS-DFCT104443
FFAMAST.fmb - cap record saved without pct if exit from
form without first saving record
Not able to process subseqent capitalization adjustment
records on FFAADJF because cap record is missing
percent.

When the Control Period value on FTMCOAS is "Y" for
Control on Year-to-Date Budget, FGIBAVL does not return
any records if the current date is the last day of a
fiscal period. The problem reoccurs every month end on
the last day.

Apply Banner 7.4.0.1 defect correction 1-2p6pf2 to
Banner 8.0.0.1
When you use the new copy feature on the FGAJVCD and
check the box to Reverse the journal voucher does not
get removed from FGRBAKO when posted. As long as you
don't check the reversal box FGRBAKO is fine.

8x Migration of 7x Invoice patch p1-3iisx2_fin70400
Defects resolved : 1-3IISX2, 1-356TVR, 1-37ASK3,
1-3CXDHJ, 1-3J17X5, 1-391J88, 1-35FFJA, 1-3L2GCK,
1-2PC6OI and 1-37ASHR




8.x migration - defects resolved: 1-2W2OJ5, 1-3O4S8Y,
1-3TR4SV, 1-3SM4BT, CMS-DFCT86749, CMS-DFCT94544
When entering one or more commodity items and you change
the description on all of the items you receive this
message “Do you want the commodity code description to
replace the existing description” for each item, which
is correct. But once you advance to the completion
block you have to click 'NO' again for each description
changed on the commodity block, you should not have to
do it again.

Create a new purchase order on FPAPURR using a
commodity code and start tabbing, the UOM populates
with UOMS from FTMCOMM. Change it to a valid commodity
and keep tabbing, entering my unit price, qty and let
the amounts fill themselves out. Next block
(ctrl+pgdown), the UOM gets switched back to N/A, get
the "Unit of Measure is invalid. Use list." message.

Multiple occurrance of defect 1-3facg6 corrected in
7.4.0.1.
Users who have this problem have form access via a query
class. If the user has a B in fobprof_master_orgn_ind
then they get a "Do you want to save changes" box as
soon as they click on the Personnel tab and can't get
to the data itself. If the user has a Q in the
fobprof_master_orgn_ind, they can get to the Personnel
tab, they receive a message at the bottom of the form
"User is not authorized to query or post with the
entered Organization" and upon closing the form, gets
the "Do you want to save changes" box.

Multiple occurrance of defect 1-23R5O5
A user with query-only access attempts to use this form
but cannot navigate to the Personnel tab.
Users with query-only access have not had this issue
prior to Banner 7.3. It works correctly if the user has
Maintenance rights.
Additional issue: Since 7.3, fragrnt form does an
immediate insert when you are creating a grant from a
proposal. Therefore, the edit in the pre-insert
trigger that says if frbgrnt_status_code is not null
then get_history and then return never is true because
there is no way that frbgrnt_status_code can be
anything but null at this point

Additions, changes, and deletions have been recorded in
the Catalog of Federal Domestic Assistance (CFDA) print
edition update for 2008, and additional New Programs
posted.

FPAPURR 8.0 does not retain the tax amounts calculated
in the commodity window




1099 Misc regulatory updates for calendar year 2008
requires modification to FAM1099 for changes to the
T-record of the IRS file and one parameter that is no
longer reported. The IRS no longer accepts magnetic
files. The name of the FAM1099 process has been changed
to 1099 File Build.

FTMVEND address fields have been lenghthened but creates
an issue with FPAPORD and FPABIDD.




8.x migration of defect CMS- DFCT68696- For concurrent
year transactions, FGRGLEX reports records as out of
balance when they are not. This occurs when entries
have been made to the old year after the budget roll
process has occurred. FGRGRBD will rebuild the grant
ledger incorrectly for concurrent year processing.

Error in FGRTRNI 8.0 'Vendor is not defined' on
deferred edit invoice. Cannot process invoice. Steps
to reproduce:


8x migration of Defect 1-485ZII When a stores PO
receives a commodity, it debits the inventory account
and credits the Inventory clearing. When the invoice
is done on that PO, it is debiting the inventory
account again, instead of the clearing account, thus
overstating the inventory. Also, there is no work
around through Banner.

When the user enters the approved amount for the invoice
but does not tab through to the net amount field, they
get a pop-up box that says POST-TEXT-ITEM. If they
click OK they are able to continue creating the invoice,
but this is time consuming.
8x migration of defect 1-EK8KK. For a bulk load, the
faainve form should be populating the address type and
sequence from vendor defaults. These fields are no
longer populated on FAAINVE.

Error message box "Unable to determine Non Vendor Rule
Class" in FAAINVE when foapal items are split with
taxable and non taxable items. Invoice is document
level accounting and has one taxable and one non
taxable item with separate foapals. User enters amount
in accounting field in account block for taxable items
and then enters the nontaxable foapal, tab to amount
field, enter amount and highlight tax amt and type over
with zero. When user attempts to next block to
balancing and completion, error box appears and invoice
cannot be completed.

Rounding error received when distributing amounts
between more than one FOAPAL.
Invoice against a purchase order for 1 item for $18,264
distributed to 7 accounting lines will not complete.
User encounters error “Accounting amounts are not equal
to commodity amounts”.




Banner 8 - posting is failing when using rule codes YR10
and YR20.
Run Sequence Number:
ORA-01722: invalid number

When using Higher Markets integration for purchase
orders, if the PO has document text in Higher Markets,
it is populating the FPBPOHD_TEXT_IND = Y. Value
should be null (Y is not a valid value, only C, I or
null). When trying to copy a Banner PO with document
text which was created to the eProcurement integration
to a new PO (in Banner), the Copy functionality will
cause the PO to be in suspense (not all header data is
copied in).

change needed to utf-8 format in 1099's submitted to
IRS. Issue will also affect FAPDIRD for ACH
Transcations, and FAPCDIR for Canadian Direct Deposit
Process
The 627 record for CTX format is having field 8 in
positions 55-58 null and not zeroed filled.


FFAADJF version 8.0.0.1 gives error message:
"FRM-40735 KEY-NXTBLK trigger raised unhandled
exception" when trying to do a GL change fund code
process. This occurs only in an Oracle 11 database.
In Oracle 10, this error is not encountered. The
underlying issue is in object ffkata1.sql, not in the
FFAADJF form.

The FARWHLD report total truncates the cents field when
the total amount is greater than 99,999,999.99. The
program assigns position 44-57 for the value, or 14
characters, where 15 characters are required to handle
the 100 mill. values with a dollar sign.




Migration to 8x - fix for defect 1-2ad1yy FAIVNDH 7.3
unable to query on check number - result is Oracle
error : ORA-40735 PRE_QUERY trigger error raised
unhandled exception. Before the 7.3 Banner Finance
upgrade, functionality existed to use FAIVNDH to enter
a vendor code, and then query on specific check number
or check date.

On Fixed Price Billings with multiple bill events and a
reporting event, when you go to do a bill reversal on
FRRBREV the GRBL entry is reversed but the GRDF is not.


8x multiple occurrance of defect 1-3XSH7K. When running
the bill reversal, FRRBREV and you use the date
parameter and input a date that is not the same as the
billing date of the event then the bill gets reversed
but the status_indicator on FRAEVGA does not get reset
to P. Also, if you leave the date parameter blank on
FRRBREV and you reverse a bill, if any subsequent bills
have been satisfied, it changes the status_ind to P on
those subsequent bills.

Multiple occurrance of defect 1-3SHE8J. This past week
FRRBILL was run for a Grant and the submitter used All
instead of specific. So it ran a large number of bills
that we did not intend to run. However, there was a
specific grant whose fund was terminated on FTMFUND,
yet a bill was still created posting general ledger
activity to a terminated fund.

The grant rebuild process fgrgrbd.pc is taking an
abnormal time to complete even when running with Grant
Option (S)pecific and entering one grant

8x migration of resolution for defect 1-418TGI
FPARRIM - if the user performs an Invoice override to N
for No Receipt Required, the invoice will be sent to
posting, will be updated into the FOBAPPD table, and
the invoice document will post. However, the FABINVH
completion indicator will still be R and the approval
indicator will be N. Although the invoice will post
to the ledgers, it may not be selected for payment
because it is not 'approved'.

8x multiple occurence - Posting is rolling back
Purchase Orders that are created from Requisitions
saying the Requisition is closed. Looking at the
Requisition in the ENCP table as well as Requisition
tables the document is not closed. This is caused by
zero dollar, or even >$ 1 line items on the commodity
or accounting pages, but only if these items are not
first in the listing.

Installed 7.3.0.2 invoice patch. Now, creating
multiple commodity items against a stores PO with
multiple line items and when attempting to select items,
receiving message on invoice form...'record already
exists'. The form allows selection of 1 item or all
items, but if there are 3 items on the PO and the user
selects 2 of them, we receive the error.

Additions, Changes, and Deletions have been made to CFDA
data.
Impact
1-32WYT2 - Can change transaction date on a completed
cash receipt sitting in approvals.
CMS-DFCT70299 - Duplicate record created in table
causing posting to abort.




CMS-DFCT82640
The Index code or Acct code fields on FGIGLAC are not
getting cleared, when navigating from FGIBDST or
FGIBDSR or FGITRND to FGITBSR or FGITBAL and then to
FGIGLAC or when navigating from FGIBDST or FGIBDSR or
FGITRND to FGIGLAC. The Index that was used on the
earlier FGIBDST/FGIBDSR/FGITRND query is displayed in
the key block of FGIGLAC along with the Fund/Acct
associated with that Index.
CMS-DFCT95357
While querying transactions on FGIGLAC, the client
attempted to view a Stores RCVD transaction detail on
FPIRCVD. When he selected the 'Query Transaction
Source Info [By Type]' option, the Receiver Document
code did not default into the keyblock on FPIRCVD.

NSF checking at Error Level can be circumvented by
re-accessing a document in progress.

Organization and Fund titles are not updated correctly
for multiple COA.




Banner 8 multiple fix for primary occurrence
CMS-DFCT41041-
FGIENCB showing zero balances for current POs.

The re-key process was run on this object in order for
error messages to be properly sequenced.
The re-key process was run on this object in order for
error messages to be properly sequenced.




The re-key process was run on this object in order for
error messages to be properly sequenced.


The re-key process was run on this object in order for
error messages to be properly sequenced.


The re-key process was run on this object in order for
error messages to be properly sequenced.




Migration of 7.x defects to 8.0
FFPOEXT.pc - 1-2B7SEF , CMS-DFCT96735
FFAMAST.fmb
CMS-DFCT51258, CMS-DFCT103386,
FFAADJF.fmb - 1-BX2DU, 1-L8DBA,
CMS-DFCT104443
FFAMAST.fmb - cap record saved without pct if exit from
form without first saving record
Not able to process subseqent capitalization adjustment
records on FFAADJF because cap record is missing
percent.
RESOLUTION (1-3MBT2J):
Available balances cannot be viewed on the last day of
each fiscal period.




When you use the new copy feature on the journal voucher
entry forms and check the box to Reverse the journal
voucher does not get removed from FGRBAKO when posted.
As long as you don't check the reversal box FGRBAKO is
fine.
RESOLUTION (1-3SLJRH):

Migration of 7x Invoice patches to 8.0.0.1 to keep 8x in
synch with 7.4.0.1 ED posting
A brief description of each defect resolution migrated
into 8.0.0.1 is listed here, with the 7x defect #:
1-3IISX2 Oracle errors on regular pay greater than
999,999.99;
1-356TVR Regular invoice error when penny is split
beyond second decimal point *FB_INVOICE_ACCTG *
Approved Amount ;
1-37ASK3 Accessing document text after entering vend
inv # or 1099 ID produces error message;
1-3CXDJH Invoice stores commodity with price different
from PO - no RUCL IIII posted;
1-3J17X5 Regular invoice FACICON with foreign currency
- get Oracle errors;
1-391J88 Invoice cancelation of Capital asset updated
FARINVA_CAP_AMT incorrectly;
1-35FFJA Direct pay commodity level - unable to enter
a negative amount;
1-3L2GCK when FOMPROF record is restricted to PO
Invoices only- after MVI processing, user gets Oracle
error;
1-2PC6OI FAAINVE enforcing Fund/Org security when
Fund/Org is not enabled on FOASYSC;
1-37ASHR FACICON directly against Blanket Order - user
had to uncheck Access Completion checkbox to create
accounting;
RESOLUTION (1-3UF1IJ):
Migration of 7x Invoice patches to 8.0.0.1 to keep 8x in
synch with 7.4.0.2 ED posting. A brief description of
each defect resolved is included:
1-2W2OJ5 Unable to perform tax override at the
individual tax rate level;
1-3O4S8Y Error encountered if vendor invoice # on
header was deleted;
1-3TR4SV Errors encountered on direct pay invoice if 5
or more FOAPAL's entered;
1-3SM4BT FACICON error when invoicing regular with a
Change Order involved;
CMS-DFCT86749 FACICON vendor invoice date defaults to
system date after reviewing records entered;
CMS-DFCT94544 FACICON navigation to vendor invoice
detail button reorders the numbering of records
Pop up message keeps appearing, even after user has
answered 'NO' to the question " do you want to
commodity code description to replace the existing
description" ?




Users with 'Query' access could not query all windows of
the proposal form. Users were thrown out of the form
when trying to access the Personnel window, for
example. Form gave message "User is running in a query
only mode". The user was not trying to make changes
but merely review the information.




Multiple occurrance of defect 1-23R5O5
RESOLUTION (1-407316):




Additions, changes, and deletions have been recorded in
the Catalog of Federal Domestic Assistance (CFDA) print
edition update for 2008, and additional New Programs
posted.

FPAPURR 8.0 does not retain the tax amounts calculated
in the commodity window. When the user performs a Next
Block to the Accounting window, the tax amounts are
reset to zero. Also, the user received unnecesaary
debugging messages.

1099 Misc regulatory updates to comply with reporting
requirements for calendar year 2008




Fpapord issues an error if you try to print a document
that has more than 38 characters in the address and no
output is printed. Fpabidd has truncation and
incomplete city, state, zip address line when vendor
address is longer than 38.

FGRGLEX.report is displaying incorrect out of balance
conditions for concurrent year transactions subsequent
to the budget roll process being run.
Similar corrections are needed for concurrent year
transactions for the FGRGRBD.pc processs


Invoices set to deferred edit will fail in FGRTRNI and
end up in FGRTRNR error table. No workaround exists.
Uses are unable to utilize deferred edit processing of
invoices in Finance 8.0.

When a regular invoice processed against a Stores PO,
debits the Stores inventory account, which duplicates
the entry made by the Receiver. The Regular Invoice
should debit the inventory clearing account.




In FAAINVE form version 8.1, a Pop-Up Window
POST-TEXT-ITEM appears unexpectedly.
Addresses have to be selected manually when data is
loaded to the fabinvh table without address type and
sequence. FAAINVE fails to retrieve these values using
the vendor pidm and default vendor information.

When an Banner invoice document contains FOAPAL
distributions that are a mixture of taxable and non
taxable, the Invoice accounting API attempts to create
tax records when the invoice accounting sequence has no
tax amount. This scenario causes the "Unable to
determine Non Vendor Rule Class" error.




Two situations 1) In Finance 8.1, if a user processed a
2nd invoice against a PO, the user would get stuck in
the 2nd invoice, with an error that the commodity and
accounting amounts did not agree. The first regular
invoice that was processed against the PO would work
fine, but when a subsequent second invoice was
processed, the user would see the error 2) rounding
errors received when distributing amounts between
mulitiple FOAPAL distributions

The posting process fails when attempting to post a
journal voucher with rule codes YR10 and YR20.




User is unable to Copy a PO which has been created by
the eProcurement integration, if the source PO contains
document text. This is encountered because the PO
Create API is incorrectly setting the FPBPOHD Text
Indicator to Y. The library, FOQRPLS.pll which
performs the Copy PO functionality in the FPAPURR form
is unable to recognize this text indicator, since PO's
created manually by FPAPURR do not set the text
indicator to a Y.

Non-ASCII characters in the database may cause data in
the .lis file to be shifted out of place.
The client's bank is rejecting the fapdird.lis output
because the 627 record for does not have positions
55-58 zero filled.

FFAADJF form in Oracle 11G database, the user is not
able to use function code for a "GL Change - Fund Code"
. User will unexpectedly encounter a KEY-NXTBLK
trigger error when using this in Oracle 11 database.
Problem does not exist in Oracle 10.




On the FARWHLD Report (1099 Reporting/Withholding Status
Report) , the "Reportable" Column (positions 44-57)
truncates the cents field when the reportable amount
exceeds 99,999,999.99. The truncation occurs because
only 14 print positions have been allocated to hold the
reportable amount. Also, the FARWHLY Report has a
similar issue.

Migration of 7x defect fix to 8x - User is unable to
query on check number or check date, beginning with the
7.3 version of FAIVNDH. This functionality was
available prior to 7.3.




When billing and reporting events exist for a similar
date, the bill reversal process creates unbalanced
reversal entries for fixed bills. It fails to find the
Deferred account.

Grant cannot be re-billed after a reversal since the
reversal process is not re-setting the status back to
'P' (Pending).




The Billing Process processes a bill against a grant
that has a terminated fund, when executed for multiple
grants. Process did not fail the edit when run for a
specific fund.
fgrgrbd.pc has very slow performance.
RESOLUTION (1-4ZZML9):


Using the FPARRIM form to change the Receipt Required
indicator to No Receipt Required does not update the
Completion indicator properly. The update made on
FPARRIM will send the invoice document to posting, but
since the Invoice header completion indicator
(FABINVH_COMPLETE_IND) is not changed to Complete, the
invoice may not be selected for payment.




The Posting Process (FGRACTG) rolls back when
encountering accounting records with zero amounts.




On a Stores PO, which contains several commodities,
users are unable to use FAQINVP to select only some
commodity items to be invoiced. An error is
encountered on FAQINVP that the "record already exists"
. The user is not able to navigate beyond FAQINVP to
FAAINVE.
RESOLUTION (1-56PI83):

Additions, changes, and deletions have been recorded in
the Catalog of Federal Domestic Assistance (CFDA) print
edition update for 2008 (revised), and additional New
Programs published.
Product                       Readme File Name                Module Release Patch Date




Banner-Finance Self-Service   p1-3mmj8e_bwf80000_readme.txt           8.0.0.1   8/13/2008




Banner-Finance Self-Service   p1-3mmj8e_bwf80000_readme.txt           8.0.0.1   8/13/2008


Banner-Finance Self-Service   p1-4771tz_bwf80100_readme.txt           8.1.0.1   4/27/2009




Banner-Finance Self-Service   p1-4i0pfz_bwf80100_readme.txt           8.1.0.1   2/12/2009
Banner-Finance Self-Service   bwf80000d_readme.txt
Banner-Finance Self-Service   bwf80000u_readme.txt
Banner-Finance Self-Service   bwf80100d_readme.txt
Banner-Finance Self-Service   bwf80100u_readme.txt
Finance SS 8.x Patches

Defect                   Object(s)      Problem
                                        Please review the code to verify if G$_NLS.get should be
                                        removed or replaced by G$_NLS.FormatMsg for following
                                        msg:
                                        G$_NLS.FormatMsg('x','SQL',caption)
1-3MMJ8E                 bwfkbws1.sql
                                        Please review the code to verify if G$_NLS.get should be
                                        removed or replaced by G$_NLS.FormatMsg for following
                                        msg:
1-3MMJAF                 bwfktra1.sql
                                        Defect 1-4771TZ - FINWEB package bwfktdel is invalid in
                                        11g - PLS-00488 PRTOREC must be a type
1-4771TZ                 bwfktde1.sql
                                        When performing a budget query of type "Budget Status by
                                        Organizational Hierarchy", the organizations in the
                                        hierarchy are shown, but there are no dollar amounts
                                        displayed. If the user drills down into the hierarchy,
                                        the data will then display. The problem can be
                                        intermittent or occur every time. The finance user has
                                        the correct privileges to view the data; it even fails
                                        when they have master fund/org access. This problem can
                                        be caused by known Oracle bug 5903581 which occurs in
                                        Oracle database versions higher than 10.2.0.3.0.
1-4I0PFZ                 bwfkrpk1.sql
Impact
The re-key process was run on this object in order for
error messages to be properly sequenced.




The re-key process was run on this object in order for
error messages to be properly sequenced.


Package cannot compile in Oracle 11 database due to
wrong datatype.

After an upgrade to Oracle database version 10.2.0.4,
client was unable to perform Self Service Budget
Queries with Hierarchy.
Product                Readme File Name                Module                     Release


Banner-Financial Aid   p1-3r6ct5_res80100_readme.txt   Electronic Data Exchange   8.1.0.1




Banner-Financial Aid   p1-40f043_res80200_readme.txt   Electronic Data Exchange   8.2.0.1




Banner-Financial Aid   p1-40f043_res80200_readme.txt   Electronic Data Exchange   8.2.0.1




Banner-Financial Aid   p1-44h07k_res80201_readme.txt   INAS                       8.2.1.1




Banner-Financial Aid   p1-44h07k_res80201_readme.txt                              8.2.1.1

Banner-Financial Aid   p1-47r0t3_res80201_readme.txt                              8.2.1.1




Banner-Financial Aid   p1-4jnxqz_res80300_readme.txt   Common Functions           8.3.0.1




Banner-Financial Aid   p1-4jnxqz_res80300_readme.txt   Student Employment         8.3.0.1
Banner-Financial Aid   p1-4jnxqz_res80300_readme.txt   Loan Processing Check Tracking   8.3.0.1




Banner-Financial Aid   p1-4w5bkl_res80301_readme.txt   Needs Analysis                   8.3.1.1




Banner-Financial Aid   p1-4w5bkl_res80301_readme.txt                                    8.3.1.1




Banner-Financial Aid   p1-4yhgez_res80301_readme.txt   Needs Analysis                   8.3.1.1




Banner-Financial Aid   p1-4yhgez_res80301_readme.txt   Electronic Data Exchange         8.3.1.1




Banner-Financial Aid   p1-4z2835_res80301_readme.txt   Packaging and Disbursements      8.3.1.1
Banner-Financial Aid   p1-5fhmp9_res80400_readme.txt   Packaging and Disbursements   8.4.0.1




Banner-Financial Aid   p1-5fhmp9_res80400_readme.txt   Common Functions              8.4.0.1
           Fin Aid 8.x Patches
Patch Date Defect                Object(s)


 6/24/2008 1-3R6CT5              RERIM09




 10/8/2008 1-40F043              REREX09




 10/8/2008 1-41T4H7              RERIM09




11/14/2008 1-44H07K              RNEIN10




11/14/2008 1-45BXJ1              RPRELRU

11/21/2008 1-47R0T3              RORFS08




 1/20/2009 1-4JNQ3M              RORPOST




 1/20/2009 1-4JNQF2              RJASEME
1/20/2009 1-4JNXQZ   RPALORG




 3/6/2009 1-4W5BKL   RNAPR10




 3/6/2009 1-4FR613   RORHSDP




3/13/2009 1-4YHGEZ   RNAVR10




3/13/2009 1-4XVOGN   RT_ROBALOG_USERACTIVIT_INSUPD




3/17/2009 1-4Z2835   RPEDISB, ROAENRL and RSRENRL
5/6/2009 1-5ELWEZ   RPEDISB




5/6/2009 1-5FHMP9   RORHSDP
Problem


RERIM09 fails with error:
The COD extract does not produce an XML file and prints
java errors in the log file when a student has inactive
COD state or nation codes in the address which were
inactivated with release 8.2/8.2.

If an unmatched ATS exists in the RPRTATS table for the
same ATS ID that is received in an origination or
disbursement response record, the ATS record cannot be
inserted to RPRTATS by RERIM09. When this occurs an
error is provided in the output, but the response is
not loaded leaving the origination and/or disbursement
records in a sent status.

Under certain circumstances, INAS is not correctly
returning the dependency status in the INAR heading and
thus RNINAIQ does not show the correct information. For
example, if a student is a graduate student (only
question to make him/her independent) then IM Formula
field shows IND but EFM Formula shows DEP.

In order to keep the RPRSLND table current with the
active lender for a student and to be consistent with
how RPRELRU updates the lender ID for the loan record,
the RPRELRU process should be modified to update or
insert the lender ID from the Response file.


RORFS08 does not produce a lis file when run in debug mode.
Banner 8.3 Only - The User ID field on RORPOST is used as a
parameter for the RORBPST job to identify the User ID of the
population selection to be used. As of 8.3, this field
is incorrectly updated to the current user when the Use
Indicator is updated and saved.

Banner 8.3 Only - When a student's record is viewed, but not
updated on RJASEME, the rjrsear_activity_date is erroneously
updated to today's date not only for that student, but
for all students in that pay period.

Banner 8.3 Only - Changes to Loan Disbursements cannot
be made on the RPALORG form. When updating a
disbursement, a form error is received. FRM-40738:
Argument 2 to builtin COPY cannot be null. The errors
are due to logging records.

For 2009-2010, the FAFSA individually lists untaxed
income (in past these were part of Worksheet A and B).
Under IM, there are no corresponding data fields and
thus should be included as Untaxed Income. There are FM
fields that are not being mapped to the IM side on the
RNAPR10 form when using the option 'Copy FM to IM'.
The same problem exists with rcfmtoim.sql script. The
fields not being mapped are:
Parent
RCRAPP1_PAR_IRA_DISTRIBUTIONS
RCRAPP1_PAR_UNTAX_PENSIONS

Students for whom "Advanced Placement/International
Baccalaureate Courses" or "Required Courses Similar to
State Scholars Initiative" was updated on ROAHSDT
prior to running RORHSDP may be omitted from the
RORHSDP output completely and their records are not
updated. Others for whom ROAHSDT was not updated at
all prior to running RORHSDP, but are in the popsel,
may also be omitted from RORHSDP output.

When correcting additional financial information and/or
untaxed income on RNAVR10 (8.3.1/7.13), the
associated ISIR record is reflecting the same changes
to the EDE record. This is corrupting the ISIR source
record.

In Banner 8.3, if a change is made to field on an EDE
record and then that same field is changed to something
else before extracting, multiple correction records are
being logged with the same activity date and extracted
to CPS for that field. For example, the AGI is changed
from 13,000 to 20,000. Later, that same student is
updated with the AGI going to 50,000. The field
RCRAPP1_US_INC is logged and displays twice on the
REACORR form. When the REBCD09 process is run, both
correction records are extracted in the correction
file.

After applying 8.3.1, some institutions still encounter
performance issues with RPEDISB, ROAENRL and RSRENRL
when the objects execute code in the ROKMISC package
that references the ROVSTCR view.
RPEDISBS.pco will not compile under VMS. The error
'%COBOL-F-ILLENDIF, END-IF may not be used if NEXT
SENTENCE is used' is received.

When trying to compile rorhsdp.pc using the rccomp.shl
script provided with the Banner Financial Aid 7.14
upgrade, the compile fails on lines 268 which include
the code:
Impact
Pell origination response documents could not be
imported.

The COD extract does not produce an XML file and prints
java errors for inactive states and nations.




Some response records were not loaded, leaving the
origination and/or disbursement records in a sent status.




Dependency status in the INAR report heading and on
RNINAIQ form is incorrect.




RPRELRU is not updating the RPRSLND table with the
lender ID from the response file. This causes a
mismatch in lenders on RPAELAP and RPASLND requiring
manual updates.




Malformed debug messages caused the process to fail.
The User ID on RORPOST is the population selection
parameter, not a "logging" field, updating it to a
current User ID prevents RORPOST from working.




When a student's record is viewed, but not updated on RJASEME, the
rjrsear_activity_date is erroneously updated to today's date not only
for that student, but for all students in that pay period.


Cannot update and insert Loan Disbursements.
RESOLUTION (1-4JNXQZ):
Certain FM columns with no directly corresponding IM
columns were not being mapped to the appropriate
cumulative columns on the IM record.




Students included in the popsel that should have their
records updated in RORHSDT are not updated and are
omitted from the output.




This is corrupting the ISIR source record.
Activity Date (ROBALOG_ACTIVITY_DATE) is updated to a
date when RLRLOGG was run. As a result multiple
correction records are being logged with the same time
stamp for the same field. Multiple correction records
and extracted to CPS for the same field.




Clients are having performance issues with form ROAENRL
and RPEDISB under Oracle 10g.
VMS clients cannot install and run the new version of
RPEDISBS.pco delivered with the 7.14 release.


Certain C compilers do not support C++ single line
style comments. The process is failing to compile
correctly on these platforms.
Product                             Readme File Name                Module




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt


Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt   Packaging and Disbursements


Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt
Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt




Banner-Financial Aid Self-Service   p1-40w2j3_bwr80200_readme.txt
Banner-Financial Aid Self-Service   bwr80100d_readme.txt
Banner-Financial Aid Self-Service   bwr80100u_readme.txt
Banner-Financial Aid Self-Service   bwr80200d_readme.txt
Banner-Financial Aid Self-Service   bwr80200u_readme.txt
Banner-Financial Aid Self-Service   bwr80300d_readme.txt
Banner-Financial Aid Self-Service   bwr80300u_readme.txt
Banner-Financial Aid Self-Service   bwr80301d_readme.txt
Banner-Financial Aid Self-Service   bwr80301u_readme.txt
Banner-Financial Aid Self-Service   bwr80400d_readme.txt
Banner-Financial Aid Self-Service   bwr80400u_readme.txt
                   Fin Aid SS 8.x Patches
Release Patch Date Defect                   Object(s)




8.2.0.1   10/24/2008 1-3Y3BZG               BWRKTRKR


          10/24/2008 1-40W2J3




8.2.0.1   10/24/2008 1-412UPO               BWRKLHST


8.2.0.1   10/24/2008 1-42BU1W               BWRKRHST




8.2.0.1   10/24/2008 1-42C9TZ               BWRKRHST




8.2.0.1   10/24/2008 1-42FOOH               BWRKRHST




8.2.0.1   10/24/2008 1-42RR25               BWRKRHST




8.2.0.1   10/24/2008 1-43G5KM               BWRKRHST
8.2.0.1   10/24/2008 1-43G5M7   BWRKRHST




8.2.0.1   10/24/2008 1-43SG6U   BWRKLHST
Problem
The bwrktrkr.P_DispTrkReq procedure is missing the code
to use the 'DEFAULT' label to display infomation text
on the Student Requirements page.

FinAid role should be set to Yes for
twbkwbis.P_FirstMenu.

If a Lender is not defined on RPRLNDR for Alternative
Loan Lenders, then the information does not display
correctly on Self Service.




The following text is delivered with a typo:
The following error occurs when accepting awards in
self-service.




It is possible to accept below the fund's Award Minimum
when using Firefox as the browser. This appears to be
as result of using browser technology (JavaScript in
this case) to validate using input. JavaScript can
also be disabled either partially or as a whole which
would render this sort of validation useless.




The text on the "Terms and Conditions" tab in Financial
Aid Self-Service incorrectly reads "Term and
Conditions".

On ROAINST, the "Display Accept Award Offer Tab" is
unchecked. However, the "Accept Award Offer" tab still
displays in Self Service when an user has not accepted
the Terms & Conditions. (The user may not select the
tab, but it displays.)
The DL Servicer website address was updated to
www.dl.ed.gov and must be updated on the Loan History
Page and the General Financial Aid Information page.
Impact
Client is not able to add custom information text to the
top of the Student Requirement page.


When a client has only FINAID product installed, he
cannot access the first menu.

Web page Loan Application History may display the wrong
Servicer name if a Lender is not defined on RPRLNDR for
Alternative Loan Lenders.

The web-tailor label RESOURCEMSG for the Resources/
Additional Information tab has grammatical error in it.

The Award Accept Offer web page may fail upon accepting
all awards, if the web accept requirement is also setup
as a fund tracking requirement on RFRMGMT.

The Enrollment Status on web page Award for aid year/
Award Overview tab is displaying an Enrollment status
that is inconsistent with the setup of Estimated
Enrollment on form RPROPTS. The logic for indicator
RPBOPTS_EST_ENROLL_PELL_IND is being used the reverse
of what is intended.

Financial Aid page, Award for Aid Year has two tabs,
Resources/Additional Information and Accept Award Offer,
which uses JavaScript for client side edits that may
cause problems if JavaScript is turned off on the web
browser. The most noticeable problem is the partial
acceptance of an award using an amount less than the
Award Minimum that was set on form RFRMGMT for that
fund.
RESOLUTION (1-42RR25):
On web page "Award for Aid Year", the tab name for
"Terms and Conditions" is misspelled.


The "Accept Award Offer" tab should not display if it is
unchecked on ROAINST.
Impact:
On web page "Award for Aid Year", if the "Display
Accept Award Offer Tab" is unchecked on ROAINST and the
"Terms and Conditions" have not been accepted, the
"Accept Award Offer" tab is still visible. If the
"Display Accept Award Offer Tab" is not set, then the
"Accept Award Offer" tab should not shows.

Banner Financial Aid Self-service has several links to
"www.dlservicer.ed.gov" that need to be updated.
Product          Readme File Name                   Module   Release




Banner-General   b_0708_forms_gen80000_readme.txt            8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt            8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt            8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt            8.0.0.1
Banner-General   b_0708_forms_gen80000_readme.txt   8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt   8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt   8.0.0.1




Banner-General   b_0708_forms_gen80000_readme.txt   8.0.0.1
Banner-General   b_0708_forms_gen80000_readme.txt                    8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3f9l53_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3jn5p3_gen80000_readme.txt      Job Submission   8.0.0.1
Banner-General   p1-3lpst5_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3lpst5_gen80000_readme.txt                       8.0.0.1




Banner-General   p1-3lpst5_gen80000_readme.txt                       8.0.0.1


Banner-General   p1-3zvaj3_gen80000_readme.txt                       8.0.0.1




Banner-General   b_0109_gen80100_readme.txt                          8.1.0.1




Banner-General   b_0109_gen80100_readme.txt      Events Management   8.1.0.1
Banner-General   b_0109_gen80100_readme.txt           Events Management   8.1.0.1

Banner-General   b_0109_gen80100_readme.txt                               8.1.0.1




Banner-General   b_0109_gen80100_readme.txt           System Functions    8.1.0.1




Banner-General   b_0109_gen80100_readme.txt                               8.1.0.1




Banner-General   b_1208_c_gen80100_readme.txt         Letter Generation   8.1.0.1




Banner-General   b_1208_c_gen80100_readme.txt         Job Submission      8.1.0.1




Banner-General   b_1208_dbprocs_gen80100_readme.txt                       8.1.0.1




Banner-General   b_1208_dbprocs_gen80100_readme.txt   System Functions    8.1.0.1


Banner-General   b_1208_dbprocs_gen80100_readme.txt                       8.1.0.1
Banner-General   p1-3ioxpg_gen80100_readme.txt           Letter Generation   8.1.0.1


Banner-General   p1-414bw9_gen80100_readme.txt           Common Matching     8.1.0.1


Banner-General   p1-44agop_gen80100_readme.txt                               8.1.0.1

Banner-General   p1-46c8mj_gen80100_readme.txt                               8.1.0.1




Banner-General   p1-46c8mj_gen80100_readme.txt                               8.1.0.1




Banner-General   p1-4gogvs_gen80100_readme.txt           Class Schedule      8.1.0.1


Banner-General   p1-4hewb4_gen80100_readme.txt                               8.1.0.1




Banner-General   p1-4votue_gen80100_readme.txt                               8.1.0.2




Banner-General   p1-4y82ij_gen80100_readme.txt                               8.1.0.1
Banner-General   banner8_forms_conv_toolkit_readme.txt
Banner-General   banner8_ProC_conv_toolkit_readme.txt
Banner-General   bannerOH2008aprilinstructions.txt
Banner-General   p1-5by3f3_bws080101_readme.txt
Banner-General   PERL ReadMe.txt
           General 8.x Patches
Patch Date Defect                Object(s)




 7/16/2008 1-3K60ZC              gjarslt.fmb




 7/16/2008 1-3K60ZY              glrslct.fmb




 7/16/2008 1-3K610J              glrvrbl.fmb




 7/16/2008 1-3K6114              goamtch.fmb
7/16/2008 1-3K612A   gsadsec.fmb




7/16/2008 1-3K612V   gtvintp.fmb




7/16/2008 1-3K613G   gtvrrac.fmb




7/16/2008 1-3K6141   guqintf.fmb
7/16/2008 1-3K6187   gsaaudt.fmb




7/16/2008 1-3F9L53   gokcmpk1.sql, gokoutd1.sql, gspvpds.sql, goqrpls.pll,




7/16/2008 1-3F9LHP   guqwutl.fmb




7/16/2008 1-3J332P   gspauth.sql




7/16/2008 1-3K611P   goriccr.fmb




7/16/2008 1-3K617M   gsasecr.fmb




7/16/2008 1-3KWJEG   gspsecr.sql




 6/5/2008 1-3JN5P3   banorep_10_1_2_3.jar
7/11/2008 1-3CTAL5   goatpad.fmb




7/11/2008 1-3L93LL   gokb_third_party_a1.sql




7/11/2008 1-3LPST5   goatpad.fmb


9/30/2008 1-3ZVAJ3   gobansri_080000.sql, gobansru_080001.sql




1/30/2009 1-41BD42   goaqstn.fmb




1/30/2009 1-4301AP   geafunc.fmb
 1/30/2009 1-4301AP   geafunc.fmb

 1/30/2009 1-46509B   gtvadid.fmb, gtvdicd.fmb, gtvdocm.fmb, gtvsrce.fmb, gtvviss.fmb




 1/30/2009 1-47L4UK   gokb_third_party_a1.sql




 1/30/2009 1-4GW6T9   goatpad.fmb




12/11/2008 1-42W01Z   gurinso.pc




12/11/2008 1-43H850   gurirol.pc




12/12/2008 1-3PDGRC   gutuprf0.sql




12/12/2008 1-45BX71   goklib1.sql


12/12/2008 1-477U5S   gspsecr.sql
12/11/2008 1-3IOXPG   GLBLSEL.pco


  4/7/2009 1-414BW9   gokcmpk1.sql


12/12/2008 1-44AGOP   spridenu_080101.sql

11/18/2008 1-46C8MJ   gokp_cardholder0.sql




11/18/2008 1-46WCJX   common_resources.xsd




 2/19/2009 1-4GOGVS   gokb_classtimes1.sql, gokb_classtimes_r1.sql


 2/19/2009 1-4HEWB4   gokrsq1.sql




 4/15/2009 1-4VOTUE   gokrsq1.sql




 3/24/2009 1-4Y82IJ   gokp_person_identity1.sql
5/5/2009 1-5BY3F3   correct_ccard_rule_08010101.sql
Problem
Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','No results were found;
no action permitted.'
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' is missing for the following message:
G$_NLS.Get. Arguments: 'x', 'x','*ERROR* Date format
must be ''%01%'' (including quotes '''')',
g$_date.translate_format(null))
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' is missing for the following message:
G$_NLS.Get. Arguments: 'x', 'x','*ERROR* Date format
must be SYSDATE (without quotes) or
'''||G$_DATE.GET_NLS_DATE_FORMAT||''' (including quotes)
')
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','*ERROR* Cannot create
a new person without a first name.'

Attribute 'FORM' missing for the following message:
G$_NLS.Get. Arguments: 'x', 'x','*ERROR* Cannot delete
master record when matching detail records exist.'
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','This record cannot be
deleted since it exists in the database table %01%',
code_table
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','Race code must be
entered.
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','*Error* You do not
have permission to perform these updates. Processing
may be incomplete.'
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' is missing for the following message:
G$_NLS.Get. Arguments: 'x','x','Yes'
Please check ALL
messages in this form for errors making sure that:
- FORM is not spelled in lower case
- FORM is spelled
correctly, not 'FROM' or 'FORMS' or 'FORM ' (note the
space at the end)
- it does not use an "x" instead of attribute "FORM"

Several objects are missing G$_NLS.get calls for
translatable strings/messages.
Remove the English text that may be used in the logic of
the code - IF conditions.

Remove g$_NLS.get. Some objects are using g$_NLS.get
call when no translation is needed. Those calls should
be removed.

A user is able to perform an extended query when
assigned the BAN_DEFAULT_NO_ACCESS role. This should
not occur.


Attribute 'FORM' should be spelled all caps for the
following message:
G$_NLS.Get. Arguments: 'x','form','*ERROR* Setting must
match Key Block Setting.'
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Attribute 'FORM' missing for the following message:
G$_NLS.Get. Arguments: 'x','x','Remove existing
permissions from user %01%?',:user_block.user_id
Please check ALL messages in this form for errors making
sure that:
- FORM is not spelled in lower case
- FORM is spelled correctly, not 'FROM' or 'FORMS' or
'FORM ' (note the space at the end)
- it does not use an "x" instead of attribute "FORM"

Invalid message type, should be 'SQL' for following
message:
**TMERROR** Invalid Message Type 'x' in G$_NLS.Get.
Arguments: 'x','x','LOGIN NOT FOUND')

Defect #1-3GSD7J - GJAPCTL Hangs with blank screen in
OAS 10.1.2.3


Navigation problem - previous block from Current Third
Party ID block and cursor disappears. It should make
the Verify Answers tab enabled and the cursor should
land in the first Verify Answers block.

Test Case 1:
on GOATPAD, check the 'accepted' checkbox for a user and
save
then reset the PIN for a user to 111111 and save
go to SSB and log in using that PIN, then log out
go back to GOATPAD, and uncheck the 'accepted' checkbox
go to SSB and attempt to login using 111111 and get
invalid username or PIN


Third Party ID reset button does not work
Test Case:
On GOATPAD, access a user
If they have a Third Party ID,
remove it and save.
Now click the reset/maintenance button to the right of
the Third Party ID field
It should set the ID and insert a record into the Third
Party ID History Tab.
Right now it doesn't do anything.
You can manually type
in a Third Party ID and save it (which is correct)
We need the button to set the Third party id using the
setting on GUAPPRF for length of last name

Defect 1-3ZVAJ3 - GOATPAD results in *ERROR* Answers not
verified for Gen80 INITIAL_LOAD records

Most of the fields on this form are missing the
'implementation class' property
'com.sct.banner.forms.ui.BannerCharField' and therefore
you don’t see the full value when you position your
cursor over the field. Fields are missing this as well
as the Subclass information on this form.

In the LOAD_FORM_HEADER trigger the format mask
G$_DATE.GET_NLS_DATE_FORMAT has been changed back to
DD-MON-YYYY.
When you run Banner INB with a different Date format
(i.e. YYYY-MM-DD) you will get an error when you call
SLIAEVN from another form (like GEAFUNC).
This change affects the CURRENT_DATE, BEGIN_DATE and
END_DATE.
SDE does not change when scrolling through records
Defect 1-47L4UK - Third party History
(GORPAUD_EXTERNAL_USER) is not being updated if GENPIN
flag pin encryption is N.

Seems like GOATPAD has not been date ripped in batch
date rip process,
missing date rip Audit trail seems to confirm this.
It
is using a hardcoded date that leads to performance
failure
When you run with French settings (date format=DD/MM/YYYY)
you get an ORA-650

Defect 1-42W01Z - Banner 8 GURINSO incorrectly loads the
GLRLETR DOC file when it contains variables that return
multiple values.

Defect 1-43H850 - Running GURIROL 8.0 on Windows results
in *ERROR* Cannot open file: aborting job - gurirol
terminated with error

Banner INB LDAP SSO SSL "Access Denied" error message
in the browser. The Wallet Password is entered in clear
text into GUAUPRF.
The trigger on GURUPRF which encrypts the LDAP password
(gutuprf0.sql) does not encyrpt the SSL password (the
Wallet Password). Yet the goksss1.sql which decrypts
the LDAP password attempts to decrypt the SSL password
(the Wallet Password)
even though it's not encrypted.
if f_string = 'PASSWORD' and f_key = 'SSL' then

If you are running GUAPPRF with Numeric Random Pins and
then
generate Pins on GOATPAD or GORTPAC process you will
notice
the pine are created in a sequential order with a 3
digit gap between pins.

Defect 1-477U5S - Problem with Oracle Logoffs trigger
GT_LOGOFF_AUDIT_ACCESS - ORA-00060 Deadlock detected

Defect #1-37BVW6 - GLBLSEL 7.5 version no longer
produces INSERTS with Parameter 12 = Y
Common Matching (GOAMTCH) performance problem with
package GOKCMPK (gokcmpk1.sql)

Related to 1-2YT4AP - script needed to convert existing
records


New API is added to handle SyncEligibleCarholders process
Make the corresponding changes to SubscriberNumber and
LegalName to support Banner table changes
increase maxLength value attribute of SubscriberNumber
element to 12 ()
increase maxLength value attribute of LegalName element
to 500 ()

SSRROLL is not rolling the Hours Per Week. Previously
for arranged course sections (those without days and
times), the Hours Per Week rolled from term to term
when SSRROLL was run. In 7.4, the Hours Per Week did
not roll for these sections. There are many sections
without meeting times, and before we can assign an
instructor, Hours Per Week needs to be there.

Defect 1-4HEWB4 - GORRSQL errors with - ORA-01008 not
all variables bound - resulting from package GOKRSQL

Defect 1-4VOTUE - GORRSQL errors with - ORA-01008 not
all variables bound - resulting from package GOKRSQL




The API does not seems to handle parameters beyond name
correctly. One specific case includes the birth day,
month, and year fields. When these are populated in a
manner that results in a match on GOAMTCH, the same
entry via the Web service/API does not yield a match.
Additionally, Web service/API includes additional
identities that are neither a match or a possible
match.
Impact
Strings not translatable, would show in English in
language versions




Strings not translatable, would show in English in
language versions




Strings not translatable, would show in English in
language versions




Strings not translatable, would show in English in
language versions.
Strings not translatable, would show in English in
language versions.




Strings not translatable, would show in English in
language versions.




Strings not translatable, would show in English in
language versions
G$ makes string translatable, string if translated would
cause logic to fail at runtime


The BAN_DEFAULT_NO_ACCESS was not being checked in
situations where access was being checked, but not
granted. This was limited to quasi-objects such as
EXTENDED_QUERY.

Strings not translatable, would show in English in
language versions




This applies ONLY to those running the internet native
Banner7.x using Oracle Application Server version
10.1.2.3 (aka AS10gR2 release 3). When using

When you try to navigate to previous block staying in
Third Party ID block ,cursor disappears.It should make
the Verify Answers tab enabled and the cursor should
land in the Verify Answers block.

In 8.0, users receive an error message of "999 minute
inactivity caused web session timeout" and are sent
back to the login screen after they have accepted the
Terms of Usage page when trying to login to
Self-Service.
Checking checkboxes resets PIN to a random value.After
this
you won't be able to login to SSN unless untill you
reset the pin in GOATPAD.

Third Party ID reset Button does not work correctly.If
you press Third Party ID reset button
it should generate a new ID which is not happening.




Some users' security question answers -- specifically,




Code will be passed to the SLIAEVN form correctly.
RESOLUTION (1-4301AP):
Third party History (GORPAUD_EXTERNAL_USER) is not being
updated if GENPIN flag pin encryption is N.




While reading data from .doc file, GURINSO incorrectly
loads the GLRLETR DOC file when it contains variables
that return multiple values.




If you are running process GLBLSEL with parameter 12
(Detailed Execution Report) = 'Y', It no longer
provides the INSERT debugging details
For example: The below type of debugging detail is
missing
INSERTING GLRCOLR :
Performance problems with Common Matching
RESOLUTION (1-414BW9):




When certain sql statments are executed in GORRSQL the
error -ORA-01008 not all variables bound is displayed

1. GORRSQL errors with - ORA-01008 not all variables
bound - resulting from package GOKRSQL.
2. After running invalid sql statements for while
-resulting ORA-01001 Invalid Cursor.
Product              Readme File Name                     Module Release Patch Date




Banner-Web General   b_0708_dbprocs_bwg80000_readme.txt           8.0.0.1   7/16/2008




Banner-Web General   b_0708_dbprocs_bwg80000_readme.txt           8.0.0.1   7/16/2008




Banner-Web General   b_0708_dbprocs_bwg80000_readme.txt           8.0.0.1   7/16/2008


Banner-Web General   b_0708_dbprocs_bwg80000_readme.txt           8.0.0.1   7/16/2008




Banner-Web General   p1-508z7l_bwg80101_readme.txt                8.1.1.1   4/13/2009
Banner-Web General   bwg80000d_readme.txt
Banner-Web General   bwg80000u_readme.txt
Banner-Web General   bwg80100d_readme.txt
Banner-Web General   bwg80100u_readme.txt
Banner-Web General   bwg80101d_readme.txt
Banner-Web General   bwg80101u_readme.txt
Gen SS 8.x Patches

Defect               Object(s)      Problem
                                    Hardcoded $: twbkfrmt.P_TableData ('$'||amount_in);
                                    should use a to_char(amount_in,'L999G999G990D00') or
                                    similar to allow for use outside of US.
1-1AD9PH             bwgkccr1.sql
                                    Some msg in BWGKOAD1 have G$.NLS_get in code but don't
                                    seem to be translatable items:
                                    like 'fieldlabeltext' (5 times)
1-33TKIN             bwgkoad1.sql
                                    BWGKOAD1 is missing G$_NLS.get calls for translatable
                                    strings/messages. Check to make sure that no English
                                    text is used in the logic (like IF conditions).
1-3F9L5S             bwgkoad1.sql
                                    Please review the code to verify if G%_NLS.get should be
                                    replaced by G$_NLS.FormatMsg for following msg:
1-3MMJC9             bwgkoad1.sql
                                    Users with the Fin Aid Role see the "Type of Address to
                                    Insert" drop down box when all address types on GOADDRL
                                    are set to Display (not Update).
1-508Z7L             bwgkoad1.sql
Impact




Strings not translatable, would show in English in
language versions.


Strings not translatable, would show in English in
language versions


Strings not translatable, would show in English in
language versions.
Product                  Readme File Name




Banner-Human Resources   p1-3qoy9k_pay80000_readme.txt




Banner-Human Resources   p1-3xszt3_pay80000_readme.txt




Banner-Human Resources   p1-3xszvz_pay80000_readme.txt




Banner-Human Resources   p1-40essx_pay80000_readme.txt




Banner-Human Resources   p1-40essx_pay80000_readme.txt


Banner-Human Resources   p1-3yncib_pay80100_readme.txt
Banner-Human Resources   p1-441c87_pay80100_readme.txt




Banner-Human Resources   p1-441c87_pay80100_readme.txt




Banner-Human Resources   b_0209_forms_pay80101_readme.txt
Banner-Human Resources   b_0209_forms_pay80101_readme.txt




Banner-Human Resources   b_0209_forms_pay80101_readme.txt




Banner-Human Resources   b_0209_forms_pay80101_readme.txt


Banner-Human Resources   b_0209_forms_pay80101_readme.txt




Banner-Human Resources   p1-3i0dx0_pay80101_readme.txt




Banner-Human Resources   p1-48qf1f_pay80101_readme.txt
Banner-Human Resources   p1-4cx0v7_pay80101_readme.txt




Banner-Human Resources   p1-4d3g1o_pay80101_readme.txt




Banner-Human Resources   p1-4dhenh_pay80101_readme.txt




Banner-Human Resources   p1-4kg6j2_pay80101_readme.txt
Banner-Human Resources   p1-3i950l_pay80102_readme.txt




Banner-Human Resources   p1-4k8om5_pay80102_readme.txt




Banner-Human Resources   p1-4kahgn_pay80102_readme.txt




Banner-Human Resources   p1-4kipx6_pay80102_readme.txt
Banner-Human Resources   p1-4lyfjd_pay80102_readme.txt




Banner-Human Resources   p1-4lyfjd_pay80102_readme.txt




Banner-Human Resources   p1-4tv8lf_pay80102_readme.txt




Banner-Human Resources   p1-4tv8lf_pay80102_readme.txt




Banner-Human Resources   p1-4y37uh_pay80102_readme.txt
Banner-Human Resources   p1-4y37uh_pay80102_readme.txt
                                                     HR 8.x Patches
Module                            Release Patch Date Defect




                                  8.0.0.1    8/19/2008 1-3QOY9K




Benefits Administration           8.0.0.1   10/30/2008 1-3XSZT3




Employment Compensation Admin     8.0.0.1   10/30/2008 1-3XSZVZ




Payroll Proc and Adjts Time Rep   8.0.0.1   10/30/2008 1-40ESSX




                                  8.0.0.1   10/30/2008 1-40FJGK


                                  8.1.0.1   11/20/2008 1-3YNCIB
8.1.0.1   11/21/2008 1-42ZZME




8.1.0.1   11/21/2008 1-441C87




8.1.1.1    2/27/2009 1-1AJBQ3
Benefits Administration         8.1.1.1    2/27/2009 1-2UWXY5




Applicant Tracking              8.1.1.1    2/27/2009 1-305BU4




Applicant Tracking              8.1.1.1    2/27/2009 1-338FTT


Employment Compensation Admin   8.1.0.1    2/27/2009 1-3NK5LP




Benefits Administration         8.1.1.1    2/19/2009 1-3I0DX0




Payroll Adjustments History     8.1.1.1   12/19/2008 1-48QF1F
                     8.1.1.1   12/21/2008 1-4CX0V7




Payroll Processing   8.1.1.1   12/21/2008 1-4D3G1O




Regulatory           8.1.1.1    1/13/2009 1-4DHENH




                     8.1.1.2    1/30/2009 1-4KG6J2
Employment Compensation Admin   8.1.2.1    6/3/2009 1-3I950L




Payroll Processing              8.1.2.1   4/14/2009 1-4K8OM5




                                8.1.2.1    5/4/2009 1-4KAHGN




Time Reporting                  8.1.2.1   4/28/2009 1-4KIPX6
Time Reporting                  8.1.2.1   6/17/2009 1-2BJTWQ




                                8.1.2.1   6/17/2009 1-4LYFJD




                                8.1.2.1    4/2/2009 1-4TV8LF




Employment Compensation Admin   8.1.2.1    4/2/2009 1-50TW76




                                8.1.2.1   4/28/2009 1-4Y37UH
8.1.2.1   4/28/2009 1-4Y37UH
Object(s)




PHPFEXP.pco




pdadedn.fmb




pea1pay.fmb




phpcdir.pc




phpcdir.pc,pgtvsdaxi_40fjgk.sql


pdpf496.pc,pdpmr87.pc,pdppers.pc,pepaext.pc,
peaempl.fmb,




periped.pc,




ppaiden.fmb
ptrbdca.fmb,ptrearn.fmb




paaappl.fmb




paaapos.fmb


peijtot.fmb




pdkded1.sql




phklrrt1.sql,phkreds1.sql
periped.pc




pxkb_w2_federal1.sql




pxaw2cc.fmb




periped.pc
phptime.pc




pxrtdep.pc




peppcre.pc




phrtmsh.pc
phatime.fmb




pektecm.sql,




pdppers.pc,pdpf496.pc,pxpmroe.pc,pxrroec.pc




pxpmroe.pc




poqlibr.fmb
poqlibr.fmb
Problem
Slow performance is experienced when payrolls being
processed are extremely large and employee jobs
typically have multiple funding splits.

When a terminated deduction is re-activated, the
deduction end date is automatically removed. If the
re-activation status record is removed, the deduction
end date is not re-populated with the terminated status
effective date value.




On save the PEA1PAY address record is being inserted
with a null From Date. The address record is inserted
successfully, however the null in the From Date (in
PPAIDEN) prevents the address record from being
selected by processes run that select addresses by
comparing From Date to the system date.

The process may not select anyone for processing. This
is due to the direct deposit upon demand enhancement
delivered in the 6.0 Human Resources release. The
problem originates in the function check_payno, where
the check date for the event is selected into a
variable that has a timestamp appended. The function
does not accomodate the situation where the phrdocm
check date may have more than 1 value in the
phrdocm_seq_no field.

File may be rejected due to differing formats between
the Royal Bank and CIBC from the default CPA-005
specification.




To convert utf8 to ASCII format.
The new functionality on PEAEMPL will not allow
non-faculty to be reported as Primarily Public Service.
The instructions allow for non-faculty positions to be
identified as Primarily Public Service. The
description of Primarily Public Service from the
instructions does permit this type of classification.
Primarily Public Service (PPS) Persons whose specific
assignments customarily are made for the purpose of
carrying out public service activities such as
agricultural extension services, clinical services, or
continuing education and who may hold academic rank
titles of professor, associate professor, or assistant
professor. In addition, we have confirmed through the
their staff this reporting is allowable. We can
provide contact information if needed.

A. periped.pc - Part L New Hires section, the primary
function is being incorrectly reported.
B. periped.pc - Customized skill codes are not being
reported/included in "Part A - Employees Assigned by
Position" report section of PERIPED.
C. periped.pc Fringe amounts are reported double for
anyone having more than one job marked as IPED
D. periped.pc I18N conversion did not convert string
array causing jumbled benefit descriptions.
E. pconvipedsprimfunct.sql The IPEDs conversion script
delivered with release 7.2.4 pconvipedsprimfunc.sql
needs to check that jobs are active.
F. pxrrboxu_441c87.sql On the fringe benefit amounts
summary page, the title "Other Life Insurance" should
match the IPEDS reporting requirements and read Other
Insurance Benefits. See attach for more info.

Canadian institutions - PPAIDEN defaults zeroes into the
SIN field when a person record is queried and the SIN
field is blank. The field should remain blank.

When the index code is inactive and the user accesses
the LD Overrides on PTRBDCA, you receive an error
message that the index code is inactive. After
acknowledging all the error messages, the form comes
back blank, stating there are no records to retrieve.
The user cannot bring back any records to change the
index. If you perform a query to retrieve the records
in the PTRBDLD table, then the user receives the same
error messages and the form still does not display the
records.
Applicant data is entered on PAAAPPL and the interview
and status information is populated. Then the position
class is changed on NBAPOSN for that particular
position. When the user changes the Source field, an
error 'Posn Class change not allowed with existing
Status/Interview data' displays. The Source field can
be changed if there is no change to position class.

PAAAPOS allows you to enter a position that is not
associated with the requisition entered. Steps to
reproduce are as follows.

The earn code lov (record group) doesn't list the
earnings in alphanumeric order in 10g.

When using this process to re-activate life insurance
deductions, the following error messages will display
in the .lis file:




The history jobs disposition is not properly updated
when processing a labor redistribution via PHAREDS and
PHAADJT. After submitting a redistribution, the
employee history disposition is correctly updated to 60,
but the history jobs disposition remains at 48. Both
dispositions should advance to 60.




UPDATE 12/12/2008 - Issues to be corrected with this
update:
1. EAP, Part C - Graduate students are counted with
part-time, rather than in their own column.
2. EAP, Parts A & B - Non-faculty (Executives,
Professionals, and Other Administrative Staff) without
faculty status are counted in the non-tenured column,
rather than in the "Without Faculty Status" column.
3. Salaries, Parts D, E, and F - Selection should be
only F.T. Instructional Staff - Primarily Instruction &
Instruction combined with Research & Public Service
4. Salaries, Part F - Summary totals do not display for
9/10 Month F.T. instructional staff, when no 11/12
month F.T. Instructional staff exists.




It appears that the PXRW208 process is querying for the
max control number as they process each row. This
should be changed to get max once and store it in a
variable in the program where you increment it before
inserting the next row into the table.

1) When an employee has a long last name with special
characters, the following error can occur on the
PXAW2CC form:
FRM-40831: Truncation occurred: value too long for field
PXRW2FD_EMPL_LAST_NAME.
A W-2c can not be created or viewed and no workaround
exists.




In sections A and B of the EAP, skill codes 1x and 3x
are being reported as "Not on tenure track/no tenure
system" when the employee does not have a faculty
record. The employee should be reported as "Without
faculty status.

This defect addresses both 1-2TICMM and CMS-DFCT80918
defects.
The program is not calculating the total days in the pay
period (per_length) correctly for salaried employees
who start a job in the middle of the pay period.
When the person's job ends during the pay period, the
program uses the work schedule for the entire pay
period to calculate the # of days. This is correct.
When the person's job starts during the pay period, the
program uses the work schedule during the person's job
days, but uses the "standard" calendar for the part the
employee didn't work which creates a higher percent of
time worked and consequently causing the employee to be
overpaid.
*** This defect must be fixed together with Defect #
CMS-DFCT80918 ***




UA is working on the upgrade to Release 7.2.6. The
upgrade has been installed a test environment. When
PXRTDEP is run in PROD and FEVL (test environment) for
the first quarter 2008 the results are different.

The Pension Credit process is working correctly and the
output from PEPPCRE shows the Pension Credit and
Pensionable Service; however the Pension Credit
Override and Pensionable Service Override do not show
up on the PEPPCRE output. I have entered override
amounts on PEAPCRE and then ran the T4's and the
override figures are appearing correctly on the T4's
but not on the PEPPCRE output.

Banner 8 Pro*C phrtmsh runtime error - ORA-01480:
trailing null missing from STR bind value.
Reproducible on Banner 8 32-bit and 64-bit Linux
platforms when submitted from host prompt. Patch
p1-40WK37 has been applied to 64-bit environment.
Not reproducible in 32-bit Linux when submitted from Job
Submission environments.
Not reproducible in 32-bit Windows when submitted from
Job Submission environments.




If an employee has more than one job, PHATIME brings
back the jobs in random order. This order can change
each time you enter the form. This is only a problem
when using Oracle 10g because previous versions of
Oracle had an inherent order by, but 10g doesn't.




Leave Request/Leave Reports and timesheets from past
time periods in pending status are displaying in the
Time Approval channel once the pay period is open for
time entry. The approver is seeing these because the
Leave Requests were not approved prior to the timesheet
opening. No action can be taken on the leave requests
by the approver to remove them from the channel which
is causing some confusion.




Due to the internationalization changes in 8.0, the
pdppers process is creating the PDPPERS.ext file with
formatting information, but no formatted data.

The ROE's Total Insurable Hours are not calculated
correctly in process PXPMROE.




Cause: The payroll 8.1.2 upgrade rebuilds the perbfml
table and poqlibr.fmb is not redelivered to reflect the
changes
FRM-30064: Unable to parse statement select PERBFML_YEAR,
PERBFML_YEAR_BEGIN,
PERBFML_YEAR_END, PERFMLA_BEGIN_DATE, PERFMLA_STATUS_DATE,
Impact
The performance of the process has been significantly
improved.


A problem was reported when a deduction was reactived
from a Terminated Status and the user removes the new,
reactivated record. The Deduction End Date was not
being repopulated, consistent with the Terminated
record. This has been corrected so that when this
situation exists, the form will automatically
repopulate the End Date on the base record. This
ensures that the the base record and the
effective-dated record are in accordance with the
Termination.
RESOLUTION (1-3XSZT3):
If an Address From Date has not been entered when the
record is saved, the system date will be entered as
part of the identification record.




1) Process may not select adjustments for processing.
2) SIN should not be used in the output file.




Characters will be coverted correctly from utf8 to ASCII
format in the flat files.

The edits on the form have been changed so that the only
selection with an edit will be Primary Instruction.
When Primary Instruction is selected, the edit will
require that the person's job has a pcls with 20 or 80.
No edits will be applied to any other item in the
pull-down list.
A. periped.pc - In the Part L New Hires section of the
report, the primary function was being incorrectly
reported. It has been updated to determine the value
based on the IPEDs Primary Function field on PEAEMPL.
B. periped.pc - Customized skill codes were not
being reported/included in "Part A - Employees Assigned
by Position" report section of PERIPED. A customized
skill code is one that has a non-zero value in the
second position of the skill code. An example of
customized skill codes would be, 2A, 21, 23 24; the
data for these skill codes now rolled up in the skill
code 20 data. This will insure that the report is
consistent when using employee skill codes.
C. periped.pc - Fringe amounts are no longer being
reported twice for anyone having more than one job
marked as IPEDs reportable.

Canadian institutions - PPAIDEN defaults zeroes into the
SIN field when a person record is queried and the SIN
field is blank. The field should remain blank.

A problem was reported when the Index Code is inactive
or terminated and the user accesses the LD Overrides on
PTRBDCA. The user received an error message pop-up for
each record where the index code was inactive. After
acknowledging all the error messages, the form displays
no records, stating there are no records to retrieve.
The user cannot query an Labor Distribution Override
records even though data is present. If a separate
query is performed to retrieve the records in the
PTRBDLD table, the user received the same error
messages and the form still does not display the
records.
When other FOAPAL elements are terminated the form
does not behave in the same manner. The user can go in
see each record and affect a change to the item that is
inactive. The same behavior is occurring for Index
Codes on the Earn Rule Form, PTREARN, regarding the
Earnings Labor Overrides.
On both forms, the Index Validation edits have been
relaxed, allowing the user to query and update the
incorrect Labor Distribution Overrides.

An error will display on PAAAPPL if the Source value is
changed on an existing record after a Position Class
has been changed on the Position record (NBAPOSN).




PAAAPOS allows you to enter a position that is not
associated with the requisition entered.


The PEIJTOT Earn Code field list of values doesn't list
the earnings in alphanumeric order in 10g.

An issue was reported with the Mass Change process when
deduction rules were associated with System Generated
rules. The process was not allowing these types of
deductions, such as Life Insurance, to be reactivated
from a terminated status. This has been corrected so
that errors are no longer received when trying to
reactivate a deduction that are using System Generated
options or amount rules.

Two issues are resolved with this modification:
1). Redistributions that are automatically approved
should set the disposition of the PHRJOBS and the
PHRHIST tables to the same value of 60.
2) An error message will be displayed to the user
when the routing queue can not be created due to an
error with the Financial Manager data in the Finance
Tables. This error condition can be caused because the
PIDM field for the Financial Manager has been populated,
but is invalid. An error message is produced to convey
the error in building the routing queue in the Banner
forms PHAADJT and PHAREDS. The transaction disposition
will remain at 47 until the data error is resolved.

Several issues are resolved with this modification:
EAP - Overall - If an employee selected for reporting
is a faculty member and does not have a Primary
Function established on PEAEMPL, they will not be
included in the totals, however, they will appear on
the EAP report as "Undefined". These employees must
have a primary function in order to be counted
properly.
EAP - Parts A & B - Employees who are selected for the
report, and are not faculty and have no related tenure
or rank records will be reported in the "Without
Faculty Status" column. Employees who are not faculty,
yet have related faculty and/or rank information will
be reported in the proper faculty status columns.
EAP - Part C - Graduate students are reported in the
correct summary total columns.
Salary Survey - Parts D, E, and F - Only employees who
have a primary function on PEAEMPL of "Primarily
Instruction" or "Instruction combined with Research and
Public Service" will be included in the extract.
Salary Surver - Part F - When only 9/10 month employees
exist, the report will finish correctly.

The PXRW208 process is querying for the maximum Control
Number for each row instead of searching for the
maximum number once at the beginning of the process and
then using a one-up logic.


1) When an employee has a long last name with special
characters, the following error can occur on the
PXAW2CC form:
FRM-40831: Truncation occurred: value too long for
field PXRW2FD_EMPL_LAST_NAME.
A W-2c cannot be created or viewed and no workaround
exists.
2) When trying to delete an 'In Progress' correction
using the Remove Record menu or icon, the record is not
removed.
Workaround is to use the Option selection to delete.

Employees classified as "Executive/Admin or Managerial"
or "Other Professionals" who have faculty appointment
records, but no tenure information are counted as
"Without Faculty Status" in sections A and B of the EAP
report.
RESOLUTION (1-4KG6J2):
This defect addresses both 1-3I950L and CMS-DFCT80918
defects.
The program is not calculating the total days in the
pay period (per_length) correctly for salaried
employees who start a job in the middle of the pay
period.
When the person's job ends during the pay period, the
program uses the work schedule for the entire pay
period to calculate the # of days. This is correct.
When the person's job starts during the pay period, the
program uses the work schedule during the person's job
days, but uses the "standard" calendar for the part the
employee didn't work which creates a higher percent of
time worked and consequently causing the employee to be
overpaid. Additionally, the program was adjusted to
properly prorate pay when an employee changes from a
Work Schedule to Default Hours during a given pay
period.
*** This defect must be fixed together with Defect #
CMS-DFCT80918 ***
RESOLUTION (1-3I950L):
1. The "Grand Totals" prints on pxrtdep.lis again.
2. The printout will show 1042 deduction information
in Box1.


Values in Pension Credit Override and Pensionable
Service Override fields do not show on the PEPPCRE
output .lis file.




When running the Time Sheet process (PHRTMSH ) in Banner
8 a runtime error is received and the process will not
run.
ORA-01480: trailing null missing from STR bind
value
WRN-ORACERR: Error occurred in file "phrtmsh.pc" at
line 5,218
WRN-ERRSTMT: Following statement was last statement
parsed:
select (TO_CHAR(TO_NUMBER(:b0),'99999.99')||DECODE(:
b1,'H',' H','D','
phrtmsh terminated with error
77 lines written to phrtmsh.lis

The PHATIME form was inconsistently displaying the
correct order of jobs, when an employee had multiple
jobs in the same payroll. This was due to a difference
in the method for querying records with Oracle 10g. A
specifc order statement was placed in the form to
correctly display jobs for the same employee, from low
value to high value.

This posting includes multiple objects that relate to
processing Time Sheets, Leave Reports and Leave
Requests. In the past, when a period is closed for
employees and approvers to act on time records, records
that were initially started by the employee (In
Progress status) or those that were submitted for
Approval (pending) were inaccessible for processing.
These time transactions would appear constantly in the
queues for the approver. Additionally, if many of
these records remained for past periods, Luminus
channels had the potential of overflowing and reported
errors.
With this posting, a new ‘Cancel’ function is being
introduced for use by the Superuser. The Superuser
will now be able to affect the status of past
transactions, in order to clear them from Luminus
channels and remove them from Pending or In Process
statuses.
The new Cancel logic is enabled under the following
conditions:
• Only a Superuser can initiate a Cancel function.
Approvers cannot set transactions to ‘Cancel’. This
ensures that any missed time transactions can be
analyzed by an administrator for potential lost time
input.
The output file contains data that is formatted
improperly due to the changes implemented as part of
the 8.0 Internationalization project.

The Total Insurable Hours calculation includes all hours
in the entire employment period. The fix corrects the
calculation of both the Total Insurable Hours and Total
Insurable Gross.

The form will compile successfully.
RESOLUTION (1-4Y37UH):
Product                   Readme File Name




Banner-Position Control   p1-3m2om8_pos80000_readme.txt




Banner-Position Control   p1-3m2om8_pos80000_readme.txt




Banner-Position Control   p1-3m2om8_pos80000_readme.txt


Banner-Position Control   p1-3v3k5r_pos80000_readme.txt




Banner-Position Control   p1-3v3k5r_pos80000_readme.txt


Banner-Position Control   p1-3v3k5r_pos80000_readme.txt




Banner-Position Control   p1-3xszu4_pos80000_readme.txt
Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt




Banner-Position Control   b_0209_forms_pos80100_readme.txt
Banner-Position Control   b_0409_dbprocs_pos80100_readme.txt




Banner-Position Control   b_0409_dbprocs_pos80100_readme.txt




Banner-Position Control   b_0409_dbprocs_pos80100_readme.txt




Banner-Position Control   b_0409_dbprocs_pos80100_readme.txt




Banner-Position Control   p1-3bw33s_pos80100_readme.txt




Banner-Position Control   p1-46gpgd_pos80100_readme.txt




Banner-Position Control   p1-4l7zl3_pos80100_readme.txt
Banner-Position Control   p1-4q8y52_pos80100_readme.txt




Banner-Position Control   p1-4stmj8_pos80100_readme.txt
Banner-Position Control   pos80000d_readme.txt
Banner-Position Control   pos80000u_readme.txt
Banner-Position Control   pos80100d_readme.txt
Banner-Position Control   pos80100u_readme.txt
                               Posnctl 8.x Patches
Module    Release   Patch Date Defect




          8.0.0.1    8/18/2008 1-3M2OM8




          8.0.0.1    8/18/2008 1-3N5TXP




          8.0.0.1    8/18/2008 1-3NV3S7


          8.0.0.1    8/18/2008 1-3V3K5R




          8.0.0.1    8/18/2008 1-3V3KDY


          8.0.0.2    8/18/2008 1-3V3KFI




Overall   8.0.0.1   10/30/2008 1-3XSZU4
Position Control     8.1.0.1   2/27/2009 1-2AUDRP




                     8.1.0.1   2/27/2009 1-3GSG99




                     8.1.0.1   2/27/2009 1-3PJSFB




Position Budgeting   8.1.0.1   2/27/2009 1-46HHIS




Overall              8.1.0.1   2/27/2009 1-PHL5A




                     8.1.0.1   2/27/2009 CMS-DFCT89551




                     8.1.0.1   2/27/2009 CMS-DFCT93500
Position Control                8.1.0.1               4/22/2009 1-2W2LO1




Electronic Approvals            8.1.0.1               4/22/2009 1-3GBADK




Payroll Processing              8.1.0.1               4/22/2009 1-4QHEWH




                                8.1.0.1               4/22/2009 CMS-DFCT90958




Position Budgeting              8.1.0.1               2/16/2009 1-3BW33S




Salary Planner                  ntraufdi_46gpgd.sql   2/16/2009 1-46GPGD




Employment Compensation Admin   8.1.0.1               1/30/2009 1-4L7ZL3
Salary Planner        8.1.0.1    3/6/2009 1-4Q8Y52




Position Management   8.1.0.1   4/27/2009 1-4STMJ8
Object(s)




nbajobs.fmb,nokmup1.sql




nbkb_job_base_r1.sql




noaepaf.fmb,nbajobs.fmb,nokepc1.sql,


nokedit1.sql




nokepa1.sql


nokmup1.sql




nbapbud.fmb
nbapbud.fmb




ntrfini.fmb




nbqposn.fmb




nbapbud.fmb




nbapbud.fmb




nbiporg.fmb




ntrfini.fmb
nbkbud1.sql




nokedit1.sql




nbkp_job_assignment1.sql




nopeces.sql




nbrbwrk.pc




ntraufdi_46gpgd.sql




nokmup1.sql
nbpspex.pc




nbkb_job_labor_r1.sql,
Problem
When the NTRINST Budget Validation indicator is set to
'Error' you cannot enter a job record and terminate the
record if the initial entry would cause the job to
exceed the budget amount.




CMS-DFCT8555 8.x v Salary encumbrance values are being
associated to 'H'istory records. This is preventing a
job from being deleted. The 'H' records are history
records that are created when the labor distribution is
deleted on NBAJOBS. See Note.

Provide the ability to end a default earning and start a
new default earning on the same day.




Message type should be 'SQL' for the following messages:




Message type should be 'SQL' for the following messages:


Message type should be 'SQL' for the following messages:
Entering comments for positions with a status of
Cancelled, will cause the position status to be updated
to Active.

The form should not allow NEW lines of distribution
where the percent is zero.
The existence of a zero percent distribution stops you
from giving the position to an employee as a job.
The NBAJOBS form will display the error that the percent
should be between .01 and 100 percent.

Problem with NTRFINI related to maximum number of open
forms on GUAINST.
NTRFINI is adding to the number of open forms twice.
This can cause the following error to display:
"Organization's maximum number(2)of current open forms
has been reached" .

When Banner Finance is NOT licensed and the user
navigates to NBQPOSN from the NBAPOSN form, the Budget
Organization and Description do not display.

On the budget screen, NBAPBUD, under the Labor
Distribution tab the total Labor Distribution
percentage isn't displaying. Banner is calculating as
shown on the position LD table NBRPLBD. This is only a
display issue.

1) The NBAPBUD form allows a user to set the labor
distribution budget amount to be different than the
salary budget amount.




NBIPORG will give the user an error - *ERROR* Orgn Code
entered is terminated. Press LIST for valid codes -
when querying on an orgn that has been terminated in
Finance but may still have Position Budget records
associated with the orgn.




The form should allow the bank code field to be blank.
This is for purposes of controlling the bank code used
in the payroll feed to finance. The nhpfin2 process
uses the Bank Code on PTRPICT when the NTRFINI Bank
Code field is blank.


The process will not extract position/job information if
the position has an end date - even if the position end
date is greater than the job effective date in NTRSPEX
or the nbpspex job effective date parameter.


NOPEAMA allows a job to be created if the employee is
currently on leave


PHPTIME does not populate the special rate from PEA1PAY
if a special rate earn code is entered for the earning.
This functions correctly in 7.X. The workaround is to
add the rate on PHAHOUR.

The form needs to allow for the combination of 'F'ull
Time or 'O'ther employees who are not reported (eskl 90)
, such as elected officials.




NBRBWRK not correctly sorting the report by coas,
followed by budget org in a 10g environment. See
attached sample.




In the 8.0 upgrade, the addition of the new
nbrjlbd_enc_override_end_date field, to the NTRAUSG
form (table ntraufd), was overlooked. Consequently,
when this field is updated within Salary Planner, the
updated value is not included in the EPAF that is
created, and the field is not updated in the jobs labor
distribution table.

Incorrect encumbrance numbers are being assigned to jobs
labor distribution records. The encumbrance number
should be based on the effective date of the labor
being processed in the epaf. It appears to be based on
the nobtran_effective_date, which comes from the Query
Date field.

Nbpspex gives error when trying to execute with wildcard
'%' on Organizations to copy. the list file.
Unable to run NBPENCM when Banner Finance is not
installed.
Impact
When the NTRINST Budget Validation indicator was set to
'Error' you could not create a job that was intended
for a shorter payout period because the calculated
encumbrance was greater than the position budget. This
has been corrected to allow the creation and save of a
job, but will return an error if the user tries to
Rollback or Exit before making corrections.

You could not delete an NBAJOBS record if there was a
'H'istory indicator with a Salary Encumbrance amount.
This has been corrected to ignore the 'H'istory record.




Users will now be able to enter an end date that is one
day after the Last Paid Date and will not receive an
error message. The transaction can be submitted and
can then be applied to the database. This change will
enable clients to begin Default Earnings on the first
day of a new pay period which could be the same date
that another default earning was ended.The on-line
apply process has been updated to accept these new
conditions.

Changes were made to convert to ISC standards for
internationalization purposes.

In procedure p_initial_edit_spriden, changed the second
attribute of error message G$_NLS.Get('x','EDIT',
'*ERROR* Unable to process SPRIDEN initial edits
(Oracle Error '|| TO_CHAR(SQLCODE) || ').') from 'EDIT'
to 'SQL'

Changes were made to convert to ISC standards for
internationalization purposes.

If comments are entered on Positions with a status of
Cancelled or Frozen, the status will change to Active
when the record is Saved.

The NBAPBUD form is allowing NEW lines of distribution
with a percent of zero. The existence of a zero
percent distribution stops you from giving the position
to an employee as a job. The NBAJOBS form will display
the error that the percent should be between .01 and
100 percent.

The NTRFINI form is doubling the number of open forms
defined as the maximum on GUAINST. This can cause the
following error to display: "Organization's maximum
number(2)of current open forms has been reached."




On NBAPBUD, under the Labor Distribution tab, the total
Labor Distribution percentage isn't displaying. This
is only a display issue.




1) The NBAPBUD form allows a user to set the labor
distribution budget amount to be different than the
salary budget amount. For example a zero budget with a
$50,000 salary. The form will allow this record to be
saved without error or warning messages.
2) If Salary Budget is $0.00 and an amount greater
than 0.00 is entered on the labor distribution tab, a
Form/Oracle error displays. A User error should
display instead:
ERROR* Cannot calculate percentage as salary budget
is zero.
RESOLUTION (1-PHL5A):
The NBIPORG form will not allow the query of positions
on terminated organizations. When querying on an
organization that has been terminated in Finance but
may still have Position Budget records associated with
it, the following error will display: “*ERROR* Orgn
Code entered is terminated. Press LIST for valid
codes.”
RESOLUTION (CMS-DFCT89551):
The Installation Rules Form (NTRINST) does not allow the
bank code field to be blank. This is for purposes of
controlling the bank code used in the payroll feed to
finance. The interface logic in the nhpfin2 process
uses the Bank Code on PTRPICT when the NTRFINI Bank
Code field is blank.

If a position has an End Date populated on NBAPBUD/
NBAPOSN, the Salary Planner extract (NBPSPEX) will not
select any position records, regardless of whether the
end date is in the current extracted year or a date in
the future beyond the year being extracted.

An EPAF to create a new job can be created, and applied,
when an employee is on leave of absence. This is
incorrect and should not be allowed to happen.

PHPTIME does not populate the special rate from PEA1PAY
if a special rate earn code is entered for the earning.




Position classes that are considered Full Time due to
their association with an employee class containing an
EEO Contract Group of "1", "2", "3", or "6", may be
associated with an employee skill code of "90" (Other).
This modification allows Position Classes with EEO
Contract Group of "3" to have an employee skill code of
"90", in addition to the previously allowable values of
"1". "2", and "6".

NBRBWRK allows the entry of multiple Chart of Accounts
parameters. In the 10g environment, the data was not
sorted. This has been resolved by correctly sorting
the data for the report, first by Chart of Accounts,
then by organization, position, and employee name.

The NBRJLBD_ENC_OVERRIDE_END_DATE value was not
delivered in a script with the 8.0 upgrade to Salary
Planner. Therefore, the field is not included in any
EPAF created from the Upload process.




Incorrect encumbrance numbers are being assigned to job
labor distribution records. The encumbrance number
appears to be based on the nobtran_effective_date,
which comes from the Query Date field. It should be
based on the effective date of the labor being
processed in the EPAF.

When running the Salary Planner extract process, NBPSPEX,
and using the % wildcard to copy organizations, an
error will be returned and the extract will not be
created.

When running the Encumbrance Maintenance Process
(NBPENCM) when Banner Finance is not installed, the
process is aborting with an error: ERROR* Unable to
retrieve active fiscal year data from NBBFISC, aborting
job.
This has been corrected to look for Finance before
checking for Chart of Accounts.
Product          Readme File Name                Module                  Release Patch Date




Banner-Student   p1-3l326l_stu80000_readme.txt                           8.0.0.1    6/3/2008




Banner-Student   p1-3q588y_stu80000_readme.txt   Student Functionality   8.0.0.1   6/10/2008




Banner-Student   p1-3qccu3_stu80000_readme.txt                           This      7/14/2008




Banner-Student   p1-3qxf77_stu80000_readme.txt                           8.0.0.1   7/11/2008


Banner-Student   p1-3swe9g_stu80001_readme.txt                           This       7/8/2008




Banner-Student   p1-3tc9r2_stu80001_readme.txt                           8.0.1.1   7/11/2008
Banner-Student   p1-3ult67_stu80100_readme.txt   Location Management     8.1.0.1   12/17/2008




Banner-Student   p1-456ugc_stu80100_readme.txt   System Functions        8.1.0.1   12/17/2008

Banner-Student   p1-4bt40x_stu80100_readme.txt                           8.1.0.1   12/17/2008




Banner-Student   p1-4cag0u_stu80100_readme.txt   CAPP Module             8.1.0.1   12/15/2008


Banner-Student   p1-4avqtq_stu80101_readme.txt   CAPP Module             8.1.1.1    4/10/2009




Banner-Student   p1-4q9ifr_stu80101_readme.txt                           8.1.1      2/12/2009




Banner-Student   p1-4qhbp5_stu80101_readme.txt   Student Functionality   8.1.1.1    3/12/2009




Banner-Student   p1-4qhbp5_stu80101_readme.txt   Curriculum              8.1.1.1    3/12/2009
Banner-Student   p1-4s10sz_stu80101_readme.txt   Electronic Prospects   8.1.1.1    3/12/2009




Banner-Student   p1-4589uj_int80001_readme.txt                          8.0.1.1    12/1/2008


Banner-Student   p1-4c88rq_int80001_readme.txt                          8.0.1.1   12/12/2008




Banner-Student   p1-5gaazm_int80001_readme.txt                          8.0.1.1    5/21/2009
Student 8.x Patches
Defect                Object(s)




1-3L326L              multiple - see comments




1-3Q588Y              sikafla1.sql




1-3QCCU3              Security for SFAMASS.




1-3QXF77              STUDBPR.SQL


1-3SWE9G              Upgrade




1-3TC9R2              STUDBPR.SQL
1-3ULT67   sliaevn.fmb




1-456UGC   soaiden.fmb

1-4BT40X   STVACAT.FMB, STVBLDG.FMB, STVCAMP.FMB,




1-4CAG0U   sfrpipe.pc,sfkpip1.sql


1-4AVQTQ   smrbcmp.pc, smrcmpl.pc, smrcrlt.pc, smreval.pc, smrgevl.pc,




1-4Q9IFR   spvpers.sql




1-4PWCKR   soklcu1.sql




1-4QHBP5   soklcur.sql,soklcu1.sql,susoplccd_learner.sql
1-4S10SZ   srktest.sql,srktes1.sql,srkprel.sql,srkpre1.sql, sakl140.sql




1-4589UJ   icsskco1.sql


1-4C88RQ   icruready.sql, int80001ug.pdf




1-5GAAZM   icgorldi.pc
Problem
multiple views posted in 7.4.0.x, but not changed in 8.0,
have dependencies on some baseline packages changed in
7.4.0.x, which were released with 8.0, minus these
7.4.0.x changes.
These 7x package changes must be reapplied to the 8x
versions (as 8.0.0.1) to re-synch the view/package
relationships.

Delivered SIKAFLA Banner8 package body spec incorrect if
HR not installed. Defect in sikafla1.sql.


When a user types in SFAMASS directly, the auto-hint bar
indicates that they are not authorized to access
SFAMASS, rather than the expected message that it is an
invalid form name.

start soo_transfer_course0.sql
start soo_transfer_course_attr0.sql
start
soo_transfer_course_attr_nt baninst1.sql
start soo_transfer_course_levl0 baninst1.sql
start
soo_transfer_course_levl_nt baninst1.sql
start soo_transfer_course_nt.sql

SFAREGS.fmb was delivered with Student 8.0.1 but does
not get compiled or migrated.

start soo_transfer_course0.sql
start soo_transfer_course_attr0.sql
start
soo_transfer_course_attr_nt baninst1.sql
start soo_transfer_course_levl0 baninst1.sql
start
soo_transfer_course_levl_nt baninst1.sql
start soo_transfer_course_nt.sql

In the LOAD_FORM_HEADER trigger the format mask
G$_DATE.GET_NLS_DATE_FORMAT has been changed back to
DD-MON-YYYY.
When you run Banner INB with a different Date format
(i.e. YYYY-MM-DD) you will get an error when you call
SLIAEVN from another form (like GEAFUNC).
This change affects the CURRENT_DATE, BEGIN_DATE and
END_DATE.

Defect 1-456UGC - SPAIDEN calling SOAIDEN with long last
name results in FRM-40735 WHEN-NEW-FORM-INSTANCE
trigger raised unhandled exception ORA-6502


SDE does not change when scrolling through records
SFRPIPE terminates after receiving any message from
SFKPIPE.
This appears to be Operating System specific, manifesting
itself in at least HpUnx and SunSolaris Unx systems. A
typical listener .lis file will show the following:

Compliance fails for some students with one of several
messages:

The following files, delivered in the Student 8.1.1
Upgrade, were omitted from the stumigr migration script:


SGASTDN (also SAADCRV): commit of a new student record
with changed term and student status, that has
Curriculum Status on STVSTST, may result in error:
FRM-40735: CURRICULUM_COMMIT trigger raised unhandled
exception ORA-06511
GUAERRM error: 100501:non-ORACLE exception
OR:
It is possible to create duplicate current, active
SORLCUR records for a Learner for the same term and
same priority. There should only be one SORLCUR for a
Term and Priority that is marked as CURRENT_CDE = Y.

The following errors are received when test scores
already exists on SOATEST: The API generated error
string is: ORA-20100: ::ORA-20100: ::Required parent
record not found::::ORA-20100: ::Required parent record
not found::::ORA-20100: ::Required parent record not
found::::ORA-20100: ::Required parent record not found::
::ORA-20100: ::Required parent record not found::::
ORA-20100: ::Required parent record not found::
ORA-06512: at "BANINST1.SRKPREL", line 5777 ORA-06512:
at line 1
Message = 0 Required parent record not found
Message = 1
Required parent record not found
Message = 2 Required parent record not found
Message = 3
Required parent record not found
Message = 4 Required parent record not found
Message = 5
Required parent record not found

We've sent an Icgorldi extract to D2L. They're having
trouble importing
it due to parsing errors. After some research, it
appears that some of
the extract's tags are empty. D2L says
that they
shouldn't be empty -- that they should contain 1 or 0.
However, we've
successfully validated the xml against the dtd referenced
in the
extract. It also appears that, according to the dtd, the
tags _can_ be
empty. Our question to Sungard: _should_ those tags have
data in them?

Defect 1-4C88RQ - INTCOMP 8.0.1 - int80001u - upgrade
incorrectly requires FINAID product

When attempting to run the icgorldi extract process via
job submission in the Banner 8.x system test
environment the following error is created:
Impact
Extract terminates with error ORA-01480 when it
encountered names comprised of over 100 characters.
Product                       Readme File Name                     Module     Release
Banner-Student Self-Service   p1-42fbwt_bws80000_readme.txt                   8.0.0.1




Banner-Student Self-Service   b_0708_dbprocs_bws80001_readme.txt   Recruiting 8.0.1.1




Banner-Student Self-Service   p1-4q5fhw_bws80101_readme.txt                   8.1.1.1
Banner-Student Self-Service   bws80000d_readme.txt
Banner-Student Self-Service   bws80000u_readme.txt
Banner-Student Self-Service   bws80001d_readme.txt
Banner-Student Self-Service   bws80001u_readme.txt
Banner-Student Self-Service   bws80100d_readme.txt
Banner-Student Self-Service   bws80100u_readme.txt
Banner-Student Self-Service   bws80101d_readme.txt
Banner-Student Self-Service   bws80101u_readme.txt
           Student SS 8.x Patches
Patch Date Defect                   Object(s)
10/10/2008 1-42FBWT                 Upgrade




 7/31/2008 1-3T58CJ                 bwskwpr1.sql,bwskwpr2.sql




 3/12/2009 1-4Q5FHW                 bwsksph1.sql
Problem
The Student Self-Service 8.0 upgrade does not correctly
There is a potential for a cross site scripting
vulnerability with multiple parameters on the prospect
and admissions web pages in Self-Service Banner. This
can cause a vulnerability because any script tags added
to the parameter will be executed. The parameter
values should be correctly encoded before being
included in the HTML so that any embedded tags are not
executed.

Internet Explorer, MozillaFirefox and Netscape will
generate an error message, 'File does not begin with
'%PDF-' when attempting to use the View Statement link
on the Statement and Payment History page under Student
Account and in TGISTMT, if the file was stored as
plain text using type TXT.
Impact
Source code delivered with the 8.0 Student Self-Service
Potential cross site scripting vulnerability with
multiple parameters on the Prospects page in
Self-Service Banner.




View Statement not visibile if stored in plain text. In
Firefox and recent versions of IE, will generate an
error message:
'File does not begin with '%PDF-' if
stored as plain text.
Product             Readme File Name                     Module   Release Patch Date




Banner-Web Tailor   b_0708_dbprocs_twb80000_readme.txt            8.0.0.1   7/16/2008




Banner-Web Tailor   b_0708_dbprocs_twb80000_readme.txt            8.0.0.1   7/16/2008




Banner-Web Tailor   b_0708_dbprocs_twb80000_readme.txt            8.0.0.1   7/16/2008




Banner-Web Tailor   b_0708_dbprocs_twb80000_readme.txt            8.0.0.1   7/16/2008




Banner-Web Tailor   p1-3gwyy6_twb80000_readme.txt                 8.0.0.1    5/8/2008
Banner-Web Tailor   b_0109_twb80101_readme.txt                         8.1.1.1   1/30/2009


Banner-Web Tailor   b_0109_twb80101_readme.txt                         8.1.1.1   1/30/2009


Banner-Web Tailor   b_0109_twb80101_readme.txt                         8.1.1.1   1/30/2009




Banner-Web Tailor   b_0109_twb80101_readme.txt                         8.1.1.1   1/30/2009




Banner-Web Tailor   b_0109_twb80101_readme.txt                         8.1.1.1   1/30/2009




Banner-Web Tailor   p1-4mgq5p_twb80101_readme.txt   System Functions   8.1.1.1   5/13/2009




Banner-Web Tailor   p1-4su8zc_twb80101_readme.txt                      8.1.1.2   4/13/2009




Banner-Web Tailor   p1-5fkkxf_twb80101_readme.txt                      8.1.1.3    5/7/2009
WebTailor 8.x Patches

Defect                  Object(s)




1-3FA6HJ                twbkwbi1.sql




1-3L99HX                twbklog1.sql




1-3MMJKZ                twbkwbi1.sql




1-3TCZCZ                twbkxna1.sql




1-3GWYY6                TWGKWLI1.sql
1-4BO86D   twbkwbi1.sql


1-4CUQHR   twbkwmn1.sql


1-4HB03T   twbkwbi1.sql




1-4ILARB   twbkwin1.sql,twbkfrm1.sql,twbkwbi1.sql




1-4IMLHX   twbkwbi1.sql




1-4MGQ5P   twbklog1.sql and twgbparmi_4mgq5p.sql




1-4SU8ZC   twbkwbi1.sql




1-5FKKXJ   twbkwbi1.sql
Problem
Remove g$_NLS.get for several objects. Some objects are
using g$_NLS.get call, but no translation is needed, so
these calls should be removed from the code. Please
also check and make sure that translatable items are
not using English terms in logic (like IF conditions
based on an English term/value visible on screen)

Login error after user accepts the Terms of Usage. In
SS 8.0, users receive an error message of "999 minute
inactivity caused web session timeout" and are sent
back to the login screen after they have accepted the
Terms of Usage page when trying to login to
Self-Service.
The suggested work around is to manually check the
Accepted flag on form GOATPAD or turn off the Terms of
Usage page in WebTailor

Please review if G$_NLS.get should be replaced by
G$_NLS.FormatMsg for the following msg:
G$_NLS.FormatMsg('x', 'SQL',
f_get_infoerr('twbkwbis.P_ProcSecurityAnswer',
'DISABLE')

Several objects are missing G$_NLS.get calls for
translatable strings/messages.
Please also check and make sure that no English text is
used in the logic of the code like seems to be the case
for some IF conditions.

Unable to log in to Voice Response with a goatpad pin…
receiving message that the pin I have entered is
invalid (invalid_pin).
Workaround:
1. Null out the pin on GOATPAD and commit
2. Set the
GORFLAG REQ_PIN flag to N
3. When I do not have a pin on record, I am not prompted
for a pin

Users are prompted to define a security question and
answer (twbkwbis.P_SecurityQuestiion) when using LDAP
authentication to access Self-Service Banner. This is
a problem because the web page requires that they
confirm their Banner PIN, which they don't know since
LDAP is being used. The problem only occurs in Banner
8.0. In Banner 7.x the question and answer portion is
skipped and users are taken directly to the main menu.

twbkwmn1.sql has rekey warnings that should be analyzed
and fixed

It appears that the 8.1.1 version is missing all of the
8.1 changes.

Unable to use Javascript in Infotext after upgrading to
8.1. When viewing the web page, the script is shown as
text and an error is displayed:

Error occurs when the WELCOME information text label on
twbkwbis.P_ValLogin has a special character in it. For
example, an & (ampersand) in the WELCOME information
text would cause an Oracle error at logon:

In Luminis III.3.x, users were able to login to SSB with
LDAP authentication using their LDAP ID. In Luminis IV,
that is no longer possible. When LDAP authentication
is enabled for SSB, users can only login using their
Immutable ID.

If Race Surveys are disabled by certain roles, this
would prevent users, with role that was disabled, from
logging in.

There is a potential for a cross site scripting
vulnerability with the multiple parameters in the
Security Question and Answer feature of Self-Service
Banner. This can cause a vulnerability because any
script tags added to the parameter will be executed.
The parameters should be correctly encoded before being
included in the HTML so that any embedded tags are not
executed.
Impact
G$ makes string translatable, string if translated would
cause logic to fail at runtime




Users receive an error message of "999 minute inactivity
caused web session timeout" and are sent back to the
login screen after they have accepted the Terms of
Usage page when trying to login to Self-Service when
GOBTPAC_USAGE_ACCEPT_IND is not set .




Strings not translatable, would show in English in
language versions




Unable to log into Voice Response with a GOATPAD PIN
RESOLUTION (1-3GWYY6):




Users are prompted to define a security question and
answer (twbkwbis.P_SecurityQuestiion) when using LDAP
authentication to access Self-Service Banner.
The twbkwbi1.sql version 8.1.1 does not include 8.1
changes.




In Luminis III.3.x, users were able to login to SSB with
LDAP authentication using their LDAP ID. In Luminis IV,
that is no longer possible. When LDAP authentication is
enabled for SSB, users can only login using their
Immutable ID.

If Race Surveys are disabled by certain by roles, this
would prevent users, with role that was disabled, from
logging in.
                                     Workflow 8.x Patches
        Readme
        File                    Patch
Product Name   Module   Release Date Defect                 Object(s) Problem Impact
Product                                                  Readme File Name
Banner-Document Management Suite Integration Component   bdmssetup80100u_readme.txt
Banner-Document Management Suite Integration Component   bxssetup80000u_readme.txt
Banner-Document Management Suite Integration Component   bxsluminis_5.40.190_readme.txt
                       Xtender 8.x Patches
               Patch
Module Release Date    Defect                Object(s) Problem Impact

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:617
posted:4/17/2010
language:English
pages:194