Known Issues and Approved Change Requests

The Income Statement Report does not execute in production. Recent chart of accounts hierarchy changes require the to be rebuilt.

Single row subquery error in Dev environments. Ticket has been opened with Oracle.

CIP Asset types have at times been blank when amounts should be evident. Also, the date in service is not properly updating.

The UCD GL Monitoring report is currently experiencing issues with the Financial Department prompt. Parent level Financial Department does not currently work in the reporting.

Work is currently underway to improve report performance.

Remaining Purchase Order Amount does not consider tax. Issue us being investigated.

UCD Pre-Bill Cost Reimbursement Report currently times out. A solution is being investigated.

The UCD List Price Update report does not display the correct list price details. Report is in the process of being rebuilt.

Options for improving report performance are currently being explored.

The Distribution Details tab for invoices is currently not working. When navigating to this tab, a system error appears.  (See screenshot). This tab is meant to show users accounting information for the invoice. The reporting team is working on correcting this issue.

11/6/24 - A ticket has been opened with Oracle.

There are currently 3 boundary applications sending Requisitions into Aggie Enterprise – OPP, DSL and VMACS. If a user duplicates one of these imported requisitions, the workflow at the PO level errors out for SCM buyers.

Workaround: Users should not duplicate any of these imported requisitions. In these cases, requisitions should be initiated from scratch. The “Duplicate” button works as expected in all other scenarios.

9/16/24 - Issue is resolved as of 9/13 afternoon.

Accumulated carryforward balances equal to the amount of FY24 activities were posted in August 2024, so the August-ending carryforward balances are aligned with the FY24 total balances. For a detailed explanation and demo, see Carryforward Explanation.

PDF is cutting off information and there are alignment concerns. Bill-to-address needs to be adjusted to the site level and updated in the remittance section. The Transaction Date currently showing should be the Accounting Date.

Adjusts Financial Department level parameter and add new fields.

Adjust Parameter:

-User needs to be able to run by Parent Level E Financial Department

Add New Fields:

-Vendor Name

-Report Key - currently the report only displays Purchasing Card transaction and user needs the detailed data

Fixes drill-down feature and corrects reporting for PCARD & TCARD clearing accounts.

9/26/24 - Resolved and moved to Production.

8/30/24 - A fix is ready and waiting to be moved to Production.

PPM's "Review Project Performance" is not showing correct EAC budgets. The displayed budget is showing as double (and in some cases even higher) than the actual budget. If you find your budget amount not aligned to the project amount, please submit an Aggie Enterprise Help ticket, select "General Question" to route most efficiently.  

Add Parameter: Status (All, Active or Inactive)

Add or Modify Fields:

• Number (Person or Party Number)
• Category (User Category)
• Switch ‘Active’ field from Y or N to naming ‘Status’ referencing Active or Inactive

Order Report by User Name, then Role Names

Isolate UCD Primary Ledger - As a result of the new Foundation Ledger, adjust report to only include UCD Primary Ledger = 300000008409485

Adjust the following (Multi) Select & Search parameters:

Report times out when running and fails when scheduling.

Fixes duplication in category mapping and corrects reporting for PCARD & TCARD clearing accounts.

9/26/24 - Resolved and moved to Production on 9/26/24.

8/30/24 - A fix is ready and waiting to be moved to Production.

Map new burden schedule names to indirect cost base codes.

10/10/24 - Project moved to Integrations and will be tracked by that team.

Incorrect information appears on the Purchase order PDF.

11/10/24 - Fix is currently being tested.

There will be a separate project file with all the master data information on project task details along with Task DFF values for Non-Sponsored projects. This should also list the award against the project and NIFA Accession & Project Number for each entry where applicable.

There will be a separate file for master data of Awards – all details needed for awards.

There will be an expenditures file which can be linked via Project, Tasks, and Expenditure Item Date.

Updates to mapping. Corrects report code and format issues.

8/30/24 - A fix is currently being tested.

The following fields are being added to the report:

• Award Entity - after Award Name
• Project Entity - after Project Name

UC Path files from the July 20th, 2024 biweekly transfer to Aggie Enterprise failed to import. As a result, users will see the following batches post to the August 2024 accounting period in PPM, not the July 2024 accounting period.

There was a defect in Oracle that occasionally fails to transmit the State Abbreviation field with the electronic PO, causing the order to fail. Solution implemented resolved this issue.

UCPath used a KFS Object Code in Labor Ledger processing impacting Fringe Cost Transfers.

Batches impacted: 3911_240831M0X% and 3911_240803B1X%. This means that UCPath 339 report does not match Oracle.

The central team is working on a plan to correct this issue. In the meantime, units are asked not to move any entries out of Department Kickout (DKO) projects.

Cost transfer file with the KFS Object Codes for CBR and Vacation Accrual went to default (this is for Jul-24). Batches impacted contain: 3897_240720B3X_00008791_COST_TRANSFER. This means that UCPath 339 report does not match Oracle. Central team implemented a mass correction. 

8/28/2024 Update: This resolution was overwritten by UCPath. An update to the issue is pending, but currently, UC Path data in Aggie Enterprise may be double counted.

Some PPM Project updates and Financial Department approver updates in Aggie Enterprise are not loading into AggieExpense properly. This includes PPM approver updates, Task updates or additions, and updates to Financial Department approvers. Please email AggieExpense Help at expensehelp@ucdavis.eduto report the missing/incorrect information.

SCM is working with our Admin IT partners to resolve the issue.

Early on in conversion planning, Foundation funds were assigned 6xxxx and 7xxxx fund numbers. It was later decided to change them to alpha-numeric funds (See Understanding Gift Fund Value Structure KBA).  
• Note: Past iterations of department mapping may have included the 6xxxx and 7xxxx Foundation funds, which have now been inactivated.

Central Accounting will research and address any balances on these funds.

Users are encountering the following error message when trying to open the Project Financial Management module:

'Error code: Association end PartyP of assoc NoteEOToPartyPEO invalid for entity base PartyPEO in view object NoteUIViewVO'

Issue resolved. Fix applied 7/16/24 at 7:10pm. 

The UCPath I-370 COA Validation webservice has been updated to correct Entity Codes, PPM Department Kickout Logic and Labor Ledger Processing. This fix includes checks to Project Status, Award Status and Project End Dates, resulting in reduced kickouts to DKO projects moving forward. 

An error was detected in the way the Facilities and Administration Offset Recovery (Offset) records in the General Ledger.  The Offset is used to centrally accumulate the total F&A being recorded on individual sponsored projects.  The system has been incorrectly posting the Offset to the same Financial Department and Project where the F&A expense is posting.  The Offset should have been recorded in the central Contracts and Grants Accounting Financial Department.

Boundary Systems can now submit Journal Requests via Aggie Enterprise Integration Platform without rejection when the Award status is "Expired" with an active Project.   PPM Segment validation now recognizes "Active", "Under Amendment", "Hold", and "Expired" Award statuses for successful posting to respective projects.

Cost transfers split, posting GL correctly to Period 12, and PPM erroneously posted to July (Period 1).

PPM postings will be reversed and posted to correct Period 12 by July 12, 2024. 

When using the “Advance” search features on the Manage Project Costs screen, the system includes the option to select “Between” for Account Period search parameters.

The AEE-421 AggieExpense Unreconciled Direct Billings Report is no longer adding data after 4/10/24, and reconciled transactions are not being removed. 

From 1/4/24 to 5/24/24, some transaction data did not transfer to GLIDE. 

If you need detailed information on these transactions, please reach out to AggieExpense Help at expensehelp@ucdavis.edu. 

There were Awards in KFS that should have migrated to Aggie Enterprise, but they did not. Team added those Awards into Aggie Enterprise, including migration of expenditures. 

Use of "One-time" address for campus locations may cause punch-out vendor to charge incorrect sales tax on invoices as system only allows "Internal" Addresses to carry postal code 95616-5270.

6/20/24 Update: On-going. For campus locations, users should only use Internal addresses set in the system. If you’re unable to find your campus location in Aggie Enterprise, please reach out to SCM using the Aggie Enterprise help form and selecting the Purchasing subcategory.

Use tax was charged on all taxable Expense Types even if the sales tax amount was added in the “Merchant Charged Sales Tax” field. If you find that your department was charged use tax when sales tax was already paid, please complete the Use Tax Accrual Correction Form and add “Due to system issue” in the Additional Information section.

In most cases, out-of-pocket expenses defaulted the Program, GL Project, and Activity fields to all zeros, even if data was entered into AggieExpense. The other chart fields loaded correctly. If you need detailed information for your financial department’s activity to process corrective journal entries, please reach out to AggieExpense Help at expensehelp@ucdavis.edu.

Report contains missing and incorrect Withholding Taxes.

At go-live, there were cases where the Department Kick-Out (DKO) logic was not working as expected and transactions posted to DKO projects, including payroll transactions.

This issue impacted the DKO process and the UCPath Labor Ledger Processing (I-101 and I-370).

A fix was applied 5/8 to correct validation flow. The payroll workflow has been updated to utilize GL error workflow, which should reduce activity in DKO.

In Feb. '24 a one-time process to support Correcting Chart String Balances (and PPM Budgets) Post Go-Live began, units submitted files for converted balance corrections including PPM budgets. On 4/29/24 GL conversion reclass corrections for converted balances were loaded into Aggie Enterprise.

It may be helpful to use the Inquire on Detail Balances tool in the General Accounting Dashboard to verify the balances. 

Carryforward offsets erroneously posted to academic and administrative units instead of Central Office General Accounting. This may impact the available balances units are seeing at go-live.

In Feb. '24 a one-time process to support Correcting Chart String Balances (and PPM Budgets) Post Go-Live began, units submitted files for converted balance corrections including PPM budgets. On 4/29/24 GL conversion reclass corrections for converted balances were loaded into Aggie Enterprise.

Remove columns from report.

At go-live not all vendors have ACH remittance email addresses set up in their records. AP and Supplier Services will continue working to add these emails so remittance notifications can go out to payees.

Vendors with questions on ACH payments should contact aphelp@ucdavis.edu

The validate button was returning successful chart strings regardless of possible issues. 

The POET PPM tab was displaying the chart string at the bottom in PTOEAF order, instead of POETAF.

An enhancement was implemented o comply with UCOP guidance and to allow new Subawards to be processed in the 1800B Fund groups.

Impacts all users as the update Cross-Validation Rule (CVR) will include additional Fund and Natural Account parents:

1800B - Special Site Appropriations B

1999B - Specific State Appropriations B

2000B - Contracts and Grants

Natural Account 53300B - Subcontract Services

The "add" and "duplicate" options interfered with pre-populated procurement smart forms, causing incompletion Requisition lines to route to buyers. Removing these buttons eliminates the incomplete lines and improves turnaround time for PO processing.

To streamline homepage, removed the left sidebar, and "Social" tile. Removing "Social" drives users to seek support using established channels. 

Issue resolved, Delivery addresses now populating in corresponding Delivery Address box on the PO PDF.

As a reminder, for Purchase Orders that are automatically created, with no buyer involvement, the resulting PO will need to be manually provided/emailed to the supplier once it is issued.

The budgets loaded into PPM Non-Sponsored Projects are have a budget as of October close.

December 2023 close balances from KFS were loaded as PPM Budgets end-of-January, to ensure they match the converted budget balances in the GL. At that time, everything will be up-to-date from a conversion standpoint.

2/9/24: December budgets were loaded and validated

Related: CGA is working to process new and amended projects received after November 21st. 

Change implemented to that allows Boundary Systems (BSYS) to post UCD Recharge Revenue to a PPM Internal (Faculty) Project. 

2/9/24 update: 81 of the 100 POs that did not initially convert have successfully been reloaded. 19 POs did not convert. At this point, the 19 will not be reloaded. If they are still valid and need to be in Aggie Enterprise, please process a Requisition and note in your request that this is an attempt to recreate a PO from KFS that did not convert.

TouchNet daily credit card feed was inaccurate for those merchants that process directly to Aggie Enterprise ledger.

All transactions posted from the TouchNet Feed to the ledger have been reversed,and reloaded with correct amounts.

An enhancement has been applied to ensure that subaward invoices always route to both project manager (department approver) and then to PI before going out for payment. All subaward invoices must be approved by project manager and PI to ensure appropriate use of funds.

During conversion some PPM Project end and close dates set to default, this impacts expense transactions and other activities associated with financial administration of a sponsored award.

An enhancement was applied to update end and close dates to correct date(s). 

Units who submit recharge billing to GL only chart strings on their own using the UCD Revenue Transfer Journal process will have their journal auto-reject.  This is expected to be fixed very quickly so please wait to submit your journal until the fix is completed. 

If your journal has already auto-rejected you can resubmit the rejected journal after the fix (if you do not want to resubmit your journal for approval, then you should click Batch Actions and select the Delete option from the drop-down menu to delete the rejected journal).

Analysis complete. Process for correction can be found in the PPM Project values missing from the PPM subledger knowledge article.

Due to complexity of extracting correct sales tax for only open purchase order lines from Kuali, converted POs in Aggie Enterprise do not include sales tax. When converted POs are invoiced, correct sales tax will be calculated by tax engine and will be paid based on zip code listed in PO and vendor charged tax. 

Purchase orders were converted based on the CoA/PPM rules that were established for go-live. The invoicing team is unable to update the existing accounting information.

If these rules do not reflect the department's desired mapping, the recommended guidance is to reallocate the expense after the invoice is approved. This can be done through a journal or PPM cost transfer.

• Journal transfer - https://kb.ucdavis.edu/?id=09749

While over 20 catalogs are available in Aggie Enterprise, not all previously available AggieBuy Catalogs are there yet. Catalogs are continuously being added.

See Supplier Catalog plan for details.