FIS 9.0 Summary of Release ChangesMaintenance Pack 3.01 S Draft or Fin

/ FIS 9.0 Summary of Release Changes
Maintenance Pack 3.01
Release Date: 09/23/10

About This Document

This document provides a high-level summary of the content delivered in each CMS Maintenance Pack. The following product and module abbreviations are used as the primary sort key in each table.

Financials Module Abbreviations

Initials / Product Line (or) Module / Initials / Product Line (or) Module / Initials / Product Line (or) Module
AM / Asset Management / AP / Accounts Payable / AR / Accounts Receivable
BI / Billing / FS / Finance - General / GL / General Ledger
PO / Purchasing

1.0Oracle Bundle(s) and Fixes

Contents in these tables are sorted first by product or module name and then by bundle name.

FIN: Financials, SCM: Supply Chain Management

Module / Bundle Name / CMS HD # / Resolution Description
N/A / N/A

2.0Oracle Emergency Fix(es)

Contents in these tables are sorted first by product or module name, and then by Oracle case number.

Module / Oracle Case # / CMS HD # / Resolution Description
N/A / N/A

3.0CMS Development

Contents in these tables are sorted first by product or module name and then by CMS help desk number.

Type Key: [E] Enhancement [F] Fix [N] New

Module / CMS HD # / Mod # / Modification Name / Resolution Description / Type
ALL / HD188563 / FS07002 / Reporting Solution / Issue:
  • CSU_DOC_LN_DESCR field truncates at 30 characters. - Campuses require254 characters.
Resolution:
  • Create field, CSU_DOC_LN_DSC_LNG, with 254 characters inCSU_R_ENCDT_CMP table. The complete value of the DESCR254_MIXED field from PO_LINE table is captured.
/ E
AP / HD179300 / AP08001 / ACH Payment Processing / Issue:
  • CSU_ACHEMAIL program should only send Email notifications to EFT payment vendors.
Resolution:
  • Add criteria for Payment Method equal “EFT” to the Application Engine logic.
/ F
AP / HD187590 / AP09001 / Open Item Key Setup / Issue:
  • The CSU_OI_VNDR_VW, Open Item view is limited to vendor classification employees. Unable to pay the student travel advances.
Resolution:
  • Modify the Open Item view to allow users the ability to process travel and salary advances for vendor classifications not equal to “Employee”.
/ F/E
AP / HD189515 / AP07002 / AP Queries / Issue:
  • CSU_UNRECON_CHK_CSH_BAL
Shows incorrect Monetary Amount when the voucher has multiple voucher line numbers with the same amount.
  • Multiple Bank Accounts are retrieved.
Resolution:
  • Add Voucher Line Number & Distribution Line columns.
  • Add Bank Acct Key prompt.
  • Remove criteria Calendar DT as default and add record BU_LED_GRP_TBL to locate the calendar ID.
  • Add field criteria APPL_JRNL_ID to only search for “CANCEL” and “PAYMENT”.
/ F/E
AP / HD189915 / AP09003 / Voucher Status Listing / Issue:
  • The Accounting Date is not included in the Voucher Status Listing Report for status equal “Unposted”.
Resolution:
  • Modify the program to include the Accounting Date criteria for Vouchers with status equal “Unposted”. Also display the Accounting Date on the report.
/ F
AR / HD188241 / AR02001 / AR Aging by Fund and Account Report / Issue:
  • Performance of the 3 CSU AR Aging reports is very slow and even stalls on many campuses. This degradation seems to be related to views PS_CSU_AAT_ALL_VW and PS_CSU_FNAT_ALL_V1, included in MP2.
Resolution:
  • The two views seem to have an adverse effect on the Oracle optimizer. Add an ORDERED hint which simplifies the Oracle optimizer path.
/ E
AR / HD188241 / AR09002 / AR Aging by Customer Report / Issue:
  • Performance of the 3 CSU AR Aging reports is very slow and even stall on many campuses. This degradation seems to be related to views PS_CSU_AAT_ALL_VW and PS_CSU_FNAT_ALL_V1, included in MP2.
Resolution:
  • The two views seem to have an adverse effect on the Oracle optimizer. Add an ORDERED hint which simplifies the Oracle optimizer path.
/ E
AR / HD188241 / AR09003 / AR Aging by SCO/CSU Fund and Account Report / Issue:
  • Performance of the 3 CSU AR Aging reports is very slow and even stall on many campuses. This degradation seems to be related to views PS_CSU_AAT_ALL_VW and PS_CSU_FNAT_ALL_V1, included in MP2.
Resolution:
  • The two views seem to have an adverse effect on the Oracle optimizer. Add an ORDERED hint which simplifies the Oracle optimizer path.
/ E
AR / HD190933 / AR09004 / Dunning Letter / Issue:
  • Change the Dunning Letter Remit-To Address to use the Business Unit Definition Location instead of the PeopleSoft delivered logic for the Bank Account address.
Resolution:
  • Change program logic to select Remit-To Address from the Business Unit Definition Location address.
/ F
BI / HD185958
HD188062
HD185194
HD192775 / BI09002 / Billing Upload / Issue:
  • ChartField values should be in the same order as PeopleSoft delivered values.
  • Need to add two date fields, FROM_DT and TO_DT
  • When the Billing Business Unit is not set up as a General Ledger Business Unit, the FTP functionality on the Billing Upload Run Control page does not recognize the Billing Business Unit.
Resolution:
  • The ChartField Class is now placed preceding the Project ID.
  • Two date fields, FROM_DT and TO_DT, have been added preceding “Text254” field.
  • Change PeopleCode logic to find the associated General Ledger Business Unit.
/ E
BI / HD185958
HD188062
HD185194 / BI09003 / Automatic Invoicing / Issue:
  • ChartField values should be in the same order as PeopleSoft delivered values.
  • Need to add two date fields, FROM_DT and TO_DT.
Resolution:
  • The ChartField Class is now placed preceding the Project ID.
  • Two date fields, FROM_DT and TO_DT, added preceding “Text254” field.
/ E
BI / HD188536
HD190926 / BI09001 / Billing Crystal Invoice / Issue:
  • Crystal Invoice Remit-To location should use the Business Unit Definition Location instead of the PeopleSoft delivered logic for the Bank Account address.
  • Crystal Invoice prints multiple invoices on the same page.
Resolution:
  • Change program logic to select Remit-To Address from the Business Unit Definition Location.
  • Restore Page Break after each Invoice ID.
/ F/E
GL / HD193426
HD193294 / GL09009 / Investment Distribution Allocation (IDA) / Issue:
  • The Project ID field on the generated file is limited to 6 characters. Campuses with longer Project ID's cannot upload the generated file into General Ledger.
  • The program creates a row of data even when the expected posted amount is less than $.01
Resolution:
  • Update the SQR (CSUGL027) for Project ID to allow maximum of 15 characters.
  • Modify the SQR (CSUGL027) program to ensure that rows containing amounts which round to $0.00, are not inserted into the generated file.
/ F
PO / HD191017 / PO99011 / Modify Purchase Order Print Format / Issue:
  • Line Description is not printed the way it is entered online.
  • PO Line Description text does not wrap correctly on the Purchase Order form.
Resolution:
  • Modify[popo005.sqr} to includethe carriage return in theprintedthe text.
/ F

Appendix A: Documentation Updates

Documents listed below have been identified and scheduled for an update to support changes in this maintenance pack. Please note, only changes that impact the campuses’ ability to apply this maintenance pack and/or implement new functionality are updated with maintenance pack releases. Minor changes to documents are made according to the normal application upgrade cycle.

While every effort is made to release the new documents on the same day of the maintenance pack release, this is not always possible. In cases where the updates are pending, CMS will deactivate the link for the older version of the document on the CMS website to avoid downloading the improper version. The link will then be reactivated on the CMS website when the new update is posted.

Module / Document Type / Document Name
AP / Design Specification / AP07002_CFS90-DS_APQueries
AP / Design Specification / AP08001_CFS90-DS_ACHPaymentProcessing
AP / Design Specification / AP09001_CFS90-DS_OpenItemKeySetup
AP / Design Specification / AP09003_CFS90-DS_VoucherStatusListing
AP / User Guide / CFS90_UG_AP_APReportsandEnhancements
AP / Business Process Guide / CFS90_BPG_AP_TravelAdvanceandExpenseProcessing
AR / Design Specification / AR02001_CFS90-DS_ReceivableAgingbyFundandAccountReport
AR / Design Specification / AR09002_CFS90-DS_ARAgingCustomer
AR / Design Specification / AR09003_CFS90-DS_ARAgingSCOCSUFund
AR / Design Specification / AR09004_CFS90- DS_DunningLetter
AR / User Guide / CFS90_UG_ARBI_AR09004_DunningLetter
BI / Design Specification / BI09001_CFS90-DS_BillingInvoice
BI / Design Specification / BI09002_CFS90-DS_BillingUpload
BI / Design Specification / BI09003_CFS90-DS_AutomaticInvoicing
BI / User Guide / CFS90_UG_ARBI_AccountsReceivableReports
BI / User Guide / CFS90_UG_ARBI_BI09002_Billing Upload
BI / User Guide / CFS90_UG_ARBI_BI09003_AutomaticInvoice
GL / Design Specification / GL09009_CFS90-DS_Investment_Distribution_Allocation
PO / Design Specification / PO99011_CFS90-DS_ModifyPurchaseOrderPrintFormat

Release Date: 09/23/10Page 1 of 6