...
| Updated | Resolved | KFS Module | Summary | Description | Key | Linked Issues | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013.1011.0714 | 2013.1011.0714 | Purchasing | Update Equipment Review Object Codes Parameter | Only keep the following Parameter Value codes: 8005 8010 8032 8033 8085 8105 8110 8155 8160 8175 Please modify and remove the order codes.KFSI-6061KFSI-6459 Update item type DISC to be non taxable on CFG | Hi Melissa, Please update the item type code DISC to be non-taxable on CFG (reference the one on INT). Jane | KFSI-6496 | |||||||
| 2013.1011.0412 | 2013.0807.2809 | Contracts & Grants | Reload ICR Rate Table -- when # is used Sub-Account must be dashesTrini found out that you cannot use # in the sub-account field -- when you use @, you can put @ in the sub-account field, however. Please see the screenshots comparing how ours is and foundation's. This means we need to reload ICR Rate table to avoid validation errors | KFSI-4829 | 2013.10.03 | 2013.10.03 | Identify Management/Workflow | Create a new role: Technical Support and grant Batch File permission | Create a new role: Technical Support Award Proposal Table | The Proposal Purpose table should contain the purpose codes from SPA system. Please reload the table. Victor, please approve. | KFSI-4073 | KFSI-4072 | |
| 2013.11.07 | 2013.11.07 | Financial Processing | Populate BAC Users | Workflow for BAC should only have BAC Users and GA Reviewer as approver. | KFSI-6377 | ||||||||
| 2013.11.05 | 2013.11.05 | Chart of Accounts | Account Purpose Text and OSHPD sub-types are missing in some of the MC accounts | Wan reported that some of the MC accounts do not have account purpose text and OSHPD sub-types. Can you work with Alvin to clean them up? | KFSI-6082 | ||||||||
| 2013.11.05 | 2013.11.04 | Chart of Accounts | KFSI-6387 Update Medical Center Accounts with OSHPD Accounts | Please update Medical Center KFS Accounts with OSHPD Account numbers provided on 10-30-13 config worksheet from Renee. | KFSI-6440 | ||||||||
| 2013.11.05 | 2013.11.05 | Chart of Accounts | Capital Category Code Missing on MC Accounts | Capital Category code is missing on some Medical Center accounts. | KFSI-6443 | ||||||||
| 2013.11.05 | 2013.11.05 | Chart of Accounts | OFT Indicator for L300 should be "F" (Offset) | We have noticed that SMS feed is getting L300 from KFS even though we have specified that liability offset should not be brought to SMS. When we investigated, we realized that L300 (payment offset) is set to "O" (Object Code) instead of "F" (Offset). Please correct this indicator. | KFSI-6434 | ||||||||
| 2013.11.04 | 2013.11.04 | Chart of Accounts | Update SFG Code on KFS Accounts with UC Fund 18888 | Update SFG Code for KFS Accounts with UC Fund 18888 to 410290 on MC charts. Update KFS Accounts with UC Fund 18888 to BALANC for IR Charts. Also remove CG Account Responsibility ID. | KFSI-6332 | ||||||||
| 2013.11.01 | 2013.11.01 | Unknown | Inactivate Role 92 Restriction on CR Document and Allow Role 54 users to Initiate CR document | Cash Manager role should be able to initiate and approve CR & CCR documents but never initiate or approve the SAME document. Please Inactivate Role 92 exclusion to allow Role 54 users to Initiate. Another JIRA will be processed for Separation of Duties. Overview Role: 92 Type Name: Derived Role: Cash Receipt Initiator Namespace: KFS-FP - Financial Processing Role Name: Cash Receipt Initiator Active?: Yes Role Description:Users authorized to initiate Cash Receipt documents. This role exists to exclude Cash Managers from being able to initiate Cash Receipt documents. You do not need to add explicit members to this role to accomplish this exclusion. | KFSI-6423 | KFSI-6401 | |||||||
| 2013.10.31 | 2013.10.31 | General Ledger | Change COLLECTOR_FILE_USER_EMAIL_ADDRESS to kfs@uci.edu | Turned out kfs-support@uci.edu is a bad email address. Brenda requested to change it to kfs@uci.edu | KFSI-6382 | ||||||||
| 2013.10.30 | 2013.07.25 | Chart of Accounts | Correct main campus account Fiscal Officer, Supervisor and Account Managers | Write an update script to update existing KFS account fiscal officers. Exclude the Control accounts and exclude the plant accounts. | KFSI-4654 | KFSI-5721, KFSI-4392, KFSI-5052, KFSI-4666 | |||||||
| 2013.10.30 | 2013.10.29 | Chart of Accounts | Assign Control Account for Medical Center KFS Accounts | Assign Control Accounts to Medical Center KFS Accounts. Determine Control Account from the UC Fund on the KFS Account. Exclude funds 18888, 67010, and 89999. | KFSI-6331 | KFSI-6330 | |||||||
| 2013.10.29 | 2013.10.29 | Chart of Accounts | Load SMS Balance Sheet and Revenue Accounts to New Extended Attribute of Account | In order to feed SMS transactions from KFS, we found out that the balance sheet and revenue accounts do not follow the same account conversion scheme as the expenditure accounts. These will be converted as OSHPD account number + 2 to 7 digit of KFS account number. Therefore, we have extended the account table (Med Center tab) under OSHPD category. This optional field has been added to the account extension table. Please populate the values from the GL Config Sheet --> SMSConv tab. You will need to translate KFS Account/Fund --> SMS Account (15 digits). Once we go live, the account will be maintained on-line by the MC Controller's Office. The field name is OSHPD_ACCOUNT_NBR. | KFSI-5544 | KFSI-5491, KFSI-6387 | |||||||
| 2013.10.29 | 2013.10.29 | Chart of Accounts | Add New NAC, SFGT, and SFG Code and Inactivate NAC, SFGT, and SFG Code for Error Loading | Please add new codes for Medical Center NAC - MCM SFGT - MM SFG - MCMEMO Update MC Accounts with SFG ERRSUB to the new SFG MCMEMO Inactivate the following NAC - ERR SFGT - ER SFG - ERRSUB Updates are on the COA Master 2013.10.24 Account config worksheet and Medical Center accounts to update are on the Master MC COA Config Plant (Cynthia) 2013-10-24 worksheet, PLAcct tab. | KFSI-6329 | ||||||||
| 2013.10.29 | 2013.10.05 | Chart of Accounts | MC chart is missing FUBL object code | We are experiencing the same issue again where MC-FUBL is missing (and this prevents me from testing CIP reclassification) and then I cannot create MC-FUBL because FUBL is used as a object level code. Please fix it ASAP. Thank you | KFSI-6089 | ||||||||
| 2013.10.29 | 2013.10.29 | General Ledger | Add EXEQ and UPEQ to DOCUMENT_TYPES parameter (SMS Feed) | We need to exclude elimination transactions from SMS feed. Please add EXEQ and UPEQ in the exclusion parameter. | KFSI-6352 | ||||||||
| 2013.10.29 | 2013.10.07 | Capital Asset Management | Missing values for Med Center - VALID_OBJECT_SUB_TYPES_BY_ACQUISITION_TYPE parameter | During testing of ARG, we noticed that we do not have sub-types for med center for asset retirement. For INT, I added EM for every type so I can go on but that cannot be correct. Please edit the parameter so that we can perform correct testing. This might mean creating more object codes that map to the correct sub-types. | KFSI-6047 | ||||||||
| 2013.10.29 | 2013.09.12 | Travel and Entertainment Module | Update Travel Advance Account Object Code in Customer Invoice Item | The Advance Account Information is stored in both Parameter and Customer Invoice Item on Item Code TRAVEL -Matching the parameter (TRAVEL_ADVANCE_PAYMENT_OBJECT_CODE) value of object code J234 to Customer Item Code- Attached in JIRA with newest document. (change in Advance Acct Clearing for TEM and PIADV) | KFSI-3477 | KFSI-3920, KFSI-3420, KFSI-4581 | |||||||
| 2013.10.29 | 2013.10.07 | Financial Processing | Correct ORIGIN_CODE parameter for General Error Correction | Victor, Which feeder system transactions are we actually not going to modify using GEC? We have several feeders listed in our parm. Is this the final list? It appears to me that we are not going to be correcting entries from Student Billing for the most part so are we requiring the users to correct the accounts, etc from the SBS? Also, how are we going to correct UCOP feed and Cost Share if they are posted incorrectly? Should we not be using GEC? MF is mainly the stuff for Plant Fund equipment elimination; CIP reclassification and KBM stuff -- so they should not be corrected manually, I'd think. Following is a current Origin Code that is restricted from being used by GEC SB: Student Billing PS: PPBS (don't know what this feeder is) SF: Student Billing FI (Financial Aid) SG: Student Billing GR (Grad Aid) UC: UCOP Feed CS Cost Share (KFS generated) MF Manual Feed (KFS generated) | KFSI-4109 | ||||||||
| 2013.10.29 | 2013.10.02 | Chart of Accounts | Create Gift object code and FBTC matrix entry for med center | While we were testing, we did not have an object code for GE sub-type for MC chart. I went ahead and created MC-9002 in INT to get around but I am not sure if that is the right one. Please create a correct one and deactivate this one as necessary. It also seems that we don't have the MC-GE in the capitalization fund matrix so we could not complete AA Thanks | KFSI-6038 | ||||||||
| 2013.10.29 | 2013.10.07 | Capital Asset Management | GLPE Indicator for Acquisition Types U, P, C, 2 should be N | We noticed that the GLPE indicator of the Acquisition Type Codes U, P, C, 2 are wrongly coded. As a result, GLPEs are generated for CAB AA document. Please change them to N. | KFSI-6106 | ||||||||
| 2013.10.29 | 2013.10.28 | Chart of Accounts | Add New Control Accounts for Medical Center for Plant | Add new Control Accounts for Medical Center. Updates are on Master MC COA Config Plant (Cynthia) 2013-10-24 worksheet, PLAcct tab. | KFSI-6330 | KFSI-6331 | |||||||
| 2013.10.28 | 2013.10.28 | Chart of Accounts | Request to add "CIP to object code descriptions for CP and MP object codes | It was suggested by Sam, Nathalie, Genevieve, Cynthia, and Wan that we add the word, CIP in front of the Object Code name for CIP object codes so that the word, CIP will show in the requisition accounting line when the plant administration folks are ordering services or goods for CIP. This will ensure that they have selected the correct object codes which do not get capitalized immediately (unlike equipment). Since we have so many CIP object codes, this will be very helpful in reducing errors. | KFSI-6171 | ||||||||
| 2013.10.28 | 2013.09.20 | Travel and Entertainment Module | Update TEM parameter TRAVEL_ADVANCE_PAYMENT_OBJECT_CODE | The Advance Account Information is stored in both Parameter and Customer Invoice Item on Item Code TRAVEL -Per document: A-1 UCI Business Processes\TEM\GL Entries\TEM T-Accounts 2013-06-07.xlsx- -The parameter - TRAVEL_ADVANCE_PAYMENT_OBJECT_CODE object code should be updated to J234- Newest document: A-1 UCI Business Processes\TEM\GL Entries\TEM T-Accounts 2013-09-12.xlsx The parameter - TRAVEL_ADVANCE_PAYMENT_OBJECT_CODE object code should be updated to M215 | KFSI-3920 | KFSI-3821, KFSI-3420, KFSI-3477 | |||||||
| 2013.10.25 | 2013.10.07 | Capital Asset Management | Update EFA100_EXCLUDE_ASSET_TYPES (Deny constraint) | Our parameter values is outdated -- it is currently saying F9999, F5555, F6666. They need to be changed to Z9999, Z5555, Z6666, Z3333 (see screnshot of "exception" asset types) | KFSI-6119 | ||||||||
| 2013.10.25 | 2013.10.03 | Chart of Accounts | Update Object Codes | Update object code changes from COA Master 2013.10.01 ObjCode worksheet. New object sub-type CF. Updates on ObjMapNew tab. | KFSI-6063 | ||||||||
| 2013.10.25 | 2013.10.10 | Chart of Accounts | Update Accounts | Update Account changes from COA Master 2013.10.01 Account worksheet. Update Fund Source Code on SFG tab. Update Account Type on AcctUpdates tab. | KFSI-6064 | ||||||||
| 2013.10.25 | 2013.10.01 | Chart of Accounts | Update Orgs | Update Org changes from COA Master 2013.10.01 Org worksheet. Add Orgs to crosswalk and new org on uciOrgMap tab. Changes highlighted in orange. | KFSI-6065 | ||||||||
| 2013.10.25 | 2013.10.17 | Chart of Accounts | Remove Campus Code and UC Account Type Code from UC Account Table | Remove Campus Code field and UC Account Type code from UC Account table. | KFSI-6067 | ||||||||
| 2013.10.24 | 2013.10.24 | Chart of Accounts | Update Object Codes | Please update object code changes on COA Master 2013.10.22 ObjCode config worksheet ObjMapNew tab. | KFSI-6324 | KFSI-6164 | |||||||
| 2013.10.22 | 2013.10.22 | General Ledger | Change the MD Balance Type Name and Set Offset Generation indicator to N | Instead of Medical Depreciation, please change the title to Medical Center Memo Document. The Offset Indicator for this balance type should be "N". Since we will be turning off all of the MD offsets, we no longer need to specifically add MCAP and MCIP into the OFFSET_GENERATION_DOCUMENT_TYPE parameter. | KFSI-6306 | KFSI-6153, KFSI-6260 | |||||||
| 2013.10.22 | 2013.10.22 | General Ledger | Add MCAP to OFFSET_GENERATION_DOCUMENT_TYPES | Please add MCAP to OFFSET_GENERATION_DOCUMENT_TYPES. MC does not need offsets. | KFSI-6260 | KFSI-6306 | |||||||
| 2013.10.22 | 2013.10.14 | General Ledger | Add MCIP to OFFSET_GENERATION_DOCUMENT_TYPES | We don't need to generate offsets to MCIP (MC CIP transactions in MD Balance Type). Please add the doc type to OFFSET_GENERATION_DOCUMENT_TYPES so that the transactions are not kicked out by scrubber. I already took care of this in INT. | KFSI-6153 | KFSI-6306 | |||||||
| 2013.10.22 | 2013.10.22 | Purchasing | Update CAB CHARTS_REQUIRING parameters to lift requirements of CAB fields in REQS and PO | Per decisions by Helen and Wan, please blank out the following parameters CHARTS_REQUIRING_ASSET_TYPE_ON_PURCHASE_ORDER CHARTS_REQUIRING_ASSET_TYPE_ON_REQUISITION CHARTS_REQUIRING_NOT_CURRENT_FISCAL_YEAR_ON_PURCHASE_ORDER CHARTS_REQUIRING_NOT_CURRENT_FISCAL_YEAR_ON_REQUISITION CHARTS_REQUIRING_COMMENTS_ON_PURCHASE_ORDER CHARTS_REQUIRING_COMMENTS_ON_REQUISITION | KFSI-6151 | ||||||||
| 2013.10.22 | 2013.10.22 | Chart of Accounts | Update Trans Codes for all charts | Sri, add new trans codes for UC Chart on ObjMapNew tab in COA Master 2013.10.18 ObjCode worksheet. Update reports to object code for IR and SW charts. Update historical object codes to equal reports to object code for all charts. Delete UC TCOD object code when all updates are completed. | KFSI-6243 | ||||||||
| 2013.10.22 | 2013.10.22 | Capital Asset Management | MOVABLE_EQUIPMENT_OBJECT_SUB_TYPES must include CE object sub-type | Helen is not able to process assets assigned to CE -- I know technically we should not have any capital assets < 5,000 but I think it will be safer to have this added so long as this object sub-type exists. | KFSI-6257 | KFSI-6247 | |||||||
| 2013.10.22 | 2013.10.22 | Chart of Accounts | Inactivate Mandatory Transfer Elimination Codes E and M | Campus will only use N-Neither, inactivate remaining codes. | KFSI-6273 | ||||||||
| 2013.10.22 | 2013.10.03 | Chart of Accounts | MC Control accounts should not have UC accounts loaded | We noticed that the control accounts have UC accounts filled in extended attributes. Please blank them out. | KFSI-6094 | ||||||||
| 2013.10.21 | 2013.10.21 | Purchasing | Make adjustments to PURAP reference tables per Heidi's review in ITC6 | Please see the linked test scenario from Heidi. She reports adjustments to the PURAP tables. | KFSI-4735 | KFSI-5234, KFSI-5906, KFSI-4555 | |||||||
| 2013.10.18 | 2013.10.18 | Unknown | Update UC Location Code on MC Object Codes | Update UC Location Code on MC Ojbect Codes to location 9. | KFSI-6240 | ||||||||
| 2013.10.18 | 2013.10.18 | Identify Management/Workflow | Electronic Inovice Processor role members are missing | We were missing role assignment to the Electronic Invoice Processor role. Please add appropriate people to this role. When the role members are missing, EIRT documents go straight to FINAL and won't give anyone an opportunity to fix ERIT. I put kamiller in INT for now. | KFSI-6103 | ||||||||
| 2013.10.17 | 2013.10.17 | Chart of Accounts | Update Budget Fund Code Values on UC Fund Table | Please update Budget Fund Code BDGT_FUND_CD on UC Fund Table in KFS from FS Fund Table, Permanent Budget field where Y=B and blank=N. | KFSI-6212 | ||||||||
| 2013.10.15 | 2013.10.08 | Financial Processing | KFSI-5830 MNT-13 Setup Fiscal Year Function Control Table | Setup Maintenance Document --> Setup Fiscal Year Function Control for CFG server the https://thea.adcom.uci.edu/kfs-cfg/portal.jsp | KFSI-5840 | ||||||||
| 2013.10.15 | 2013.10.15 | Capital Asset Management | Create acquisition code for non-movable (Z) and update VALID_OBJECT_SUB_TYPES_BY_ACQUISITION_TYPE parameter | During the CIP to Capitalization reclass process, we realized that we need an acquisition type specific to non-movable to process CAB via AA document. Helen, Sam, and Wan agreed that we will define Z-Non Movable Asset acquisition type. Accordingly, please update the VALID_OBJECT_SUB_TYPES_BY_ACQUISITION_TYPE parameter and amp all of the non-movable sub-type codes to Z. | KFSI-6169 | ||||||||
| 2013.10.15 | 2013.09.30 | Kuali Budget Module (KBM) | University Budget Manager role member is missing | The FY control maint documents failed due to missing members in University Budget Manager role (not to be confused with 36-University Admin Budget Manager). This resulted in the documents going into exception. To fix this issue, I added lllong to INT instance but I don't know who should be in this role for sure. Please update CFG database. This person will be approving maintenance documents for KBM including fiscal year budget control table. | KFSI-6028 | KFSI-6029 | |||||||
| 2013.10.14 | 2013.10.01 | Capital Asset Management | Finalize Asset Transaction Type Table | This table has baseline values. We need to add Object Code sub-types for Med Center and possibly other sub-types. Please update this in CFG. Medical Center will not be able to select Capital Edit tab unless their sub-type codes are listed. See the linked JIRA from Melissa. | KFSI-4275 | KFSI-4281, KFSI-4273 | |||||||
| 2013.10.14 | 2013.10.14 | Financial Processing | Add BA and BAT to ENABLE_FISCAL_PERIOD_DOC_TYPES parameter | We noticed that BA and BAT are not included in the ENABLE_FISCAL_PERIOD_DOC_TYPES parameter. Please add them | KFSI-6161 | ||||||||
| 2013.10.08 | 2013.10.08 | Kuali Budget Module (KBM) | Load KBM Salary Costing Funding Source Table in INT and BATMAN | Please load the UCI_LD_COST_ADJ_FUND_SRC_T table from KBM config sheet into INT and Batmanrobin The table is not final yet so we cannot load it in CFG yet (until Maria Lieggi has finalized the table) | KFSI-4068 | KFSI-3171, KFSI-5782, KFSI-3324 | |||||||
| 2013.10.08 | 2013.10.08 | Capital Asset Management | MOVABLE_EQUIPMENT_OBJECT_SUB_TYPES and NON_MOVABLE_EQUIPMENT_OBJECT_SUB_TYPES | AA Document errors out if we don't list all of the sub-type codes into one of the two parameters. We recently added new object codes for Found Equipment, etc. For example, we tried to use object code 9003, but the AA document returned an error saying it cannot determine if the asset is movable or non-movable. Please revise these parameters. | KFSI-6121 | ||||||||
| 2013.10.08 | 2013.10.08 | Purchasing | Content Reviewer needs to be collected in KIM config | The user testers are reporting that the REQS is not going to a content reviewer. However, I noted that this information is not collected in KIM Config. Please collect the information and ask Alvin to load the data. I have linked the issue. this role is not descending hierarchy, thus, the information has to be collected for each org who would like to have a Content Reviewer. | KFSI-1467 | KFSI-1322 | |||||||
| 2013.10.07 | 2013.10.07 | Update Equipment Review Object Codes Parameter | Only keep the following Parameter Value codes: 8005 8010 8032 8033 8085 8105 8110 8155 8160 8175 Please modify and remove the order codes. | KFSI-6061 | |||||||||
| 2013.10.04 | 2013.08.28 | Contracts & Grants | Reload ICR Rate Table -- when # is used Sub-Account must be dashes | Trini found out that you cannot use # in the sub-account field -- when you use @, you can put @ in the sub-account field, however. Please see the screenshots comparing how ours is and foundation's. This means we need to reload ICR Rate table to avoid validation errors | KFSI-4829 | ||||||||
| 2013.10.03 | 2013.10.03 | Identify Management/Workflow | Create a new role: Technical Support and grant Batch File permission | Create a new role: Technical Support to grant Batch File Lookup and View Detail permission -Requested to be added as nested roles to Technical Admin, Tech Operations and System Manager.- | KFSI-6085 | ||||||||
| 2013.10.02 | 2013.10.01 | Purchasing | Upload Purchasing Config Sheets when data doesn't match in CFG/CNV | The following Purchasing/Accounts Payable maintenance tables need to be uploaded from P:\Configuration Master Spreadsheets\PURAP\UCI PURAP Master (Purchasing) 2013-08-19 These 4 tables are ready to be uploaded into CFG & CNV (and the tabs are highlighted in red on the config spreadsheet): ItmTyp POStat POType ReqSrc | KFSI-5995 | KFSI-5906 | |||||||
| 2013.09.26 | 2013.09.26 | Unknown | Add/Edit Accounts to CFG Database | Use this JIRA to add/edit KFS accounts. | KFSI-5481 | KFSI-5295 | |||||||
| 2013.09.25 | 2013.09.25 | Chart of Accounts | Reload SFG Table, Missing Fund Source Code | Please reload SFG table from COA Master Account 2013.09.11 worksheet. Fund Source Code is missing. | KFSI-6006 | ||||||||
| 2013.09.24 | 2013.09.24 | Chart of Accounts | Update Account Restricted Status Code on KFS Account | On CA_Account_T change ACCT_RESTRC_STAT_CD values to U and R only, remove N and assign code from FS Fund Restricted/Unrestricted field. | KFSI-5483 | ||||||||
| 2013.09.23 | 2013.09.23 | Purchasing | PURAP - Extend the Item Type Description | Brenda and Victor, Item Type Description changes that were requested is really only a table description change (see attached). Brenda please let us know what you would like to say and it can be changed easily Y QTY/Y TX N QTY/Y TX N QTY/N TX Y QTY/ N TX | KFSI-5293 | ||||||||
| 2013.09.23 | 2013.09.23 | Capital Asset Management | Reload Equipment Elimination Object Code Matrix in CFG and CNV | Alvin, please reload equipment elimination object code matrix from GL Master 2013.09.19 worksheet. | KFSI-5979 | ||||||||
| 2013.09.23 | 2013.09.23 | Financial Processing | Reload Payment Reason Code Table and Ownership Type Table | Karen Miller updated these two tables in FP config. Please reload them. | KFSI-1592 | ||||||||
| 2013.09.23 | 2013.09.23 | Identify Management/Workflow | KFSI-4835 Load ORR Master config sheets | Load ORR Master Config sheet | KFSI-5466 | ||||||||
| 2013.09.23 | 2013.09.23 | Identify Management/Workflow | KFSI-4835 Load KIM Master config sheets | Load KIM Master Config sheet | KFSI-5465 | ||||||||
| 2013.09.23 | 2013.09.23 | Identify Management/Workflow | KFSI-4835 Load FO-AcctMgr-Supervisor KIM config sheets | Load FO-AcctMgr-Supervisor KIM Config sheet | KFSI-4860 | ||||||||
| 2013.09.23 | 2013.09.23 | Chart of Accounts | Create MC Donation Accounts and Object Codes | Donation Accounts and Object Codes: will be used as an offset to fixed asset when the AA document is used to book gifts (MD balance type) Please let me know as soon as they are created so I can put them into the spec. | KFSI-5438 | KFSI-1181 | |||||||
| 2013.09.23 | 2013.09.23 | General Ledger | Update MC_CAPITALIZATION_CLEARING_ACCOUNT_NBR and MC_CAPITALIZATION_CLEARING_OBJECT_CODE parameters | The capitalization process (scrubber) was modified to generate MD balance type for SMS feed. Please update the parameters in all instances before tonight. Currently the parameters are blank since we did not know what Cynthia was going to use. If we have capitalizable expenses and scrubber runs without the parameters, the process might fail. | KFSI-5437 | ||||||||
| 2013.09.19 | 2013.09.19 | General Ledger | KFSI-2729 Update STIP Distribution Rule Table | Have STIP Distribution Rule Table updated in CFG and INT database. | KFSI-2778 | ||||||||
| 2013.09.18 | 2013.09.18 | Unknown | Reload Offset Definition Table | Alvin, please reload offset definition table from GL Master config worksheet. | KFSI-5971 | ||||||||
| 2013.09.17 | 2013.09.17 | Travel and Entertainment Module | Update Object Codes (and Offsets) in Customer Invoice Item | The AR Customer Invoice Item Object Code and offset Information is stored within Customer Invoice Item. Per the attached excel document, the objects code for Customer Invoice Item is as follow PIADV Object Code: L412 PIADV AR Offset: J232 TEM ADV Object Code: M215 TRAVEL AR Offset: J234 | KFSI-4581 | KFSI-4559, KFSI-4720, KFSI-4140, KFSI-3420, KFSI-3477, KFSI-4672 | |||||||
| 2013.09.17 | 2013.09.17 | Chart of Accounts | Account ER00000 should be changed to BF10005 just like other suspense account (SFG 600000) | Per Maribeth, please correct ER00000 to BF10005. We have discussed previously that the suspense accounts should not start with ER any longer. See the screen shot. | KFSI-4645 | ||||||||
| 2013.09.13 | 2013.08.26 | Capital Asset Management | Set DEFAULT_GAIN_LOSS_DISPOSITION_ACCOUNT_NBR to 9429010 | For med center use, we need to set DEFAULT_GAIN_LOSS_DISPOSITION_ACCT_NBR parameter. This parameter is used when there is book value left in the asset which is being retired. | KFSI-5388 | KFSI-5254, KFSI-5926 | |||||||
| 2013.09.13 | 2013.08.02 | Pre-Disbursement Processor | Validate PDP Table | 2013 Entries are not in, CNV has Customer Profile ID 3000, sheet does not ACHPayeeAcct has 55177 items found in CNV, Config Sheet is blank | KFSI-4661 | KFSI-4563, KFSI-5242, KFSI-5914 | |||||||
| 2013.09.13 | 2013.08.12 | System | Update Parameter to allow larger batch file size (15Mb) | We ran into a problem with uploading pdp payment file when the file size has exceeded the limit. Please update the parameter: MAX_FILE_SIZE_DEFAULT_UPLOAD to 15M | KFSI-5274 | KFSI-5238, KFSI-59104859, KFSI-48595910, KFSI-5520 | |||||||
| 2013.09.13 | 2013.09.09 | System | Update Parameter ADDITIONAL_CHARGE_ITEM_TYPES for PO and PREQ | Several reported errors with PO and PREQ were related to calculateDiscount and the issue is due to ADDITIONAL_CHARGE_ITEM_TYPES missing value for DISC Please add "DISC" to the list of values in existing parameter ADDITIONAL_CHARGE_ITEM_TYPES for PREQ & CM only (in CFG) | KFSI-5398 | KFSI-5238, KFSI-5910, KFSI-3892, KFSI-3472, KFSI-5338, KFSI-53925910, KFSI-3892, KFSI-3472, KFSI-5338, KFSI-5392 | |||||||
| 2013.09.13 | 2013.08.26 | System | Update Parameter FOREIGN_CURRENCY_CONVERSION_URL for the updated page for Foreign Currency Conversion Rate | Please update the parameters FOREIGN_CURRENCY_CONVERSION_URL for the updated page for Foreign Currency Conversion Rate New value: http://www.oanda.com/currency/converter/ | KFSI-5357 | KFSI-5238, KFSI-5910, KFSI-4810 | |||||||
| 2013.09.13 | 2013.08.12 | System | Update TEM Parameter EMPLOYEE_CERTIFICATION_STATEMENT | Please update the parameter: EMPLOYEE_CERTIFICATION_STATEMENT Since this parameter contains html, I have attached a file for the value used for this parameter. | KFSI-5275 | KFSI-5238, KFSI-5910, KFSI-4757 | |||||||
| 2013.09.13 | 2013.08.22 | System | Update Parameter to change the default error account information for PCDO | Please update the parameters for the error transactions in PCDO ERROR_TRANSACTION_ACCOUNT_NUMBER - BF10002 | KFSI-5350 | KFSI-5849, KFSI-5238, KFSI-5847, KFSI-5850, KFSI-5910, KFSI-5174, KFSI-5175, KFSI-5177, KFSI-5178, KFSI-5846, KFSI-5330 | 2013.09.13 | 2013.08.26 | System | Update Parameter FOREIGN_CURRENCY_CONVERSION_URL for the updated page for Foreign Currency Conversion Rate | Please update the parameters FOREIGN_CURRENCY_CONVERSION_URL for the updated page for Foreign Currency Conversion Rate New value: http://www.oanda.com/currency/converter/ | KFSI-5357 | KFSI-5238, KFSI-5849, KFSI-5910, KFSI-5174, KFSI-5175, KFSI-5177, KFSI-48105178, KFSI-5846, KFSI-5847, KFSI-5850, KFSI-5330 |
| 2013.09.13 | 2013.08.26 | Financial Processing | FT Tables do not match CFG - Income Class, Payment Reason Code, and NRA Tax Pct | Victor Kevin reported that our CFG database is out of sync with the CONFIG sheet. Please analyze and correct. You might need to double check with Karen Miller to see which version is correct. | KFSI-3909 | KFSI-3820, KFSI-4558, KFSI-5237, KFSI-5909 | |||||||
| 2013.09.13 | 2013.07.03 | Travel and Entertainment Module | Missing Travel Expense Object Type codes (AF, LG) for ENT doc | This is a problem when performing import expenses (Corp Card or CTS) which could be of type AF (Airfare) or LG (Lodging). | KFSI-3288 | KFSI-3819, KFSI-4557, KFSI-5236, KFSI-5908, KFSI-4086 | |||||||
| 2013.09.13 | 2013.07.26 | Purchasing | PURAP Master (AP) Config Table | Threshold and e-InvItem do not match config sheet | KFSI-4659 | KFSI-4554, KFSI-5233, KFSI-5905) Config Table | Threshold and e-InvItem do not match config sheet | KFSI-4659 | KFSI-4554, KFSI-5233, KFSI-5905 | ||||
| 2013.09.13 | 2013.08.12 | General Ledger | Offset Object codes: there are offset object codes that are in CFG but not the config sheets | Offset object codes ENCS, ENEX, ENEX, and ENPR are in CFG and CNV when the Offset indicator is selected in the object code lookup. These object codes are not on the cofig sheet. I'm not sure if they should be removed from KFS or added to the config sheet, or if they should be on either as they don't look like they would be offset object codes. | KFSI-4650 | KFSI-4551, KFSI-5230, KFSI-5902 | |||||||
| 2013.09.13 | 2013.0807.12 | General Ledger | Offset Object codes: there are offset object codes that are in CFG but not the config sheets | Offset object codes ENCS, ENEX, ENEX, and ENPR are in CFG and CNV when the Offset indicator is selected in the object code lookup. These object codes are not on the cofig sheet. I'm not sure if they should be removed from KFS or added to the config sheet, or if they should be on either as they don't look like they would be offset object codes. | KFSI-4650 | KFSI-4551, KFSI-5230, KFSI-590224 | Chart of Accounts | Create an income object code for ICR (UC Account Number 803000) | CG needs a new ICR income object per our meeting yesterday (please ask Trini). We are going to use Provisional account 803000 ICR-Research (AGC 300155) for ICA offset object code. This FS account is not currently used by anyone. Please create this in INT so that the CG team can continue with testing. I'd suspect that this is a permanent decision and we should create one also in CFG. | KFSI-3986 | KFSI-4548, KFSI-3810, KFSI-4354, KFSI-5014, KFSI-5227, KFSI-5684, KFSI-5899, KFSI-2363, KFSI-3484 | ||
| 2013.09.13 | 2013.09.12 | Chart of Accounts | Resolve missing UC Account Numbers for Balance Sheet and Income Object Codes | We have a fair number of balance sheet and income object codes without UC account numbers. This will cause a problem in CFSBAL submission. I am attaching a list as of 6/29/2013. Please fix them as soon as possible. In particular, the recharge object code 3900 is a big question. It is currently defined as IC (Income but not cash) and there is no UC account number linked to it. The campus is instructed to use 3900 as Income on the income side of the IB document. Victor says 3900 should be expenditure. In that case, I do not believe you can use 3900 on the IB document's Receipt side. The campus will probably need to us DI document to move expenditures. In any case, this issue needs to be resolved ASAP. | KFSI-3985 | KFSI-4548, KFSI-3810, KFSI-5227, KFSI-5899 | 2013.09.13 | 2013.07.24 | Chart of Accounts | Create an income object code for ICR (UC Account Number 803000) | CG needs a new ICR income object per our meeting yesterday (please ask Trini). We are going to use Provisional account 803000 ICR-Research (AGC 300155) for ICA offset object code. This FS account is not currently used by anyone. Please create this in INT so that the CG team can continue with testing. I'd suspect that this is a permanent decision and we should create one also in CFGissue needs to be resolved ASAP. | KFSI-39863985 | KFSI-4548, KFSI-3810, KFSI-4354, KFSI-5014, KFSI-5227, KFSI-5684, KFSI-5899, KFSI-2363, KFSI-3484 |
| 2013.09.13 | 2013.08.06 | Purchasing | Set AUTOMATIC_PURCHASE_ORDER_DEFAULT_LIMIT_AMOUNT to 0 | Brant made a decision to set the APO limit to $0 when we go-live. As the departments get used Sciquest then he will gradually introduce departments to APO. At that time the Organization Parameter table will be set up to allow APO on an exception basis. | KFSI-4816 | KFSI-4576, KFSI-5209, KFSI-5881 | |||||||
| 2013.09.13 | 2013.08.26 | Unknown | Update Special Commodity Codes in CFG | Hi Victor, D&CS and Facilities already have special commodity codes for construction and consulting. They will also be using equipment and property leases. However, all campus property leases need to go through Pam Kubia (in the Budget Office, discussed at the Campus Asset Management meeting a few months ago). Therefore, 3 new special commodity codes are needed, on top of the ones already in CFG: DCS-EQUIP-LEASE (Description= Equipment Lease - Design & Construction Use ONLY) FM-EQUIP-LEASE (Description= Equipment Lease - Facilities Management Use ONLY) PROPERTY_LEASE (Description= Property Leases) Contract Manager= Pam Kubia Also, the COMMODITY_CODE_TO_PO_TYPE parameter needs to be updated to: SUBAWARD=S;PROPERTY_LEASE=J;DCS-EQUIP-LEASE=E;DCS-CONSTR=T;FM-CONSULT=F;FM-CONSTR=F;FM-EQUIP-LEASE=F;MC-PLANT=M | KFSI-5364 | KFSI-5876, KFSI-5204 | |||||||
| 2013.09.13 | 2013.08.02 | Identify Management/Workflow | Correct Org Reviewer's (Role 7) KIM Type that was incorrectly loaded | Kelly reported that the Org Reviewer route node is bypassed when creating sub-accounts. Her test case was creating a sub-account for IR-EP10021 (org IR-8278). A reviewer, bvarela is setup but the document never got there after FO approval. I tested with creating a sub-account for IR-OS11400 (org IR-8141). A reviewer, ceroode is setup and the document stopped at her node after FO approval. I determined this is a setup issue. bvarela does not have a review type setup correctly whereas ceroode is. Please see the screenshot comparison. Maybe we are missing a qualifier for the role 7? | KFSI-4679 | KFSI-5841, KFSI-5170, KFSI-4568 | |||||||
| 2013.09.13 | 2013.08.22 | Kuali Budget Module (KBM) | Load KBM BAC NAC Fund Balance Transaction Matrix Table | Depending on the creation of the maintenance table (KFSI-4081) The config sheet is in P drive KBM folder | KFSI-4082 | KFSI-40814066, KFSI-40664081, KFSI-4453, KFSI-5115, KFSI-5782, KFSI-3969 | |||||||
| 2013.09.13 | 2013.08.02 | Financial Processing | Assign someone to CG Exception Reviewer Role by ITC7 | Kelly reported that the document is going to exception since we do not have CG Exception Reviewer defined. As a temporary patch, I put rtangen in the INT server but we need to define who this person should be and load it into CFG. I will add this role to the KIM config sheet. Please update. | KFSI-4670 | KFSI-4418, KFSI-5078, KFSI-5747 | |||||||
| 2013.09.13 | 2013.09.06 | General Ledger | Create offset definitions for UPEX and EXEQ doc types | Due to missing offset definitions, elimination jobs (both CIP and equipment) are failing. Please create them. | KFSI-5447 | KFSI-57045035, KFSI-50355704 | |||||||
| 2013.09.13 | 2013.08.05 | Capital Asset Management | Plant Fund and Depreciation Accounts are not defined | Wan, please update the Plant Fund and Depreciation Accounts in all of your MC organizations. When the these plant funds are not defined, the CAM Documents cannot perform asset transfer between MC and IR. Please ask for Maribeth's assistance if you don't how to update Organizations in CFG. Where you should be updating the values should be CFG instance so that the data you will be entering will be copied over to all other instances for Integration Test Cycle 4. https://thea.adcom.uci.edu/kfs-cfg/portal.jsp See the screenshot of what you need to update | KFSI-2755 | KFSI-2199, KFSI-2979, KFSI-3658, KFSI-4363, KFSI-5023, KFSI-5693 | |||||||
| 2013.09.13 | 2013.08.02 | Capital Asset Management | Add CAM documents to CAPITALIZATION_DOCUMENT_TYPES parameter | We have discovered that we are double posting capitalization entries when the CAM document creates entries (especially AA documents). In the baseline, institutions use Income and Expense and let scrubber generates fixed asset and fund balance entries. At UCI, we do not hit Income and Expense in CAM and directly post entries to fixed asset and fund balance with transaction code. Therefore, we need to turn off capitalization entries from scrubber, using the baseline parameter. Add three doc types, AA;AT;ARG; to this parameter. See screenshot. | KFSI-4671 | KFSI-4361, KFSI-5021, KFSI-5691 | |||||||
| 2013.09.13 | 2013.07.23 | Contracts & Grants | Correct ICR Exclusion Table | Alvin Please see Trini's test scenario. She is pointing out a couple of load issues below: In INT, ICR object code exclusions type B is missing 5100 and 7100. And There is not ICR type "O" (3800, 3899). The excel spreadsheet includes these object codes and type O. | KFSI-4595 | KFSI-4358, KFSI-5018, KFSI-5688 | |||||||
| 2013.09.13 | 2013.09.10 | Accounts Payable | Populate the Holiday Table | Need to populate the holiday table for 2014 | KFSI-5377 | KFSI-4991, KFSI-5661, KFS-8 | |||||||
| 2013.09.13 | 2013.09.13 | Identify Management/Workflow | KFSI-4165 Re-load "all" of the KIM config sheets when test enviroments are refreshed | Please re-load "all" of the KIM config sheets when the test environments are refreshed | KFSI-4190 | ||||||||
| 2013.09.12 | 2013.08.07 | Accounts Receivable | There are no AR customers loaded for PI Cash Advance testing | There are no AR customers in CFG, which is critcial to load for PI Cash Advance Testing. The Cash Advance reason code only allows for AR customers to be selected, so some permanent AR entries (that frequently have Cash Advances) should be createdd and going into CFG. This would help with testing and will be required as part of the cutover. | KFSI-4655 | KFSI-5535, KFSI-4296, KFSI-4953 | |||||||
| 2013.09.12 | 2013.09.10 | System | KFSI-4547 Maintain Parameters in CFG - Parm Changes Identified in ITC | Ensure that changes since the previous Integration Test Cycle has been incorporated into CFG database before CFG database is copied to other instances. Use https://thea.adcom.uci.edu/kfs-cfg/portal.jsp | KFSI-4559 | KFSI-5534, KFSI-3821, KFSI-4295, KFSI-4952, KFSI-4647, KFSI-4581 | |||||||
| 2013.09.06 | 2013.09.06 | Chart of Accounts | Define Endowment Purpose Code and Endowment Restriction Codes | Found out that our Endowment Purpose Code and Endowment Restriction Code tables are empty. Please have someone define them in CFG sheet and reassign this JIRA to Alvin so he can load (I also found out that the update screen is not available so I need to get that fixed). The config sheet is on the P drive --> Config --> COA --> UCOP attributes | KFSI-3298 | KFSI-4064 | |||||||
| 2013.09.06 | 2013.09.06 | Chart of Accounts | Populate Endowment Purpose and Restriction Code Table | Endowment Purpose Table (attribute of UC_FUND_T) is empty. Please populate it after Maribeth completes the spreadsheet (KFSI-3298) | KFSI-4064 | KFSI-3298 | |||||||
| 2013.09.06 | 2013.09.06 | General Ledger | Analyze if we should use FB as an encumbrance offset - The Open Encumbrance screen is designed to ignore Fund Balance - having Encumbrance offset object code set up as a Liability displays the Liability on this screen. | Normally encumbrances are not considered liabilities because we don't truly have a binding contract/liability to an external entity. KFS expects that encumbrances will offset to Fund Balance and screens are designed with that in mind. Because encumbrance offsets are using a liability object code the other side of the encumbrance is showing up on the Open Encumbrance screen and it might be confusing to users when they are trying to figure out what is encumbered on their accounts. | KFSI-3967 | KFSI-3407 | |||||||
| 2013.09.05 | 2013.09.05 | Unknown | Update Asset Elimination Batch Capital Parameter | Add SFGT PN and PF to parameter value. | KFSI-5439 | ||||||||
| 2013.08.29 | 2013.08.29 | Unknown | KFSI-4020 Ingest the new workflow document (BAC) | KFSI-5405 | |||||||||
| 2013.08.26 | 2013.08.26 | Chart of Accounts | Correct missing higher education function code | I discovered that there are many accounts with "NA" higher education function codes. In looking at these accounts I am wondering if they were created by the update program since the initial conversion of the accounts. Not having correct HEFC impacts the equipment elimination process for current funds since we rely on HEFC to assign elimination accounts. SQL used to discover missing accounts are: select u.uas_cd, e.uc_acct_nbr, e.uc_fund_nbr, a.fin_coa_cd, a.account_nbr, a.fin_hgh_ed_func_cd from ca_account_t a, ca_account_ext_t e, uc_account_t u where a.fin_coa_cd = e.fin_coa_cd and a.account_nbr = e.account_nbr and e.uc_acct_nbr = u.uc_acct_nbr and fin_hgh_ed_func_cd = 'NA' and a.account_nbr not like 'UC%' and a.account_nbr not like '9%' and substr(u.uc_acct_nbr,1,1) >= '3' order by uas_cd; HEFC should be assigned based on UAS (uniform accounting structure) code to HEFC mapping table. UAS is an attribute of the UC account number. Please fix. | KFSI-4643 | ||||||||
| 2013.08.26 | 2013.08.26 | Accounts Payable | DV Payment Reason Code Error G -Utilities, Freight or Postage | Error message from when creating DV for payment reason code G - Utilities, Freight or Postage (see attached) | KFSI-5339 | ||||||||
| 2013.08.26 | 2013.08.26 | System | Remove 'One System' and 'Multiple Systems' options from the Capital Asset tab in REQS | Helen has requested that we remove the 'One System' and 'Multiple Systems' options from the Capital Asset tab in REQS. She and her team will no longer be using these two options and would like them removed to avoid any confusion. The system type menu is controlled through the 'Capital Asset System Type' maintenance table under 'Purchasing/Accounts Payable'. Please update it such that these two options are deactivated. | KFSI-5351 | KFSI-3860 | |||||||
| 2013.08.22 | 2013.08.22 | Capital Asset Management | Define VALID_OBJECT_SUB_TYPES_BY_ACQUISITION_TYPE parameter | As discussed, please define correct VALID_OBJECT_SUB_TYPES_BY_ACQUISITION_TYPE parameter values to work with Add Asset Global. I noticed that Med Center does not have Gift object codes. I am not sure that you want to create a gift object code for Med Center or you'll let them use EM sub-type code. For now, I put EM everywhere in INT so that testing can continue but we really need to clean this parameter up for real. | KFSI-4695 | ||||||||
| 2013.08.22 | 2013.08.22 | General Ledger | GOE Rules | Please load GOE tables from GL Master worksheet in INT. SQL will need to be updated, columns were inserted in worksheet. Delete old data before loading. | KFSI-5289 | KFSI-5332 | |||||||
| 2013.08.19 | 2013.08.19 | Chart of Accounts | Resolve Duplicate Account/Fund in Fiscal Officer XW config sheet | There are some account funds that are specified multiple times in the XW config sheet. Please see the following account/fund=401503/56450 exists more than once in the XW account/fund=401510/66234 exists more than once in the XW account/fund=401555/56450 exists more than once in the XW account/fund=401555/56970 exists more than once in the XW account/fund=401569/56450 exists more than once in the XW account/fund=401600/56970 exists more than once in the XW account/fund=401603/56970 exists more than once in the XW account/fund=401608/56970 exists more than once in the XW account/fund=401610/56970 exists more than once in the XW account/fund=401619/56970 exists more than once in the XW account/fund=401620/56970 exists more than once in the XW account/fund=401625/56970 exists more than once in the XW account/fund=401657/56450 exists more than once in the XW account/fund=401658/56450 exists more than once in the XW account/fund=402503/05397 exists more than once in the XW account/fund=400910/62937 exists more than once in the XW account/fund=405143/19900 exists more than once in the XW account/fund=405368/56043 exists more than once in the XW account/fund=405368/56318 exists more than once in the XW account/fund=405368/60182 exists more than once in the XW account/fund=405368/60240 exists more than once in the XW account/fund=442525/41397 exists more than once in the XW account/fund=442525/48710 exists more than once in the XW account/fund=445120/19933 exists more than once in the XW account/fund=445120/56076 exists more than once in the XW account/fund=445120/66251 exists more than once in the XW account/fund=445043/29404 exists more than once in the XW account/fund=445043/29491 exists more than once in the XW account/fund=445043/45906 exists more than once in the XW account/fund=445043/53780 exists more than once in the XW account/fund=445043/54055 exists more than once in the XW account/fund=445043/56306 exists more than once in the XW account/fund=445043/56309 exists more than once in the XW account/fund=445043/56772 exists more than once in the XW account/fund=445043/56893 exists more than once in the XW account/fund=445043/60118 exists more than once in the XW account/fund=445043/66198 exists more than once in the XW account/fund=445043/68311 exists more than once in the XW account/fund=445044/56772 exists more than once in the XW account/fund=431537/56450 exists more than once in the XW account/fund=431575/56450 exists more than once in the XW account/fund=431575/66234 exists more than once in the XW account/fund=440850/56076 exists more than once in the XW account/fund=440853/18011 exists more than once in the XW account/fund=445984/36299 exists more than once in the XW account/fund=445710/29459 exists more than once in the XW account/fund=445743/56772 exists more than once in the XW account/fund=445744/56772 exists more than once in the XW account/fund=445220/19900 exists more than once in the XW account/fund=445221/23492 exists more than once in the XW account/fund=445544/45906 exists more than once in the XW account/fund=445544/56772 exists more than once in the XW account/fund=445643/56772 exists more than once in the XW account/fund=445644/56772 exists more than once in the XW account/fund=445343/45906 exists more than once in the XW account/fund=445343/56306 exists more than once in the XW account/fund=445343/56772 exists more than once in the XW account/fund=445135/41407 exists more than once in the XW account/fund=485210/78113 exists more than once in the XW account/fund=485043/59800 exists more than once in the XW account/fund=485043/78910 exists more than once in the XW account/fund=485110/78113 exists more than once in the XW account/fund=481615/78987 exists more than once in the XW account/fund=481630/18508 exists more than once in the XW account/fund=482521/78510 exists more than once in the XW account/fund=482540/59503 exists more than once in the XW account/fund=482540/59706 exists more than once in the XW account/fund=485875/78806 exists more than once in the XW account/fund=608015/56450 exists more than once in the XW account/fund=771517/56450 exists more than once in the XW account/fund=445043/40004 exists more than once in the XW account/fund=401557/56450 exists more than once in the XW account/fund=771515/56450 exists more than once in the XW account/fund=445043/40015 exists more than once in the XW | KFSI-4666 | KFSI-4654 | |||||||
| 2013.08.15 | 2013.08.15 | Chart of Accounts | KFSI-4835 Load GOE Rule Table | KFSI-4854 | |||||||||
| 2013.08.14 | 2013.08.14 | Chart of Accounts | KFSI-3495 Load GOE Rule Table | KFSI-3514 | |||||||||
| 2013.08.14 | 2013.08.14 | Chart of Accounts | KFSI-4165 Load GOE Rule Table | KFSI-4184 | |||||||||
| 2013.08.14 | 2013.08.14 | Chart of Accounts | MC plant fund accounts have incorrect account type | I discovered that MC plant fund accounts (MC-9xxxxxx) have an account type of "UN". They should be "PL" just like the IR plant fund accounts. Account type is used to determine whether the account number should be auto assigned, thus, it is important that the value is assigned correctly. | KFSI-4644 | ||||||||
| 2013.08.13 | 2013.08.13 | Financial Processing | GEC - Finalize Parameter Configuration to restrict Liabilities, CAM transactions, etc. | From Kymber: Looked up doc 17248 Expenses and Liability are selectable -it seems like using the GEC to move Liabilities may not be a good idea - since the liability may no longer truly exist on the account. Maribeth, per our conversation, please review all of our GEC parameters and restrict transactions | KFSI-4818 | ||||||||
| 2013.08.13 | 2013.08.13 | Purchasing | Modify the PURAP eInvoice processing scheduled job to include creditMemo | Per updated spec on KFSI-685 FS-PUR-020 Create e-Credit Memo process and reject document We have now separate jobs for processing eInvoice and e-Credit Memo. Please schedule the e-Credit Memo job to run after electronic invoice. The schedule sequence should be 1. electronicInvoiceClassificationJob 2. electronicInvoiceExtractJob 3. creditMemoExtractJob | KFSI-5280 | KFSI-5260 | |||||||
| 2013.08.12 | 2013.08.06 | System | Update TEM Parameters to match System Configs (delete testing data) | Hi Victor, Several things in CFG don't match the configs (and a few things in the config needed to be updated). Could you please update the following 10 TEM parameters in CFG?: TRAVEL_DV_CLEARING_OBJECT_CODE = L328 TRAVEL_DV_CLEARING_ACCOUNT_NBR = UC18888 CTS_AIR_OBJECT_CODE = 8350 CTS_LODGING_OBJECT_CODE = 8350 CTS_RENTAL_CAR_OBJECT_CODE = 8350 EXPENSE_TYPE_FOR_RENTAL_CAR = AR EXPENSE_TYPES_FOR_INCIDENTAL = IC TEM_FAX_NUMBER = (949) 824-2098 TEM_EMAIL_SENDER = accounts-payable@uci.edu TRANSPORTATION_TYPE_CODES = RV;SH;TM;MI;TX;AF;BS;CT The old values were input into the system so it would not break, but they were never correct. | KFSI-4647 | KFSI-4559 | |||||||
| 2013.08.09 | 2013.08.09 | General Ledger | CONTINUATION_ACCOUNT_BYPASS_ORIGINATIONS should include 01 | Kelly reported that the continuation account override is not working. This is because of our misconfiguration of the CONTINUATION_ACCOUNT_BYPASS_ORIGINATIONS parameter. We need to include 01 (KFS). Currently it only has FS, which is incorrect. Also CONTINUATION_ACCOUNT_BYPASS_DOCUMENT_TYPES has PRE misspelled. It should be PREQ. | KFSI-5261 | KFSI-5258 | |||||||
| 2013.08.08 | 2013.08.08 | Kuali Budget Module (KBM) | Load KBM Med Comp Crosswalk data | Load into CNV and for ITC6 load into BAT and INT. Ask Maria for spreadsheet details. | KFSI-4637 | KFSI-4750, KFSI-4635 | |||||||
| 2013.08.05 | 2013.07.01 | Purchasing | Fix SPECIAL_PURCHASE_ORDER_TYPE_CODE for Facilities | Facilities has settled on their Purchase Order Type of F. Requested to put it into CFG SPECIAL_PURCHASE_ORDER_TYPE_CODE: S;J;T;F | KFSI-3992 | KFSI-3821, KFSI-4594 | |||||||
| 2013.08.05 | 2013.07.29 | Accounts Receivable | Setup Offset Object Code in the AR Invoice Item Code table | For PI Invoice and TEM, we need to setup AR offset object codes for invoice item. PIADV...offset will be J232 TEM...offset will be J234 See the attached spreadsheet. | KFSI-4672 | KFSI-4581 | |||||||
| 2013.08.05 | 2013.08.05 | Purchasing | Correct Commodity Code | INT - Correct FM-CONSTR - Construction Contract - DCS Use Only to Construction Contract - Facilities Use Only CFG - FM-CONSTR is not listed at all | KFSI-4805 | ||||||||
| 2013.08.05 | 2013.08.05 | Purchasing | Inactivate Multiple Systems option in the Capital Asset System Type | Purchasing (Heidi/Helen) has decided that they are not going to allow users to select Multiple Systems since that option will not collect detailed information about the asset being purchased (see the comment posted in KFSI-4494). Please inactivate the code MUL (multiple systems). Maintenane --> Purchasing --> Capital Asset System Type | KFSI-4752 | ||||||||
| 2013.08.03 | 2013.08.02 | General Ledger | Add ACHD to GL_ENTRY_INQUIRY_URL_EXCLUDE_DOC_TYPES | To avoid stuck trace when doc number is clicked, add ACHD to the GL_ENTRY_INQUIRY_URL_EXCLUDE_DOC_TYPES parameter. I have already tested this in INT | KFSI-4800 | ||||||||
| 2013.08.02 | 2013.08.01 | Chart of Accounts | Change the encumbrance offset object code type to FB from LI | In testing we discovered that encumbrance offsets generated by scrubberJob are rejected by posterJob. This includes monthly encumbrances from FS (EX) and Facilities encumbrances (IE). Warren investigated the code and posterJob has a special logic to assume encumbrance offset to be FB (and not reject the encumbrance offsets). Nobody in the community is using LI as an encumbrance offset. We should change the LI to FB on all of the encumbrance offset object codes, ENPR, ENEX | KFSI-4780 | KFSI-4771 | |||||||
| 2013.08.02 | 2013.08.02 | Capital Asset Management | Reload new custodial code table (after asset rep field is added) | The functional team has determined that the asset representative will be determined by the custodial code. They have also reviewed all of the EQS custodial codes and cleaned up the tables. Please reload the custodial code table. This will perhaps need to be done in two steps since the users are waiting for the new custodial code table for testing, however, the default custodial code field is not yet available (please coordinate this with Bhargav). I have already revised the custodial code config sheet (CAM) and added the default asset representative information. | KFSI-4047 | KFSI-4034 | |||||||
| 2013.08.01 | 01/Aug/13 8:41 AM | Unknown | Insert new CCCS Program codes for HSG in OSCAR CCCS LOV's | --INSERT INTO tbl_lov_cccs_departments VALUES ('5030','STUDENT HSG') --INSERT INTO tbl_lov_cccs_programs VALUES ('680','Housing Undergraduate Applications','5030') --INSERT INTO tbl_lov_cccs_programs VALUES ('681','Housing Undergrad Reservation Fee','5030') --INSERT INTO tbl_lov_cccs_programs VALUES ('682','Housing Graduate Applications','5030') | KFSI-4776 | ||||||||
| 2013.08.01 | 2013.08.01 | Unknown | KFSI-4776 Validate inserted records exist and are correct. | KFSI-4777 | |||||||||
| 2013.07.24 | 2013.07.24 | Chart of Accounts | Update RECEIPT_OBJECT_CODE parameter for ICA Document | ITC6 - Verify the ICA document receipt object code is loaded correctly L437. | KFSI-4602 | ||||||||
| 2013.07.24 | 2013.07.24 | Chart of Accounts | COA - Expenditure Object Code Updates between 10/1/2012 ~ 04/11/13 | To Record all the New Expenditure Object Codes in KFS since 10/01/12 and to maintain the updates/changes | KFSI-1705 | ||||||||
| 2013.07.24 | 2013.07.24 | Chart of Accounts | COA - Balance sheet Accounts (MC-L217 and MC-L328 Changes) | To Record all the New Balance Sheet in KFS since 06/01/12 and to maintain the updates/changes | KFSI-1480 | ||||||||
| 2013.07.23 | 2013.07.23 | General Ledger | Define Accounting Periods to align with the UCI Accounting Periods | Our accounting periods do not have correct ending dates. As per our decision, the accounting period should close on the fifth working day for each month. The accounting period tab is in the GL config sheet. Please update and ask Alvin to load. | KFSI-4276 | ||||||||
| 2013.07.19 | 2013.07.12 | Capital Asset Management | Update ENABLE_VENDOR_PAYMENT_BEFORE_FINAL_TR_APPROVAL_IND | ENABLE_VENDOR_PAYMENT_BEFORE_FINAL_TR_APPROVAL_IND should be set to N | KFSI-4030 | KFSI-3821, KFSI-3998, KFSI-4001 | |||||||
| 2013.07.19 | 2013.07.01 | Capital Asset Management | Add software object sub-type to MOVEABLE_EQUIPMENT_OBJECT_SUB_TYPES | Add SM;FM to MOVABLE_EQUIPMENT_OBJECT_SUB_TYPES parameter. | KFSI-3994 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.07.01 | Purchasing | Update COMMODITY_CODE_TO_PO_TYPE for Facilities | COMMODITY_CODE_TO_PO_TYPE: SUBAWARD=S;PROPERTY_LEASE=J;CONSTRUCTION=T;FM-CONSUL=F;FM-CONST=F | KFSI-3993 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.07.12 | Travel and Entertainment Module | ENCUMBRANCE_OPEN_AMOUNT_OVERRIDING_DOCUMENT_TYPES should include TEM doc types | ENCUMBRANCE_OPEN_AMOUNT_OVERRIDING_DOCUMENT_TYPES should include TA;TAA;TAC in all instances. See KFSI-3407 | KFSI-3990 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.07.01 | Purchasing | DEFAULT_METHOD_OF_PO_TRANSMISSION should be set to MNL | Per KFSI-892, DEFAULT_METHOD_OF_PO_TRANSMISSION should be set to MNL to implement Sciquest | KFSI-3989 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.07.12 | Capital Asset Management | Fix incorrect DEFAULT_GAIN_LOSS_DISPOSITION_OBJECT_CODE parameter | DEFAULT_GAIN_LOSS_DISPOSITION_OBJECT_CODE should be set to 7472 Currently it is set to 9000, which is a non-existent object code for MC DEFAULT_GAIN_LOSS_DISPOSITION_OBJECT_CODE is used by ARG when there is a book value left on asset (Base - accumulated depreciation). Campus does not depreciate assets, thus Med Center will be the only one that will encounter the use of this parameter. | KFSI-3987 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.06.29 | Purchasing | Add DISC to ADDITIONAL_CHARGES_ITEM_CODES | DISC Item Codes should be added to the ADDITIONAL_CHARGES_ITEM_CODES for Requisition, Payment Request, Purchase Order and Credit Memo (total of four parameters). When DISC is missing, the e-invoice document does not get loaded. See the attached screenshot. INT has already been changed as part of the bug fix. | KFSI-3988 | KFSI-3821 | |||||||
| 2013.07.19 | 2013.07.19 | Chart of Accounts | Correct OFT indicator from F to O for the following object codes on MC chart 9992 thru 9999 | Corrected OFT indicator from F to O for the following object codes. MC 9992 MC 9995 MC 9997 MC 9998 MC 9999 | KFSI-4141 | ||||||||
| 2013.07.17 | 2013.07.17 | Identify Management/Workflow | KFSI-3495 Re-load "all" of the KIM config sheets when test enviroments are refreshed | Please re-load "all" of the KIM config sheets when the test environments are refreshed | KFSI-4114 | ||||||||
| 2013.07.17 | 2013.07.15 | Identify Management/Workflow | Purchasing Manager is repeated several times in PDP Customer Role | Noticed that PDP Customer role has the same Purchasing Manager repeated several times. | KFSI-4106 | ||||||||
| 2013.07.17 | 2013.07.15 | Contracts & Grants | Agency Table in CFG database is bogus -- need to load up from KC | Per KFSI-2367, we are currently loading agency table from KC so that our tables are in sync to maintain UCOP sponsor codes. At the same time this table is referenced by CAM to track asset ownership so we need to keep several additional codes: G GOVERNMENT OWNED ASSET 1 S STATE OWNED ASSET 2 U UNIVERSITY OWNED ASSET 14 P PRIVATELY OWNED ASSET 4 O OTHER OWNED ASSET 99 I need to come up with a way to load KC agency without overriding the above. | KFSI-4115 | KFSI-2367 | |||||||
| 2013.07.16 | 2013.07.16 | Capital Asset Builder | Create a New Acquisition Type Code for Construction Projecs | Acquisition Code: X Name: CIP Capitalization/Elimination Income Object Code: blank GLPE indicator: N CAB Indicator: Y | KFSI-4131 | ||||||||
| 2013.07.16 | 2013.07.16 | General Ledger | Change the value of BALANCE_TYPE parameter for SMS feed to include MD | Component: SMS Parameter Name: BALANCE_TYPE Currently it is set to AC, it should be set to AC;MD We need to send depreciation (MD balance type) transactions to Med Center SMS | KFSI-4146 | ||||||||
| 2013.07.16 | 2013.07.16 | Unknown | KFSI-4020 Ingest the new workflow document (MACTCM) | KFSI-4139 | |||||||||
| 2013.07.12 | 2013.07.12 | Chart of Accounts | Create CHKS and CHKL doc type and offsets before Cycle 3 | CHKS (Stop) and CHKL (Stale) doc types are needed for Check Recon. Please create the doc type and then offsets. Offset should be CAOF. | KFSI-2415 | KFSI-2352 | |||||||
| 2013.07.12 | 2013.07.12 | Chart of Accounts | Correct Object Sub-Type Code for 9303 | Per Maribeth We need 9303 for mapping to and from the P-sub P3 for the converted data and the feeders. However, the object sub-type should be CM. At the time we created it, we did not know whether or not equipment from a Plant project would be capitalized right away. It was decided that it should be. | KFSI-4003 | ||||||||
| 2013.07.12 | 2013.07.12 | Chart of Accounts | The Blanket (B) Type on the PO Needs to be removed | Please remove the Blanket (B) type on the PO on all environments | KFSI-4038 | ||||||||
| 2013.07.12 | 2013.07.12 | Identify Management/Workflow | Create a group for MC Facilities | Similar to Facilities, Med Center Facilities would like to have a group called MCPAC to include the following individuals Nathalie Anaya Tracy Yi Wan Tung Alice Lui The group will be used for ad hoc routing | KFSI-4099 | ||||||||
| 2013.07.12 | 2013.07.12 | Accounts Payable | Update 1099_VENDOR_OWNER_CODES | Current configuration is missing ID (independent contractor) 1099_VENDOR_OWNER_CODES CP;ID Victor, would you double check the values with Karen Miller and/or Tanya Harris before finalizing? I don't know that this is the comprehensive list. | KFSI-4103 | ||||||||
| 2013.07.12 | 2013.07.12 | Chart of Accounts | Inactivate ES and CH Object Type Codes | UCI will not be using ES and CH object types. We should disable them so that we do not accidentally create object codes mapping to these | KFSI-4092 | ||||||||
| 2013.07.11 | 2013.07.11 | Accounts Payable | Update 1099_OBJECT_CODES needs a default value of Box 7 | 1099_OBJECT_CODES needs the default value at the end in order for the system not to crash (*=7). However this value list needs to be verified. When I spoke with Tanya and Karen last time, this list was not final. 4000=1;4050=2;5000-5100=3;5500=4;6000=5;6100=6;6500=7;7000=8;8000=A;8100=B;8200=C;9000=D;9100=E;*=7 | KFSI-4104 | KFSI-4063 | |||||||
| 2013.07.10 | 2013.07.10 | Pre-Disbursement Processor | Change the value of DISBURSEMENT_CANCELLATION_DAYS to 999999999 (9 digits) | It was discovered that the max number for this parameter is 9 digits. Currently we have 10 digits entered into this parm to disable the baseline Stale Date feature (since UCI has its own stale check process). Change the value from 10 digits to 9 digits so that the PDP search for payments will not break. | KFSI-4091 | KFSI-4053 | |||||||
| 2013.07.10 | 2013.07.10 | Financial Processing | Change the constraint code from D to A for NON_TAXABLE_OBJECT_CODES (PCDO) | Bad constraint code of D has caused an issue. Change the constraint code from D to A per Warren | KFSI-4090 | KFSI-4087 | |||||||
| 2013.07.09 | 2013.07.09 | Capital Asset Management | Create a new Depreciation Method - Full Month in CFG | UCI Med Center needs a new Depreciation Method called Full Month. The values should be Code: FM Name: Full Month Please add this to the maintenance menu --> Asset Depreciation Method | KFSI-4070 | KFSI-2673 | |||||||
| 2013.07.08 | 2013.07.01 | Financial Processing | DV - Unable to add Foreign (Federal) Tax Rate | Please use the Incident Report form below to report the problems This information will be forwarded to our support team. Please describe what action you were taking when the problem occurred Document Id 50840 Error Message The system has encountered an error and is unable to complete your request at this time. Please provide more information regarding this error by completing this Incident Report. User Input ******************Stack Trace-Only shown when not in production***************** java.lang.RuntimeException: Unable to retrieve federal tax parameters. at edu.uci.kfs.fp.document.service.impl.UciDisbursementVoucherTaxServiceImpl.generateNRAPercentageTaxLines(UciDisbursementVoucherTaxServiceImpl.java:143) at edu.uci.kfs.fp.document.service.impl.UciDisbursementVoucherTaxServiceImpl.generateNRATaxLines(UciDisbursementVoucherTaxServiceImpl.java:83) at org.kuali.kfs.fp.document.service.impl.DisbursementVoucherTaxServiceImpl.processNonResidentAlienTax(DisbursementVoucherTaxServiceImpl.java:291) at org.kuali.kfs.fp.document.web.struts.DisbursementVoucherAction.generateNonResidentAlienTaxLines(DisbursementVoucherAction.java:403) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:172) at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:123) at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:118) at org.kuali.kfs.sys.web.struts.KualiAccountingDocumentActionBase.execute(KualiAccountingDocumentActionBase.java:110) at org.kuali.kfs.fp.document.web.struts.DisbursementVoucherAction.execute(DisbursementVoucherAction.java:84) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:503) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:499) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:101) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at edu.uci.oit.rice.kns.web.filter.UCIWebAuthFilter.doFilter(UCIWebAuthFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at edu.uci.oit.rice.kns.web.filter.UCIWebAuthFilter.doFilter(UCIWebAuthFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.SetResponseBufferSizeFilter.doFilter(SetResponseBufferSizeFilter.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.kuali.rice.kns.web.filter.SessionFilter.doFilter(SessionFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:403) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1703) at java.lang.Thread.run(Thread.java:662) | KFSI-1562 | ||||||||
| 2013.07.03 | 2013.07.03 | Travel and Entertainment Module | Remove TEM document options to "Pay DV to Vendor" | We will be paying Vendor through the TEM document directly (choose the vendor payee) Remove the option for Pay DV to Vendor. | KFSI-4001 | KFSI-4030 | |||||||
| 2013.07.02 | 2013.06.29 | Financial Processing | Verify we have correct people in the Treasury Managers and AD User roles | Treasury Managers and AD users can only change the Bank Code drop-down menu on AD and ND documents. Would you make sure that all of the identified AD and ND users are either in AD users role or Treasury role? | KFSI-1463 | ||||||||
| 2013.06.29 | 2013.06.29 | Chart of Accounts | KFSI-1705 Correct Spelling on Object code 8011 "CLOTHING" | Spelling Correction Object Code 8000 Description "Clothing" 2-12-2013 (Should be object code 8011) | KFSI-1710 | ||||||||
| 2013.06.29 | 2013.06.29 | System | Identify role members of the UCI specific roles | Caryn I added the UCI specific users to the KIM config sheet. Please update them. Thanks. | KFSI-1462 | ||||||||
| 2013.06.29 | 2013.06.29 | Financial Processing | Define Documentation Location Code | We only have one documentation location code "01". This is a baseline default location code. What is UCI's documentation location code? Documentation location code is where the backup documentation should be sent. Should we just rename that to "DDM"? Do you have any other documentation location codes that you wish to have? | KFSI-1472 | ||||||||
| 2013.06.29 | 2013.06.29 | Travel and Entertainment Module | Update TEM AR configurations to use the updated Sys Information, Org Option, Custom Invoice item | The updated AR configurations for System information, Org Option and Customer Invoice Item is ready in INT. When AR's config spreadsheet is updated, we will update the conversion loading script and TEM parameter setup to use the new AR's billing org code. | KFSI-1908 | ||||||||
| 2013.06.29 | 2013.05.10 | Travel and Entertainment Module | Update TEM parameter ALWAYS_REIMBURSABLE_CARD_TYPE | Please update the TEM parameter ALWAYS_REIMBURSABLE_CARD_TYPE value to CTS All CTS (APL-eCard) expenses are always reimbursable | KFSI-3287 | ||||||||
| 2013.06.29 | 2013.03.04 | Accounts Payable | Load 1099 Payer table | Alvin 1099 Payer table (Payer is UCI) is empty. Please create a config sheet (tab) in PURAP-AP and ask Karen Miller to complete it. We need to load it for us to run 1099. You might check with Elana if she stored the data somewhere else. I cannot remember... | KFSI-1490 | ||||||||
| 2013.06.29 | 2013.02.27 | Accounts Receivable | Please reload AR Confg | Please reload everything from AR config based on the log, does not appear to be loaded. We need them for TEM and DV testing in INT to complete my test scenarios. | KFSI-2007 | ||||||||
| 2013.06.29 | 2013.02.21 | General Ledger | Load STIP Table | Please load STIP Rule table (GL Config) into cfg, cnf, and int before tomorrow's nightly processing. STIP job will be run on Friday and we will need this rule table for STIP to work | KFSI-1878 | ||||||||
| 2013.06.29 | 2013.02.07 | Chart of Accounts | Reload Object Type -- the object name column is repeating the object type code | The object type name is incorrectly repeating the object type code -- please reload. See screenshot | KFSI-1577 | ||||||||
| 2013.06.29 | 2013.03.04 | Capital Asset Management | Reload asset types | Expanded asset descr from 70 to 100 per helen to fit full ucop asset description -- previously truncated to 70 please reload asset type from config | KFSI-1914 | 2013.06.29 | 2013.02.07 | System | Add Parameter Type "RUN" in the CONFIG load | We will be isolating parameter type "RUN" for run time parameters. Please add this entry into the KRSN_PARM_TYP_T (I added one to test manually) | KFSI-1578 | ||
| 2013.06.29 | 2013.02.05 | Purchasing | Update Item Type Table on all instances | PUR_AP_ITEM_TYPE table has a new field called Tax Charge Indicator (added by UCI customization). As a result, we need to re-populate the item type table on all instances (cfg, cnv, tst, dev, dmo, prf) for tax calculation to work correctly. | KFSI-1527.03.04 | Capital Asset Management | Reload asset types | Expanded asset descr from 70 to 100 per helen to fit full ucop asset description -- previously truncated to 70 please reload asset type from config | KFSI-1914 | ||||
| 2013.06.29 | 2013.01.31 | Purchasing | Reload PURAP Item Type Table - Tax Item Types (UCI specific) should not be taxable | The users have noticed that there are tax calculated on the federal tax. This is due to our Item Type configuration. Taxable Indicator was set to "Y" on all of the UCI-specific taxa item types. I have fixed the flags. Please reload the item tables on all instances including dmo and tst. | KFSI-1509 | KFSI-1486"Y" on all of the UCI-specific taxa item types. I have fixed the flags. Please reload the item tables on all instances including dmo and tst. | KFSI-1509 | KFSI-1486 | |||||
| 2013.06.29 | 2013.02.05 | Purchasing | Update Item Type Table on all instances | PUR_AP_ITEM_TYPE table has a new field called Tax Charge Indicator (added by UCI customization). As a result, we need to re-populate the item type table on all instances (cfg, cnv, tst, dev, dmo, prf) for tax calculation to work correctly. | KFSI-1527 | ||||||||
| 2013.06.29 | 2013.02.27 | Purchasing | Please reload PO cost source table | Values are old in INT, please reload all instances from config spreadsheet. | KFSI-2005 | ||||||||
| 2013.06.29 | 2013.03.04 | Pre-Disbursement Processor | Update PDP Payee Table | When SBS upload student payments that must be paid to their parents, they will be uploading the payee type code of "P" with the student ID (payee ID), parent name, and parent address. Add P for Parents D will be used to Students Per Warren we should not be recycling the code. | KFSI-1510 | ||||||||
| 2013.06.29 | 2013.03.05 | Contracts & Grants | KFSI-2367 Dump and load CAM specific agency codes into CFG database | KFSI-2370 | |||||||||
| 2013.06.29 | 2013.02.08 | General Ledger | Reload offset definition | Update the offset definition. | KFSI-1498 | ||||||||
| 2013.06.29 | 2013.02.04 | Travel and Entertainment Module | Load TEM config sheet | Please load the TEM config from the config sheet provided on P:\SystemDev\KUALI Project\Configuration Master Spreadsheets\TEM\UCI TEM Master 2013-01-29.xlsx. Any questions please ask Samuel Wong (wongss@uci.edu). | KFSI-1512 | ||||||||
| 2013.06.29 | 2013.06.29 | Pre-Disbursement Processor | Define stale check account in the PDP Customer Profile | Hi Maribeth, I need someone (guess who!) to define stale dated check accounts defined in the PDP customer profile. Would you please complete them so we can test the stale check process? Thank YOU! | KFSI-1603 | ||||||||
| 2013.06.29 | 2013.06.29 | Chart of Accounts | KFSI-1482 Correct ORG Codes per Budget Office Review | Thank you Victor and Maria!! maria Victor M. Cesario wrote: > Hi Maria L.: > The only corrections which will directly effect ACCOUNTS are ORGS FS0380 & FS0385 (Cashier's & FS) > (There are only 20 accounts and we can change them online if we do not upload.) > > I reviewed the ORG's with Maria A. and we have come up with the following: > Here is the info that I found, please let me know what should be in KFS: > > > #1 The ORG that was created was 8166 CONTROL - FINANCIAL AID AND SCHOLARSHIPS we will create a reports to: S-9040 CONTROL - FINANCIAL AID AND SCHOLARSHIPS. > > #2 Reports to S/B SOM will find out why it did not load correctly. > > #3 We will create IR-D Level 8298 (FS0380) & 8299 (FS0385) to report to: existing IR-9070 > > #4 We need to change Level V 9-1350 to ELIMINATED HIERARCHY and mark "E" to eliminate. > > #5 The following SW 8286, 8287, 8288, 8289 need to report to: SW 9008 > > > edit copy SW 8286 CENTER FOR GALAXY EVOLUTION A SW 9009-SCHOOL OF BIOLOGICAL SCIENCES D - DEPARTMENT Yes jchemmin > edit copy SW 8287 CENTER FOR HYDROLOGIC MODELING A SW 9009-SCHOOL OF BIOLOGICAL SCIENCES D - DEPARTMENT Yes jchemmin > edit copy SW 8288 HUMANITIES RESEARCH INSTITUTE A SW 9009-SCHOOL OF BIOLOGICAL SCIENCES D - DEPARTMENT Yes jchemmin > edit copy SW 8289 UC INSTITUTE FOR RESEARCH IN THE ARTS A SW 9009-SCHOOL OF BIOLOGICAL SCIENCES D - DEPARTMENT Yes jchemmin > > > > #6 Create SW D Level same as IR D Level for 8169, 8172, 8173, 8174 reports to: SW 9070 > > #7 Create SW S-Level for Control-Planning 9003 and have SW D-8291, 8292 report to it. > > > > > > Maria Aldana wrote: >> Hi Maria/Shae, >> >> It is very difficult to read many of the charts as they cut off in between text boxes. Can you fix and resend? >> >> Maria: I do have the following feedback based on what we reviewed/discussed last week: >> >> 1. The PDF file I received did not include an organizational chart for Control - Financial Aid; however, the agreement was that we were not going to recommend changes. >> 2. FS department 2111 should be stand alone KFS ORG (8xxx level) and should report to KFS ORG 9030 - School of Medicine. >> 3. FS departments 0980 and 0985 should be stand alone KFS ORGs (8xxx level) and should report to KFS ORG 9070 - Control Accounting. >> 4. KFS SW ORG 9019 should be called HENRY SAMUELI SCHOOL OF ENGINEERING and not Office of Academic Affairs. >> 5. KFS SW ORG 9009 (School of Biological Sciences) should only have one ORG reporting to it -- SW 8283, which is FS department 1270. >> 6. KFS SW ORG 9070 (Control Accounting) should have FS departments 915, 955, 925, 930 reporting to it as stand-alone ORGS (8xxx level). Currently, KFS ORGs SW 8291 and SW 8292 are reported under SW ORG 9070 which is incorrect. >> 7. FS department 9030 should be a 9xxx level SW ORG called SW Control Planning and should have FS department 191 reporting to it as a stand alone 8xxx KFS ORG. >> >> It seems that many of the discrepancies still exist in the SW chart, so I've attached a copy of the SW crosswalk table we submitted in November. >> >> Please let me know know if you have any questions. >> >> Maria >> >> ***************** >> >> Maria Lieggi wrote: >>> >>> Maria, >>> >>> Please review the results of our 3 day work and let me know if there are any other changes. >>> >>> Thank you >>> Maria >>> ---------- Forwarded message ---------- >>> From: Shae Chiandet <shae.chiandet@uci.edu> >>> Date: Fri, Feb 8, 2013 at 4:39 PM >>> Subject: Re: Org Config Sheet Update for Vizio >>> To: Maria Lieggi <mlieggi@uci.edu> >>> Cc: Brenda Kay MATHIAS <mathiasb@uci.edu>, "Victor M. Cesario" <vcesario@uci.edu>, Maria Aldana <maria.aldana@uci.edu> >>> >>> >>> Folks, >>> >>> Attached is the PDF copy of the new org chart. It took a while to get the table formatted for upload, so this is just what the Visio wizard produced as-is. When I did it before, I spent some time going through by hand and neatening it up, ensuring that text was all contained within each text box, and that each group of orgs printed on a single page, rather than spreading out across multiple pages. I can make those edits on Monday if you would like. >>> >>> Regards, >>> >>> Shae >>> >>> >>> Maria Lieggi wrote: >>>> Hello Shae, >>>> >>>> Can you please update the Org Vizio according to the attached org config sheet. >>>> >>>> Thank you >>>> >>>> -- >>>> Maria Lieggi >>>> >>>> Accounting Systems Business Analyst >>>> Accounting Systems Division >>>> University of California, Irvine | KFSI-1698 | ||||||||
| 2013.06.29 | 2013.06.29 | Accounts Payable | Populate values into table FP_PMT_MTHD_T | FP_PMT_MTHD_T needs to be populated to get e-Invoice working. | KFSI-2025 | ||||||||
| 2013.06.29 | 2013.06.29 | Financial Processing | In TST: on the Indirect Cost Adjustment there are no object codes in the accounting lines; there should be defaulted object codes, the document cannot be completed without them | In TST: on the Indirect Cost Adjustment there are no object codes in the accounting lines; there should be defaulted object codes, the document cannot be completed without them | KFSI-2363 | KFSI-3986 | |||||||
| 2013.05.20 | 2013.05.20 | Unknown | Setup the application logging with log4j to KFS project log location | Adding new log4j.properties appender to log to KFS log location | KFSI-3302 | ||||||||
| 2013.05.09 | 2013.05.09 | Chart of Accounts | Reload MC Plant Object Codes | It does not appear that you have the latest Plant object codes -- Cynthia has 2/25 version uploaded. Here is the discrepancy: Object Code sub-type of 9214 should NM, currently CNV shows EX Object Sub-Type is critical in mapping assets to the correct fixed asset balance sheet. Please reload. | KFSI-2036 | ||||||||
| 2013.05.03 | 2013.05.03 | Chart of Accounts | ICR informatin is not populating from the Account | When an expense sub account is created from an account that has indirect cost, the Edit CG ICR tab in the Sub Account should auto populate information from the Account. I set up a sub account and no information was pulled over from the account | KFSI-3240 | ||||||||
| 2013.04.10 | 2013.04.10 | Purchasing | Need UCI specific commodity code load process | We have UCI-specific commodity codes such as SUBAWARD and LEASE. The values are referenced by the COMMODITY_CODE_TO_PO_TYPE parameter created in the Warren's PO routing customization. Please devise a process to load commodity codes that are created outside of the UNSPSC codes. I don't see them loaded into our instances right now. | KFSI-1602 | ||||||||
| 2013.03.14 | 2013.03.14 | Chart of Accounts | KFSI-1705 Certain Object Level Codes are set up wrong for Balance Sheet_INT mode | In Kuali INT mode, certain Object Level Codes are incorrect for the following Object Codes. They should be "Noncurrent Assets" per the AGCs. Please correct and review the source documents for the mapping. There might be other errors non detected because I can only export 200 lines from Kuali and the Balance Sheet Object codes are totaled to the high hundreds. Suggestion: is it possible to have the first position of the Object Code for Current Asset to use "J" and Noncurrent Assets to use "K", and also separate Current Liabilities vs. Noncurrent Liabilities by two different prefix in the Object Codes as well? This will help building business rules as well as searching. J130 NA-ED FEE-EDU SERV RECEIVABLES CAST J132 NA-HPSL-EDU SERV RECEIVABLES CAST J133 NA-MERAGE SCHOOL LOAN-ACS RECEIVABLE CAST J131 NA-NDSL/PERKINS-EDU SERV RECEIVABLES CAST J134 NA-UNIVERSITY LOANS-EDU SERV RECEIVABLES CAST | KFSI-1994 | 2013.03.11 | 2013.03.11 | Unknown | KFSI-2367 establish KC and KFS (oda2a) database link | Please create database link from KC to KFS CNV on oda2a (development servers). | KFSI-2368 | ||
| 2013.03.04 | 2013.03.04 | System | Produce a list of UCI-specific parameters | Warren, I need a list of parameters that are UCI specific. They are currently missing from the parameter config. I attempted to list them manually but it will take a long time. If there is an easy way to produce it, I'd appreciate it. Going forward, is there a way for us to "tag" UCI specific parms in component or something? | KFSI-1470 | ||||||||
| 2013.02.26 | 2013.02.26 | Financial Processing | Auxiliary Voucher not working right _ 2.26.13 INV mode | See Error message in Doc#10106, created by Isabelle Liu dated 2/26/13 in INT mode. This error message "Errors found in this Section: The Sub-Fund Group, for each Account used in the accounting lines, must be the same for all lines" indicates to me the configuration or business rule in AV is not set up correctly. Screen shot attached. Please advise corrective action. Thanks, Isabelle | KFSI-1992 | KFSI-1919 | |||||||
| 2013.02.26 | 2013.02.26 | Travel and Entertainment Module | KFSI-1558 Remove DOB and Gender required attribute on TEM Profile | Neither of the fields are required. | KFSI-1980 | ||||||||
| 2013.02.26 | 2013.02.26 | Travel and Entertainment Module | KFSI-1558 Arranger's TEM document indicators should be default to 'Yes' | Arranger's TEM document indicators should be default to 'Yes' * Allow to initiate TA document * Allow to initiate TR/RELO/ENT document | KFSI-1978 | ||||||||
| 2013.02.22 | 2013.02.22 | Chart of Accounts | Budget Adjustment Restriction Code is not set to Control Account (Fund Group and Sub-Fund Group Tables) | Budget Adjustment Restriction Code is supposed to be set to "Control Account" for all Fund Groups and Sub-Fund Groups. However, they are loaded with different value. Please work with Maria to ensure that the correct value is loaded. I am not able to see what "the correct value" should be for control account -- you might need to talk to Dony (KFSI-682) | KFSI-1606 | KFSI-682 | |||||||
| 2013.02.10 | 2013.02.10 | System | Investigate unused UC Davis parameters | Namespace=COA; component=Account AUTO_CREATION_EXPENSE_ACCOUNT_TYPE ACCOUNT_TYPES_REQUIRE_ASSESSMENT SFGS_REQUIRE_ASSESSMENT ACCOUNT_TYPES_REQUIRE_INCOME SFGS_REQUIRE_INCOME ACCOUNT_TYPES_REQUIRE_RATENAME SFGS_REQUIRE_RATENAME ACCOUNT_TYPES_REQUIRING_UC_ACCOUNT AUTO_ASSIGNED_ACCOUNT_NUMBER_ACCOUNT_TYPES PLANT_FUND_GROUP_CODES | KFSI-1469 | ||||||||
| 2013.01.30 | 2013.01.30 | Financial Processing | Do we need Decedent Payment Reason Code? | In the base, we have DECEDENT_COMPENSATION_PAYMENT_REASONS parameter. UCI does not have decedent compensation payment reason code, correct? | KFSI-1473 | KFSI-1471 | |||||||
| 2013.01.28 | 2013.01.28 | Financial Processing | Research DV params | Can you tell me what these do exactly? CHECK_EMPLOYEE_PAID_OUTSIDE_PAYROLL_IND CHECK_PREPAID_ACTIVE_EMPLOYEE_IND DECEDENT_COMPENSATION_PAYMENT_REASONS | KFSI-1471 | KFSI-1473 |