Navigate Up
Sign In
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 email fis_probs@ucsc.edu.

 

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

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.
University of California Santa Cruz, 1156 High Street, Santa Cruz, Ca 95064
© 2016 Regents of the University of California. All Rights Reserved.

Site Feedback
finaff-tech@ucsc.edu