Click to show/hide contact information.

FIS Release Notes

Approximately once per fiscal year quarter, FIS system updates will be performed. These updates will include regular operating system and Oracle database patches, as well as any defect corrections or minor enhancements that accumulated since the last cycle. Release notes describing any defect corrections or enhancements are provided below. If you have questions or would like more information, please em​ail fis_probs@ucsc.edu.

2024 January February March April May June July August September October November December
2021 January February March April May June July August September October November December
2020 January February March April May June July August September October November December
2019 January February March April May June July August September October November December
2018 January February March April May June July August September October November December
2017 January February March April May June July August September October November December
2016 January February March April May June July August September October November December
2015 January February March April May June July August September October November December
2014 January February March April May June July August September October November December
2013 January February March April May June July August September October November December​​​​​

​​

June 2024
06/01/24​​​​​​​​​​

Change Number Area/Object Change Description
FPT-5570 Banner Admin Common Installed Banner Admin Common, underlying foundation to all Banner 9 Pages, versions: 9.3.24, 9.3.25, 9.3.26, 9.3.27.0.3

Installation brings Banner up to date for support requirements from software provider Ellucian.
FPT-5556
FPT-5557
Banner General Installed Banner General versions: 8.14, 9.3.22.2.2

Installation brings Banner up to date for support requirements from software provider Ellucian.
FPT-5563
FPT-5564
Banner Finance Installed Banner Finance versions: 8.14.1, 9.3.23

Redelivered pages with local mods are described below.
FPT-5562 Banner Access Management Installed Banner Access Management version: 9.3.18.1.2

Installation brings Banner up to date for support requirements from software provider Ellucian.
FPT-5565
FPT-5566
Banner Accounts Receivable Installed Banner Accounts Receivable versions: 8.8, 9.3.10.0.4

Installation brings Banner up to date for support requirements from software provider Ellucian.
FPT-5567 Banner Position Control Installed Banner Position Control 8.20

Installation brings Banner up to date for support requirements from software provider Ellucian.
FPT-5558 FTMORGN FTMORGN Organization Code Maintenance

Corrected issue with Organization Code predecessor code not displaying most recent title.

IMPACT:Users can now see the effective Org Code predecessor code title in effect.M

Reapplied local UCSC modifications.
FPT-5561 FYAINVE FYAINVE Invoice Credit Memo

1) Vendor Invoice Number has been increased from 15 to 35 characters. IMPACT: Invoice users are no longer restricted to 15 character vendor invoice numbers.

2) Corrects issue where zero-dollar direct pay inoices such as cash advance clearings would not balance by accounting (biginteger dive by zero issue). IMPACT: With this update, zero-dollar direct pays will balance at accounting with no issues, and a complicated work-around will no longer be necessary.

Reapplied local UCSC modifications.
FPT-5568 FGAJVCD FGAJVCD Journal Voucher Entry

1) Document Reference field has been increased from 8 to 35 characters. IMPACT: Longer reference numbers can now be used to identify and track more complex transactions.

2) FOAPAL description titles now display in Journal Voucher Detail section. IMPACT: Users can use titles to confirm correct selection of accounting sequences when preparing journal vouchers. 3) Corrected issue where pagination button navigation between accounting sequences did not autosave user changes. IMPACT: User changes will now autosave when pagination button navigation is used.

Reapplied local UCSC modifications.
FPT-5571 FZAJVCD FZAJVCD UCSC Journal Voucher Entry

1) Document Reference field has been increased from 8 to 35 characters. IMPACT: Longer reference numbers can now be used to identify and track more complex transactions.

2) FOAPAL description titles now display in Journal Voucher Detail section. IMPACT: Users can use titles to confirm correct selection of accounting sequences when preparing journal vouchers.

3) Corrected issue where pagination button navigation between accounting sequences did not autosave user changes. IMPACT: User changes will now autosave when pagination button navigation is used.

Reapplied local UCSC modifications.
FPT-5572 FZAJVEL FZAJVEL UCSC Encumbrance Liquidation

1) Document Reference field has been increased from 8 to 35 characters. IMPACT: Longer reference numbers can now be used to identify and track more complex transactions.

2) FOAPAL description titles now display in Journal Voucher Detail section. IMPACT: Users can use titles to confirm correct selection of accounting sequences when preparing journal vouchers. 3) Corrected issue where pagination button navigation between accounting sequences did not autosave user changes.

IMPACT: User changes will now autosave when pagination button navigation is used.

Reapplied local UCSC modifications.
FPT-5574 FACION FACICON Vendor Invoice Consolidation

Vendor Invoice Number has been increased from 15 to 35 characters. IMPACT: Invoice users are no longer restricted to 15 character vendor invoice numbers.

Reapplied local UCSC modifications.
FPT-5575 FFAADJF FFAADJF Fixed Asset Adjustment

Document Reference field has been increased from 8 to 35 characters. IMPACT: Longer reference numbers can now be used to identify and track more complex transactions.

Reapplied local UCSC modifications.
FPT-5580 FPACHAR FPACHAR Change Order

Fixed issue with zero amount accounting records resulting in out-of-balance error conditions. IMPACT: Zero dollar commodityand accounting can now be added without integer rounding isues, and Purchasing buyers should now be able to zero out existing items and accounting sequences without error messages or complicated work-around process.

Reapplied local UCSC modifications.
FPT-5583 FTMACTV FTMACTV Activity Code Maintenance

1) Page now displays Activity Date for the last update to each Activity code. IMPACT: Users can more readily see when the last change was made to an Activity Code. 2) Page now allows deletion of any future-dated Activity Code and prevents addition of a future-dated Activity Code when a later version exists. IMPACT: Users have more flexibility to correct mistaken entries into FTMACTV page.

Reapplied local UCSC modifications.
FPT-5584 FTMFUND FTMFUND Fund Code Maintenance
FPT-5578 FOAUAPP FOAUAPP User Approval

Vendor supplied update to User Approval page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5577 FGIBDSR FGIBDSR Executive Summary

Vendor supplied update to Executive Summary page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5588 FGITRND FGITRND Transaction Detail

Vendor supplied update to Transaction Detail page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5582 FRAGRNT FRAGRNT Grant Maintenance

Vendor supplied update to Grant Maintenance page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5558 FTMVEND FTMVEND Vendor Mainteanance

Vendor supplied update to behind-the-scenes matching process. Update has no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5560 FRIGITD FRIGITD Grant Inception to Date

Vendor supplied update to Inception to Date inquiry page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-5595
FPT-5610
FPT-5665
FPT-5688
FPT-5693
FPT-5694
FPT-5696
FPT-5697
FPT-5703
FPT-5690
FPT-5695
FIS Database FIS Database Table/Process Alterations

To accomodate 35-character increase for Vendor Invoice Number and Document Reference field in multiple FIS database tables and processes.
FPT-5593
FPT-5599
FPT-5600
FPT-5601
FPT-5602
FPT-5603
FPT-5604
FPT-5605
FPT-5606
FPT-5607
FIS Batch Server FIS Batch Server Upgrades

Installation of upgraded versions of multiple batch processing system packages and procedures.


​​

December 2021
12/01/21​​​​​​​​​​

Change Number Area/Object Change Description
FPT-4935 FTMVEND FTMVEND Vendor Maintenance

Corrected issue on the E-mail tab where the record-to-record navigation was not working properly with keyboard up and down arrows and also with selection by mouse.

Modified page to prevent errors when users with "Query Only" were reviewing non-vendor persons prior to becoming vendors. Removed query access for users who do not have authority to create vendors.
FPT-4936 FTMINDD FTMINDD Indirect Cost Distribution Maintenance

Corrects issue where users cannot update FTMINDD when their Fund-Organization Security is granted by fund code on FOMUSFN.

Also, Fund-Organization is not applied when using Perform Copy option for future-dated setup, and otherwise Perform Copy stops if an unauthorized record is encountered.
Modified the fund security check to pass the specific Fund code entered rather than the Fund Type code.

Also, modified Fund-Organization Security validation when using Perform Copy with a future-dated distribution, and modified Perform Copy to continue copying records after a record is skipped with an unauthorized Fund-Organization value.
FPT-4937 FRAGRNT FRAGRNT Grant Code Maintenance

Corrected issue causing grant invoices to print with incorrect addresses. Tabbing through the Agency field would inappropriately redefault values overwriting existing address and contact information on the Agency tab when no change was made to the Agency code.

A global variable has been added to store the agency code, and a condition has been added to revalidate and update all of the address and contact information only when the Agency code changes.

Reapplied local UCSC modifications.
FPT-4938 FPACHAR FPACHAR Change Order

Resolves issue in Accessibility mode where some buttons are non-navigable using keyboard navigation.

For Accessibility mode, some non-navigable buttons in Banner Finance Admin have been made accessible using the keyboard.
FPT-4944 FGITRND FGITRND Detail Transaction Activity

Added order functionality to prevent an error where transaction descriptions were being replaced by descriptions from similar activity that exists on different pages of results whenever detail records exist that have the same index code, fund code, organization code, program code, activity code, location code, activity date, rule code, document code, and transaction amount but have different descriptions.

Reapplied local UCSC modifications.
FPT-4945 FYAONLC FYAONLC Wire Transfer Transactions Form

Added validation to the Print Test Pattern button to prevent check processing updates for a Manual check if the button is pressed before selecting one of the Manual or Online options.

Reapplied local UCSC modifications.
FPT-4946 FTMVEND FTMVEND Vendor Maintenance

This update prevents users from inadvertently updating from the Vendor Maintenance tab when they should update only from the Additional Information tab. The Eproc Vendor and Travel System Vendor fields on FTMVEND Vendor Maintenance Tab are now set to display-only (not navigable and not data-enterable).
FPT-4947 FFAADJF FFAADJF Fixed Asset Adjustment

1) Modified the page for the ADPR adjustment to use accounting sequence percentages with greater precision coming from the FFRMASA fixed asset table.

Resolved rounding errors that occured for depreciation adjustments (ADPR) when there were two or more accounting sequences.

2) Modified rounding methods to successfully calculate total percentage amount for all types of fixed asset adjustments. This update corrects rounding errors that occur for multiple accounting sequences when certain fractional values are used for capitalization and other adjustments.

Reapplied local UCSC modifications.
FPT-4948 FAIVNDH FAIVNDH Vendor Detail History

1) Resolved error where querying by Check Date returns all records rather than records that match the criteria, including when using the Basic Filter with a wildcard ""%"".

Added custom filter methods for the Check Date Field to support date searches. Wildcards are allowed only with Basic Filter. An error message is displayed showing the allowed formats if a user enters a different format.

2) Resolved error where queries and invoice amount filters for vendors with extensive history do not finish.

3) Modified the Fiscal Year Filter to fetch the records specific to the Fiscal Year entered in the keyblock rather than fetching all fiscal years.

4) Changed the view FAVVIC2.sql to materialize all virtual fields for Vendor Invoice Amount, Due Date, Check Date, Check Number, Multiple for Vendor Invoice Consolidation, and Pay Type for PayNetExchange, and enabled sorting for all data columns on the page.
FPT-4949 FACICON FACICON

1) Resolved error where after editing the default Tax Group for a commodity, the Tax Group might be automatically reset back to the default value if a user re-enters the commodity section. The defect occurs only for Tax Group changes with Document Item 1 and 2 and only when the number of commodity records for the Vendor Invoice exceeds the number of records per page. For example if 12 commodities are present for the Vendor Invoice and the default display is 10 records per page, then updating the Tax Group for Item 1 or 2 would be lost if a user re-enters the commodity section.

Modified the page to never re-default the Tax Groups for existing commodity records unless a commodity code is changed.

2) The page has been modified to allow users to create accounting records for each commodity without having to navigate back to the invoice header. Also, removed a concurrency violation error that occurred when updating documents in progress and the Access Completion checkbox is checked for a vendor invoice.
FPT-4950 FAAONLC
FAAONLC On-line Check Print

Using the Print Test Pattern button begins check processing updates for a Manual check if the button is pressed before selecting one of the Manual or Online options. An SQL correction must be used to convert the payment from a manual check to an online check to print.

Added the validation for the Print Test Pattern buttton similar to the Print Check button, using the error message "Manual/Online indicator must be 'O' to print test pattern/check".

Reapplied local UCSC modifications.
FPT-4951 FAIINVE FAIINVE-Invoice/Credit Memo Query

For Accessibility mode, some non-navigable buttons in Banner Finance Admin have been made accessible using the keyboard.

Reapplied local UCSC modifications.
FPT-4953 FAABATC FAABATC Batch Check Print

1) Modified the batch checks page to update the row count when check numbers are being deleted and replaced.

Resolves error where users cannot use the Last Good Check Number feature in FAABATC with a check restart.

2) The first check number used for a restart is always the next check number immediately after the Last Good Check Number regardless of the Restart Check Number used. Removed the condition introduced in FAABATC 9.3.12 restricting the Restart Check Number feature.

Reapplied local UCSC modifications.
FPT-4954
FPT-4955
FPT-4956
FGAJVCD
FZAJVCD
FZAJVEL
FGAJVCD/FZAJVCD/FZAJVEL Journal Voucher Entry

1) Resolved issue where accessing the detail accounting sequences takes too long with performance degrading as the number of records increases, for example with more than 1,000 records. Removed Query All Records from FGBJVCD.Manager.Config.xml.

2) Resolved error where after copying an accounting sequence, no FOAPAL redefaulting takes place for the new accounting sequence when changing the Fund or Organization code. Added a new condition for the post-change trigger to enable redefaulting after copying a record.

Reapplied local UCSC modifications.
FPT-4957 FRIGTRD FRIGTRD Grant Transaction Detail Form

Corrected issue where query results do not include Funds from a user’s Fund Type or rollup Fund authorizations on FOMUSFN.

Modified the page to query with the appropriate Fund-Organization Security settings using the appropriate parameters to select all authorization types from FOMUSFN.

Reapplied local UCSC modifications.
FPT-4958 FYAMAST FYAMAST Fixed Asset Master Maintenance

Corrected an issue where invalid Capitalization update creates incomplete Capitalization records and overwrites data in the latest change sequence. The Change Sequence may need to be corrected with SQL if a capitalization adjustment has already occurred. Capitalization records are automatically updated for Gift Type assets when updating the Funding Source using an Account that is not a Class F Asset account.

Updated to suppress all updates to capitalization records when changing the funding source account.

Reapplied local UCSC modifications.
FPT-4959 FYAINVE FYAINVE Invoice/Credit Memo Form

1) Corrected issue where an incomplete Regular Invoice relating to a closed purchase order cannot be deleted unless you first remove the keyblock Purchase Order number. Modified the keyblock to allow changing the Invoice Type from Regular to Direct Pay before the Purchase Order Number is cleared as was allowed with Banner 8. Also, for General Encumbrance invoices to be deleted relating to a closed encumbrance, the warning message that the encumbrance has been closed has been restored.

2) Corrected navigation error where a change to a commodity item in the second or subsequent results page, then navigation to a different commodity item using the keyboard down arrow or a mouse click returns users to the first page of results. Modified keyboard functionality to change the focus to the appropriate next commodity when using the keyboard down arrow.

3) Corrected error where users cannot complete an invoice when certain error conditions exist, and continually receive the error message "WARNING: Continue to complete?" when using the complete button.

4) Modified the disapproval methods to properly set the invoice completion indicator to complete or incomplete correcting issue where FOADOCU, FOAUAPP and FOAAINP could not successfully update invoice header information after invoice status change.

5) For Accessibility mode, some non-navigable buttons in Banner Finance Admin have been made accessible using the keyboard.

6) Corrected issue where the quantity displayed for the purchase order item selection reflects the original quantity ordered not the remaining uninvoiced quantity.

7) Modified commodity section to support record navigation and pagination to prevent tax overrides that might be applied to a different commodity than the commodity enterred when there are multiple pages of commodities.

8) FACICON - With Direct Pay invoicing and Commodity Level Accounting, users cannot enter accounting information using Vendor Invoice Consolidation after completing accounting for the first commodity. Page has been modified to allow users to create accounting records for each commodity without having to navigate back to the invoice header.

Reapplied local UCSC modifications.
FPT-4964 FGIBSUM FGIBSUM Organization Budget Summary

Corrected issue where using the related page FGIBSUM from page FGIBDST can report incorrect totals for Committed and Uncommitted queries depending on the FGIBDST commitment selection, because the totals for FGIBSUM always report Both commit types regardless of the selection on the calling page FGIBDST.

Modified the FGIBDST page to pass the correct Uncommitted or Committed value.

Reapplied local UCSC modifications.
FPT-4968 FTVFUND FTVFUND

Corrected issue where page displays the same Supplemental Data Engine (SDE) indicator status located on the title bar of the Fund Code Validation section (typically seen with the label "More Information"), the indicator does not change when navigating to different records and the SDE value displayed is always the same as the first fund record in the dataset queried.

Reapplied local UCSC modifications.​

​​

December 2020
12/05/20​​​​​​

Change Number Area/Object Change Description
FPT-4544
FPT-4564
FPT-4604
FPT-4635
Banner Admin Common Installed Banner Admin Common, underlying foundation to all Banner 9 Pages, versions: 9.3.14, 9.3.15.1, 9.3.16, 9.3.17.1

Resolves browser issue where Banner pages endlessly spin when using Chrome and Edge.

FGIGLAC General Ledger Activity
Corrected issue where export of large number of data rows never completed. Fix allows for export of large number of rows with no issues.

FOAIDEN Person Identification
Corrected issue with vendor telephone number where Primary Indicator stays checked when telephone number is inactivated. Fix ensures that inactive telephone number cannot be also be a Primary number.

FOIAPPH Document Approval History
Corrected filtering issues that made page unusable. Readded the page to correct user classes, making pages available for users.
FPT-4565
FPT-4602
FPT-4603
Banner General Installed Banner General versions: 9.3.11, 9.3.12, 9.3.13

GJAPDEF Parameter Definitions
Corrected issue with Default LOV field not producing list of values for field. Fix allows LOV to work correctly for Default field.

GUAQUIK Quickflow Definitions
Corrected issue where entry of a non-existant Quickflow process (e.g. by typo) in Current Form field disallows exiting from page until a valid Quickflow process is added. Fix allows for exit from page without having to have a valid entry in Current Form field.

FOIAPPH Document Approval History
Redelivered page that now works correctly.
FPT-4548
FPT-4566
FPT-4605
Banner Finance Installed Banner Finance versions: 9.3.9, 9.3.10, 9.3.11. Redelivered pages with local mods are described below.
FPT-4545 FTMVEND FTMVEND Vendor Maintenance
Corrected auto-commit/unwanted saves issue. Includes new label "UCSC VENDOR DETAILS". Page also includes technical fixes to be compliant with Ellucian standards.
Reapplied local UCSC modifications.
FPT-4546
FPT-4574
FYAINVE FYAINVE Invoice/Credit Memo
Corrected issue where payment due date entered by user was automatically overridden to discount code date without the user being aware. The fix allows the user to update payment due date with no risk that it will revert to discount code due date.

Reapplied local UCSC modifications.
FPT-4575 FFAADJF FFAADJF Fixed Asset Adjustment
Vendor supplied update to Fixed Asset Adjustments. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4576
FPT-4629
FRIGITD FRIGITD Grant Inception to Date
Vendor supplied update to Inception to Date inquiry. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4577 FRIGTRD FRIGTRD Grant Transaction Detail
Vendor supplied update to Grant Transaction Detail inquiry. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4578 FTMFUND FTMFUND Fund Code Maintenance
Vendor supplied update to Fund Maintenance Page.
Corrected issue where FTMFUND fields did not display all data due to field display size. The fix increased the display size of the fields to allow all characters to display to the user.

Reapplied local UCSC modifications.
FPT-4579 GXADIRD GXADIRD Direct Deposit Recipient
Vendor supplied update to Direct Deposit Recipient maintenance page.
Local mods applied to redelivered page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4624 FGAJVCD FGAJVCD Journal Voucher Entry
Vendor supplied update to Journal Voucher entry page. Vendor updates have also been applied to FZAJVCD, and FZAJVEL. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4627 FACICON FACICON Vendor Invoice Consolidation
Vendor supplied update to Invoice Condolidation page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4628 FRAGRNT FRAGRNT Grant Maintenance
Vendor supplied update to Grant Maintenance page. Updates have no impact to UCSC processing.

Reapplied local UCSC modifications.
FPT-4620 FWMEPRO FWMEPRO Eproc User Profile Maintenance
Added entry field for Banner ID for Chrome River implementation.
FPT-4607 FWBPROF_SPRIDEN_ID Updated table behind FWMEPRO to accomodate new FWMEPRO field above.
​​​​​

​​

May 2020
5/16/20​​​​​

Change Number Area/Object Change Description
4446 FRVCFDA CFDA (Catalog of Federal Domestic Assistance) update. Impacts EMF.
4452 FRRTRNC
FGBTRND
FGBTRNH
Increased serial number field in database. Impacts FIS.
4455 FAKB_INVACCTG Resolved bank code issue. Impacts FIS.
4448,
4451,
4456,
4464
FGRACTG process Updated posting process. Impacts FIS.

Corrected out-of-balance tax issue for multi-item/multi-accounting CruzBuy POs. Impacts Procurement Services.

Corrected General Encumbrance liquidation process where multi-item General Encumbrances would not close completely. Impacts Physical Plant.
4465 FZKP_INVOICE Vendor supplied update to invoice process. Impacts FIS.
4466 FPKPUR1 Vendor supplied update to CruzBuy PO process. Impacts FIS.
4468 FAB1099.pc
FAM1099.pc
Vendor supplied update to Year-end 1099 process. Impacts FIS.
​​

​​

March 2020
3/6/20​​​​

Change Number Area/Object ​Change Description
4371, 4439 FWXFUPR Extract report re-formatted and updated for Chrome River implementation. Added additional fields for FIS use only.
4281 frunucp101 Command line prompt used to generate, and archive COA files sent to UCPath. For FIS use only.
4282 frunucp101ftp Command line application used to encrypt and transmit COA files to UCPath. For FIS use only.
​​

​​

February 2020
2/6/20​​​​

Change Number Area/Object Change Description
4309 FTMACCI Corrected issue that required org code to be entered when creating new Index Code record.
4343 FZMFUND Updated page to correctly display Fund Code title in effect. Corrected issue that would not allow future dated records to be created.
4344 FZMORGN Updated page to correctly display ORG Code title in effect.
4345 FZMACCT Updated page to correctly display Account Code title in effect.
4346 FZMACCI Updated page to correctly display Index Code title in effect.
​​


January​ 2020
1/31/20​​​

Change Number Area/Object Change Description
4314 FTMVEND Added new Employee ID and Travel System indicators to accomodate upcoming travel system. Updated label for Eprocurement Indicator to reflect new vendor name. Underlying tables were also updated to reflect changes.
4373 FWMEPRO Changed logic for displaying Eproc Only indicator. Separated single field, and added two new fields for FIS and Travel System indicators. Underlying tables were also updated to reflect new fields.
4383 FWMPROF Updated indicator to reflect database table changes

May 2019
5/9/19​​​​​​​​​​​

Change Number Area/Object Change Description
4153 FZIREFC Fixed issue preventing users from querying with a fund value
4169 FZVSCTR Page now only displays Active service centers. Corrected sort order of Service Center codes (alphabetical, ascending)
4170 FZMORGN Corrected placement of Service Center Code title
4171 FZMACCT Added new UC Path Load Indicator (field was also added to underlying table)
4173 FZAFAUL Numerous corrections: Prevent user from updating new user ID field, enabled filter button, fixed activity date query, added Activity Date to filter, removed unnecessary query fields from Key Block, enabled sort on Activity Date on query result page
4174 FWMEPRO Changes in field position and navigation

April 2019
4/29/19​​

Change Number Area/Object Change Description
4195 Banner Logon The 'Not Authorized' error message issue that Banner users regularly encountered when logging in appears to have been resolved. Users should no longer see 'false alarm' messages that suggest they are not authorized to view Banner.

​​​​March 2019
3/27/19​​​​​

Change Number Area/Object Change Description
4159 fpkb_reqn1.sql
fpkreq1.sql
fpkreqn.sql
fpkpur1.sql
fpkpurr.sql
fpkb_order0.sql
fpkb_order1.sql
fpktdm1.sql
Vendor supplied updates for the listed processes
4160 fupload.pc
fabchk1.sh1
fgpdrol.sh1
fgpocfp.sh1
Vendor supplied updates for the listed processes
4161 fgkp_journa11.sq1
fgkp_journal0.sql
fgkb_jvdetail1.sql
fgkb_jvdetail0.sql
fgbtrnh_081102_01.sql
Vendor supplied updates for the listed processes

March 2019
3/26/19 ​​​​​​

Change Number Area/Object Change Description​
4165 /
4166 /
4109 /
4117 /
4118 /
4147 /
4157 /
4131 /
4112
pcrcoaftp
ppscoaftp
FYRDDVS
aruneprocload
frunimport
arunaiscoaftp
ppschecksftp
frunucopcnx
frusten Scripts
Various internal fixes to correct error handling logic, cosmetic changes to output and updated report formatting. Changes were required as a result of the migration from local Unix to AWS Linux.

​​March 2019
3/14/19 ​​​​​​​​​

Change Number Area/Object Change Description
FPT-4110 FYATRIP Major re-work of FYATRIP:
  • FOATEXT is now restricted from the Key Block (which caused issues because no trip had been created yet)
  • Made three fields mandatory to get to FOATEXT: Traveler Name, Dept Code, and Destination 1. If fields were not populated, trip numbers overlapped in FOATEXT. After these 3 fields are populated, and user saves record or goes to FOATEXT, unique trip number will be created.
  • Once a Trip Number is generated, does not allow user to exit page until Doc Text is added to FOATEXT.
  • Fixed FOAPAL issue when invalid FOAPAL elements were entered, error message was displayed, but users were not forced to correct it. Now they must correct FOAPAL error to navigate out of the field.
  • Corrected error where Dept Name would not display if there was no Traveler Id present (only Traveler Name) even though there was a valid Dept Code. Also forced Dept Code to validate, requiring a valid dept code.
  • Corrections made to Traveler ID and Traveler Name fields - When a valid traveler id is entered and traveler name is populated, you cannot get the traveler name field and type over a different name. If a traveler Id is entered and then removed, you can get to the traveler name field and type in a free form name. (and when trip record is saved, whatever is currently in these fields will be saved to the record).
  • Logic was fixed so that a Return Date must be greater than or equal to the Depart Date. If less than an error message will appear and you will not be able to navigate out of the field until corrected.
  • Trip Number field in Key Block was fixed so only valid values are NEXT, or existing trip number. Page will not allow a record with the Trip number of “NEXT” to get saved to the underlying table.
  • The Insert and Copy functions including Down arrow, F6, F4 or the page options, have been disabled."

February 2019
2/12/19

Change Number Area/Object Change Description
4087 /
4088 /
4089 /
4090 /
4092 /
4093 /
4094 /
4095 /
4097 /
4100 /
4102 /
4103 /
4106 /
4107 /
4108 /
4109 /
4111 /
4125
FISProdSchedEdit
FYPDIRD
frunsqpostb
arundailyreset
suspendeddocs
FYPOSTSTOP
FYRBANKS
FYRDDTI
FYPDDTI
FYPOSTSTART
FYRFFER
FYXEIIN
FZPCULB1
FZPCULB3
frunppschecksftp
FYRDDVS
FYRE100
frunppschecks
Various formatting and cosmetic changes made to remove extraneous characters during move from Unix to Linux in the AWS migration.
4133 FOAUAPP Corrected FOAUAPP behavior not displaying all documents in user approval queues. User no longer needs to add a check to the 'Next Approver' field in order to see all documents in approval queue

January 2019
1/31/19

Change Number Area/Object Change Description
4098 FYAINVE Page Modified code to generate I-doc number prior to user navigating to Commodity Block to enhance system stability. Because update is performance based and not visible to users, -L1 was added to the page title.

December 2018
12/1/18

Upgrade to Banner 9. Migration to AWS from on prem, and transition from Unix to Linux.

May 2017
5/13/17

Change Number Area/Object Change Description
3291 FZPBITD Process Update activity date and User ID when records are inserted
3413 FOMPROF Form The Person ID field in FOMPROF has been changed from an editable field to a read-only display value. This change removes insert, update and delete access to the GOBEACC table that FOMPROF previously allowed. With this change, only users with access to GOAEACC can change the Person ID associated with an Oracle User ID
3416 /
3418
FYM1099CA
Local Process
and
FYB1099CA
Local Table
FAM1099 includes new "Card Not Present" data field. Field was also added to FAB1099 table. The updated vanilla form, process, and table were cloned to keep local California versions of process and table (FYM1099CA and FYB1099CA) in sync
3420 GUAINIT form New logic was added to this form. At the start of each new Banner session, the form's new triggers populate the three new global values representing the proxy SID, the user's proxy authorization, and whether the proxy is enforced or not
3421 GJAPCTL form Modify validation logic in form GJAPCTL.fmb in trigger WHEN_VALIDATE_ITEM on item KEY_BLOCK.KEYBLCK_JOB. Added a test case to verify that form PXPVRFY can not be processed from Process Submission Controls
3422 FGRTRNI process Process fgrtrni.pc has been enhanced for 8.10.1.1 to utilize both the sleep/wake feature and the Feed approval feature introduced in Finance 8.10
3423 FGRACTG process Updating procedure to set new indicator when a foreign vendor is used in requisition. PO table stores converted amount only when currency is non base
3426 FZRCULB Process Converted FZRCULB to FZXCULB extract report

February 2017
2/2/17

Change Number Area/Object Change Description
2517 /
2567
FYPENCLIQ Process Fixed the following issues: PID was being incorrectly displayed in email, added record counts to email, updated email and log formatting
3296 /
3364
aruneprocload Process Fixed the following issues: parser issue where non-standard text characters could not load into FIS database, updated parser to load correct workorder values into FIS database
3342 FYPPCARDFATLD Process Fixed issue where procard process would continue to run every 20 minutes
3374 /
3377 /
3378
frunedbssnftp,
frunppschecksftp,
frunppsftp Scripts
Updated file path for script to find files in rsynced directory on deadwood. Removed command to mark the files as .SENT
3372 /
3373 /
3375 /
3376
fruncafftp,
fruncfsftp,
frunendowftp,
frunitffftp Scripts
Updated file path for script to find files in rsynced directory on deadwood

September 2016
9/22/16

Change Number Area/Object Change Description
3275 FYXCKXT Report Modified Extract Report to look at the bank code in the FARINVA table instead of the FABINVH table to accommodate the changes made to E-Invoices which leave the bank code in FABINVH blank
3274 FYXACHA Report Modified Extract Report to look at the bank code in the FARINVA table instead of the FABINVH table to accommodate the changes made to E-Invoices which leave the bank code in FABINVH blank
3276 FYXINCK Report Modified Extract Report to look at the bank code in the FARINVA table instead of the FABINVH table to accommodate the changes made to E-Invoices which leave the bank code in FABINVH blank
3242 procardreset Created a new autosys job (and accompanying FIS scripts) separate from dailyreset - a clone of dailyreset3 that runs separately at 9am and will only run Monday thru Friday
3253 ProCard Jobs Modified various procard scripts, arun jobs, and ksh files to look at what database is being used and tell AutoSys so that procard runs can occur simultaneously in separate databases without interfering with one another
3256 FIS Daily Prod Schedule Modified FIS_Daily_Production_Schedule to include the new procardreset job which will run separate from DailyReset at 9am Monday thru Friday
3292 /
3293
FGIOENC Form Retired FGIOENC form mod, and inserted database profile to allow access to form directly, and through FGIBDST
3302 eprocmove /
aruneprocload /
aruneprocsweep
Resolved issue so production tickets are created in production ITR environments and not dev

 

June 2016
6/17/16

Change Number Area/Object Change Description
3163 FZVDISC Form Added functionality to include user id and time stamp with system date upon commit. Impacts FIS and Planning & Budget Office.
3164 FZVUASC Form Added functionality to include user id and time stamp with system date upon commit. Impacts FIS and Planning & Budget Office.
3165 FZMACCI Form Added functionality to include user id and time stamp with system date upon commit. Impacts FIS, FAR and Planning & Budget Offices.
3167 FZMORGN Form Added functionality to include user id and time stamp with system date upon commit. Impacts FIS and Planning & Budget Office.
3146 FZCTRMC Report Replaced list of hard-coded Service Center codes with logic to call codes from parameter definitions table to provide more efficiency for Fiscal Close processing. Impacts FIS.
3169 FZPJBAJ Process Replaced list of hard-coded Service Center codes with logic to call codes from parameter definitions table to provide more efficiency for Fiscal Close processing. Impacts FIS.
3170
3184
FZRBDRL Process Replaced list of hard-coded Service Center codes with logic to call codes form parameter definitions table to provide more efficiency for Fiscal Close processing. Also upgraded to version 8.9. Impacts FIS.
3186 FZRENRL Process Upgraded to version 8.9. Impacts FIS.
3196 FZRINEX Report Replaced program code logic with orgn code logic to accurately capture agency fund/org combination errors. Impacts FAR Office.
3201 FYXUPINV Report Created new fiscal close invoice status report to replace 3 reports (FYCIINV, FZXMATC & FYXINVH). Impacts FIS, FAST Office.
3156 FYXEIIN Report Add column to identify invoice Office of Record. Impacts FAST Office.
2205 FYPARPFILE Process Allow for multiple bank files to be created and uploaded to Wells Fargo in the same day. Impacts FAR Office.

 

March 2016
3/24/16

Change Number Area/Object Change Description
3066 FYRW2TR Report Fixed issue where Journal entries were not displaying the employee ID on the report. Impacts FAR Office.
3068 FYRADDR Report Report has been re-written to include the new "TE" Tax Entity address functionality. Impacts FAR Office.
3050 FYPDIRD Process Change to ACH processing which combines FAPDIRD, FARDIRD and FAPTREG into one process called FYPDIRD. Impacts FAR Office.
3097 FAABATC Process Modification of Hint Text to accommodate the new FYPDIRD process for ACH Checkwrites. Impacts FAR Office.
2468 TablePrune Process Added Data Extract collector tables (guboutd and guroutd) to weekly TablePrune clean-up script. Impacts FIS.
3081 FWMEPRO Form Fixed issue where form would not accept Ship To addresses longer than 30 characters. Impacts Enterprise Financial Systems.
2949 FZRPPSSPC.SQL PPS Check Special Check Handling email fixed so number of checks reported as ready for processing will not be overstated if multiple files are processed within the same calendar day. Impacts Payroll Office.
3043 PostProbDocs Process Fixed issue where suspended invoices were not being reported from Banner daily posting output. Impacts Enterprise Financial Systems.

October 2015
10/22/15

Change Number Area/Object Change Description
2800 FAIVNDH form FAIVNDH (Vendor History)
Now displays check number of canceled check for invoices with an Open/Paid indicator of "O". Previously the form did not display canceled check numbers so no audit trail was available to determine invoice status.
Impacts FAST and FAR offices.
2801 FOAUAPP form FOAUAPP (User Approval)
Fixed approval defect where disapproved change orders to CruzBuy POs could not be modified.
Impacts Procurement Services
2827 FRAGRNT form FRAGRNT (Grant Maintenance) Modified to add tab for Pass Through Agency, in addition to accessing via the Options menu; Indirect Cost Encumbering box added the Cost Code tab [but disabled due to non-implemented process]; and functionality added to prevent unwanted commits in Personnel tab for existing records.
Impacts Extramural Funds Office.
2869 FRMFUND form FRMFUND (Research Accounting Fund Maintenance)
Indirect Cost Encumbering box added [but disabled due to non-implemented process].
Impacts Extramural Funds Office.
2871 FAACHKS form FAACHKS (Check Cancellation) New Reason Code (optional) to state why checks are being cancelled. New feature that stops you from cancelling a check that has already been reconciled with the bank. New feature that warns you when you are cancelling a check where a foapal element from one of the payments on the check is now invalid.
Impacts FAR Office.
2872 FRIGITD form FRIGITD (Grant Inception-to-Date) Enhanced with options to query by Budget Pool or to exclude Indirect Costs.
Impacts Extramural Funds Office and campus Research Accountants.
2873 FRIGTRD form FRIGTRD (Grant Transaction Detail) Enhanced with option to display detail by specific Pool Account.
Impacts Extramural Funds Office and campus Research Accountants.
2879 FTMCARD form FTMCARD (Purchase Card Maintenance) No changes to functionality – new fields at the bottom of the form which apply to TEM system integration that we do not use at the present time so they should remain blank.
Impacts FAST Procard Team.
2901 FAB1099 print process FAB1099 (1099-MISC Forms Print) New functionality where single 1099s (correction or not) can be printed directly from Banner.
Impacts FAR Office.
2915 FYAINVE form FYAINVE (Invoice/Credit Memo)
1) Fixed regular invoice zero accounting sequence defect.
2) Fixed regular invoice Received field defect that allowed items to be received and matched without a Receiver document.
Impacts FAST office.
2948 GXADIRD form GXADIRD (Direct Deposit Recipient) New User Id field and accompanying history form (GXIDRDH) which shows history of when updates are done and who did them (does not apply to email updates).
Impacts FAR Office.
2987 FGRTRNI process FGRTRNI (Interface Feed Process) Enhanced by adding options for interface file disposition.
Impacts EFS.
2994 FGRACTG process FGRACTG (Posting Process) Modified to create indirect cost encumbrance journals.
No impact at this time (Indirect Cost Enumbering not implemented).
8.10 Upgrade FTMINDR form FTMINDR (Indirect Cost Rate Code Maintenance) Enhanced to accept 4 decimal places in the Indirect Cost Rate and Memo Rate fields.
Impacts Extramural Funds Office.
8.10 Upgrade FRVINDR form FRVINDR (Indirect Cost Rate Validation) Width of the Indirect Cost Rate description field expanded and title of the Federal Negotiated Rate column updated to eliminate the abbreviation.
Impacts Extramural Funds Office.
8.10 Upgrade FTMPAYM form FTMPAYM (Grant Payment Method Maintenance) Expanded bank code field.
Impacts Extramural Funds Office.
8.10 Upgrade FABMATC process FABMATC (Receiving Matching Process) New parameter provides option to include (N) or exclude (Y) future-dated receipts (receipts dated in a period later than the invoice).
Impacts FAST office.
8.10 Upgrade FAICHKH form FAICHKH (Check Payment History)
New Check Cancel Code describes reason why check was canceled.
Impacts FAR office.
8.10 Upgrade FPQCHAP form FPQCHAP (Purchase Order Item Selection)
Fixed item selection defect where accounting records were not being created when zero-dollar commodities were individually selected in change orders.
Impacts Procurement Services.
8.10 Upgrade GJIREVO process GJIREVO (Saved Output Review)
Output of available files in GJIREVO has changed. Now select file ending in .lis for correct Database print output.
Impacts FIS User.

 

July 2015
07/13/15

Change Number Area/Object Change Description
2878 FYPARPFILE Process Change in process to stop it from picking up the new "Zero" type checks and including them in the bank file as they should not be there.
2863 FZCTRMC Report Modified Activity Code fiscal close edits report to prevent carry forward budgets having SOCSCI and SOCSUA activity codes from carrying forward. Impacts Enterprise Financial Systems.
2864, 2865, 2867 FZPACTV
FZPJBAJ
FZRBDRL
Processes
Modified various fiscal close clean-up reports and processes to prevent carry forward budgets having SOCSCI and SOCSUA activity codes from carrying forward. Impacts Enterprise Financial Systems.

May 2015
05/11/15

Change Number Area/Object Change Description
2667 FZMFUND Form Modified FZMFUND (Fund Local Attribute Maintenance Form) to add new Federal Financial Reporting field and UCPath Budget Offset Org field. Added functionality to include time stamp with system date upon commit.
Impacts Extramural Funds Accounting office and UCPath.

February 2015
02/13/15

Change Number Area/Object Change Description
2608 FZXUCOP3 Report Converted FZRUCOP3 (paper report) to FZXUCOP3 (extract report) for delivering fund attribute data via email. Per request from Extramural Funds Accounting Office. This complies with the Chancellors' Sustainability Challenge.
2653 FZPSRVD
FZPSRPO
FZPSRAP
Created various processes and data files in support of P200 project per UCOP Working Smarter initiative.
Impacts Procurement Services Office.
2665 FZPJVDELETE Created tool to manage incomplete journal vouchers.
Impacts Enterprise Financial Systems.
2705 FPAPORD
FPACORD
Updated Terms & Conditions on boiler plate for printed Purchase/Change Orders per request from Procurement Services Office.
2707 FYXACHA Increased email size limit from 5MB to Google standard of 25MB for delivering ACH report via email.
Impacts FAR Office.
2669
2671
2674
2675
2676
2677
2678
2683
2698
2699
2726
DBEU - Various Technical install vendor-provided Data Base Extension Utility for compatibility with future vendor releases.

October 2014
10/06/14

Change Number Area/Object Change Description
2582 FZXAGCY Report Agency Sponsor Codes Report
Redesigned Agency List report to provide data in an Excel format instead of printed report. FZXAGCY replaces FZRAGCY.
Impacts Extramural Funds office.
2618 FYRFFER Report Fixed Asset Edit Report
Repaired logic that reported incorrect data for the Equipment Management Group.
Impacts Equipment Administration office.
2308 REPOSTPOTOSQ Process Repost PO to SciQuest Process
Resends posted PO data from Banner to SciQuest.
Impacts Enterprise Financial Systems and Procurement Services office.
2617 FYITRIP Form Travel Management Query Form
Internal modifications to query functionality.
Impacts FAST office.

July 2014
07/30/14

Change Number Area/Object Change Description
2502 FYXEIBT Report Einvoice Benefit Tracking Extract Report
Creates extract report of Einvoices processed by FAST/Office of Record users in Banner within set date range.
Impacts Procurement Services office.
2503 FYXFSTA Report FAST Invoice Turnaround Extract Report
Creates extract report of turn-around time for invoice payments processed by FAST users in Banner within set date range.
Impacts FAST office.
2474 FZCTRMC Report Modified Activity Code fiscal close edits report to accommodate new Service Center Code, RISKSV.
Impacts Enterprise Financial Systems.
2476
2477
2478
FZPACTV
FZPJBAJ
FZRBDRL
Processes
Modified various fiscal close clean-up reports & processes to accommodate new Service Center Code, RISKSV.
Impacts Enterprise Financial Systems.

April 2014
04/28/14

Change Number Area/Object Change Description
2383 FTMACCT Form Removed prior modification that returns cursor to COA field after record is comitted. Cursor behavior is now vanilla.
Impacts General Accounting and Planning & Budget offices.
2401 FZIAGLC Form Set upper case attrubute on specific fields to provide ease of use for entering queries.
Impacts Enterprise Financial Systems and General Accounting office.
8.8 Upgrade FRVCFDA Form Expanded overall data view due to Agency Name field increase from 70 to 120 characters.
Impacts Extramural Funds office.
8.8 Upgrade FTMAGCY Form Removed unnecessary pop-up message when creating new agency.
Impacts Extramural Funds office.
2238 FAABATC Form New Zero Check Option - Allows posting of Zero Amount Checks to assist in clearing cash advance documents and credit memos.
Impacts FAST and FAR offices.
2391 FAACHKS Form Added ability to cancel and re-establish new Zero Amount Checks when necessary.
Impacts FAST and FAR offices.
8.8 Upgrade FAA1099 Form Added new field that displays our Institution's TIN.
Impacts FAR office.
2413 FAB1099 Process Added new ability to print single 1099's and ability in conjunction with FTMVEND to set up default 1099 addresses to lessen the year end edits that have taken place.
Impacts FAR office.
2368 FTMVEND Form Moved 204 Indicator to Additional Information tab, added new 204 Status Date field.
Retired locally-maintained FYATELE-Telephone form (accessed from FTMVEND Address tab) and replaced with FOAIDEN-Person Identification form Telephone tab.
Impacts FAR and Procurement Services offices.
2430 FYATELE Form Retired locally-maintained FYATELE-Telephone form and replaced with FOAIDEN-Person Identification form Telephone tab.
Impacts Procurement Services office.
2371, 2372 FPAREQN Form
FPAPURR Form
Removed Hazardous Materials entry field due to retirement of FYAHZMT form. All hazardous materials purchases are now fully-tracked within the CruzBuy eprocurement system.
Removed default FOB value 01 from newly-created Banner Requisitions and Purchase Orders. Buyers will need to add FOB value manually as necessary.
Impacts Procurement Services office.

December 2013
12/16/13

Change Number Area/Object Change Description
2266 Procard Process Re-engineered the daily Procard transaction process to leverage automated scheduling capabilities.
2353
2354
UCOP Edit Process Removed report printing modules from Monthly UCOP edit process in alignment with the Chancellors Sustainability Challenge.
2342 Encumbrance Liquidation Package Enhanced automated encumbrance process to accommodate recharges processed through CruzBuy by participating campus recharge departments.

September 2013
09/14/13

Change Number Area/Object Change Description
2228 UCOP CAF Process Modified monthly UCOP Corporate Account-Fund submission to select currently effective organization and account code titles (rather than associated index code titles.) Per request from Planning & Budget Office.
2185 Forms Fixed Expert Query defect 'FRM-40367 Invalid criteria in field'. Functionality is once again available for searchable Banner fields.
2206 FYRFFER Report Modified FYRFFER Report to correct defect which caused report to crash when report contained zero value assets. Impacts FAR Equipment Administration office.
1963 FZMFUND Form Re-designed FZMFUND (Fund Local Attribute Maintenance Form) to add new E-verify & NIH Cap Amount fields for UCPath. Set upper case attributes where missing and delete SRF Exclusion Indicator. Added functionality to capture User ID and system date upon commit. Impacts Extramural Funds Accounting office.
2189 FPAPURR Form Fixed FPAPURR/FPACHAR document text defect 'FRM-21011: PL/SQL unhandled exception ORA-06508'. FOIAINP work-around no longer needed to successfully add document text to a PO or CO. Impacts Procurement Services.
2194 FZXEMAR Report Modified FZXEMAR (EMF Unbilled&Receivables Extract Report) to improve data consolidation for each fund and fix date format. Add accountant name and fund status indicator. Per request from Extramural Funds Accounting Office.

June 2013
06/21/13

Change Number Area/Object Change Description
2148 FYATRIP Form Add amount fields to FYATRIP (Travel Management Input Form). Per request from FAST office.
2150 FYITRIP Form Add amount fields to FYITRIP (Travel Management Query Form). Per request from FAST office.
2053 Encumbrance Process Implemented process to liquidate prior month Catering Service encumbrances fed from CruzBuy (when associated Recharge is posted.) Per request from Purchasing and Catering Services.