Skip to main content

System Status: 

ISIS to PPM COMA Enhancement

Find information about the ISIS to PPM COMA Enhancement.

Beginning November 20, 2023, transactions processed from ISIS that are charged to a project will be imported into PPM, and posted to the GL from PPM, similar to transactions processed from various recharge units/systems and UC Path. Eliminating the current two-file process will streamline the integration and reduce the variances between PPM and the GL due to file failures.  Transactions that are subject to project violations due to project transactions controls, project/award/budget date violations, etc. will continue to be posted to the default project of the original project and can be corrected via cost transfer in PPM.

Background

In 2022 issues were identified within the ISIS interface (referred to as COMA) with Oracle. The findings revealed that when PPM SLAs were being updated, the changes were not reflected in COMA causing discrepancies between the GL (General Ledger) and PPM (Project Portfolio Management) reporting. This misalignment raised concerns and led to the need for improvement.

The root issue stems from how transactions are processed within the ISIS system. Each transaction in ISIS is processed using a Detail Code, which is then mapped to a specific Chart of Accounts string in COMA. COMA was initially set up to send two separate files for each transaction related to a project:

  1. One transaction is sent to the General Ledger (GL) system with details based on the COMA mapping
  2. The second transaction is sent to the Project Portfolio Management (PPM) system with project-related details from the COMA mapping                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

The discrepancies occur when the SLAs in PPM do not match the Chart strings in COMA, leading to imbalances. Another issue is that the projects associated with detail codes might be expired or inaccurate, causing transactions to be manually posted to default projects. Various reasons contribute to PPM's inability to post to a project, such as expired project end dates, closed tasks, incorrect project numbers, and various other reasons.

Current State vs Future State

currentstate.png

futurestate.png

Expenditure Types Affected

The following expenditure types affected will include, but not limited to, the following:

 510000 - Undergrad Financial Aid Odd Year
 510001 - Undergrad Financial Aid Even Year
 510003 - Undergrad NSF REU Stipend
 511000 - Graduate Financial Aid Odd Year
 511002 - Graduate and Postdoc Aid/Fellowship
 511003 - Graduate Tuition and Fees
 531200 - GSHIP Self-Insurance
 772001 - UNEX Recharge-Class Fee - Debit

Resolving COA/POETAF Failed Validation Errors

  1. Transactions on Default Chartstring:
    1. If you encounter ISIS transactions already incurred on the default chartstring, initiate a cost transfer to correct the chartstring. Please refer to the Knowledge Base Article (KBA): "How to Initiate a Full or Partial Cost Transfer in Oracle PPM" for guidance
  2. Determine Root Cause of Validation Error:
    1. Undergraduate and Graduate Coordinators: Before requesting any student stipends, tuition and fee payments, or insurance fees, ensure that the complete Chart of Accounts (COA) is correct and that project end dates have not expired. Also, confirm with the departmental fund manager
    2. Fund Managers: Verify that project end dates have not expired. Additionally, fund managers should be aware of the detail codes used in ISIS mapped to chartstrings, and collaborate with the departmental student affairs team to request a new index if the index contains outdated or incorrect chartstring information. In some cases, the errant activity may need to be reversed from ISIS and a new detail code may need to be used to re-create the transaction.
For other questions or problems, contact Student Financial Solutions through the UC San Diego Services & Support portal or call the Finance Help Line at (858) 246-4237.