202306 FINAH Release Notes

Owned by Saparnell
Last updated: Jun 15, 2023

Hello FINAH Developers - The below fields are now available for you in Hana Production.

Keep up with our future enhancements here: FINAH Bugs and Enhancements In Progress

Table of Contents


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Nikki Gianquinta
  • Daniel Redfern
  • Lindsay Root
  • Heather Sears


Your Requested Enhancements

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report and you have not take the appropriate remediation steps.


Views with Award Data

Epic:   FINAHE-1398 - Getting issue details... STATUS

SNOW tickets addressed: CS1529001

Added the following fields:

  • Award Agreement Type

Added to Multiple Views:

  • FINAH-Award-View
  • FINAH-ChartStringCombination-View
  • FINAH-Contract-View
  • FINAH-ContractRevenue-View
  • FINAH-PPM-TransactionDetail-View
  • FINAH-Project-View
  • FINAH-ProjectCosts-View
  • FINAH-TE-ExpenseTransactionDetail-View
  • FINAH-UCSDGeneralLedger-View
  • FINAH-UCSDGeneralLedgerBalances-View
  • FINAH-UCSDGeneralLedgerInterface-View

FINAH-ChartStringCombination-View

Epic:   FINAHE-1418 - Getting issue details... STATUS

SNOW tickets addressed: CS1571520

Added the following fields:

  • Project Class Category

  • Project Class Code

  • Project Type

FINAH-PPM-TransactionDetail-View

Epic:   FINAHE-1380 - Getting issue details... STATUS

SNOW tickets addressed: CS1486349

Added the following fields:

  • Transaction Invoice Receipt Amount

Project Notes Added to Multiple Views

Epic:   FINAHE-1393 - Getting issue details... STATUS

SNOW tickets addressed: CS1530196

Added the following fields:

  • Project Note Created By Email Address
  • Project Note Created By Employee ID
  • Project Note Created By ID And Name
  • Project Note Created By Identity AD Username
  • Project Note Created By Name Full
  • Project Note Created By Username
  • Project Note Created DateTime
  • Project Note Last Updated By Email Address
  • Project Note Last Updated By Employee ID
  • Project Note Last Updated By ID And Name
  • Project Note Last Updated By Identity AD Username
  • Project Note Last Updated By Name Full
  • Project Note Last Updated By Username
  • Project Note Last Updated DateTime
  • Project Note Text

Added to Multiple Views:

  • FINAH-ChartStringCombination-View
  • FINAH-ContractRevenue-View
  • FINAH-Project-View
  • FINAH-ProjectCosts-View
  • FINAH-PPM-TransactionDetail-View
  • FINAH-ResourceCommitment-View
  • FINAH-TE-ExpenseTransactionDetail-View
  • FINAH-UCSDGeneralLedger-View
  • FINAH-UCSDGeneralLedgerBalances-View
  • FINAH-UCSDGeneralLedgerInterface-View

FINAH-TE-ExpenseTransactionDetail-View and FINAH-TE-User-View

Epic:   FINAHE-1385 - Getting issue details... STATUS

SNOW tickets addressed:CS1469791

Added the following fields:

  • User Financial Unit
  • User Financial Unit Code
  • User Financial Unit Code And Name
  • User Home Department
  • User Home Department Code
  • User Home Department Code And Name
  • User HR Status
  • User Last Separation Date
  • User Reports To Employee ID
  • User Reports To ID And Name
  • User Reports To Name Full
  • User Vice Chancellor
  • User Vice Chancellor Code
  • User Vice Chancellor Code And Name

FINAH-UCSDGeneralLedgerBalances-View

Epic:   FINAHE-1321 - Getting issue details... STATUS

SNOW tickets addressed: CS1416531

Added the following fields:

  • Annual One Time Base Budget Amount
  • Annual One Time Budget Adjustments Amount
  • Annual One Time Distributed Budget Request Amount
  • Annual Recurring Base Budget Amount
  • Annual Recurring Budget Adjustments Amount
  • Annual Recurring Distributed Budget Request Amount
  • Fiscal Period to Date One Time Base Budget Amount
  • Fiscal Period to Date One Time Budget Adjustments Amount
  • Fiscal Period to Date One Time Distributed Budget Request Amount
  • Fiscal Period to Date Recurring Base Budget Amount
  • Fiscal Period to Date Recurring Budget Adjustments Amount
  • Fiscal Period to Date Recurring Distributed Budget Request Amount
  • Fiscal Quarter to Date One Time Base Budget Amount
  • Fiscal Quarter to Date One Time Budget Adjustments Amount
  • Fiscal Quarter to Date One Time Distributed Budget Request Amount
  • Fiscal Quarter to Date Recurring Base Budget Amount
  • Fiscal Quarter to Date Recurring Budget Adjustments Amount
  • Fiscal Quarter to Date Recurring Distributed Budget Request Amount
  • Fiscal Year to Date One Time Base Budget Amount
  • Fiscal Year to Date One Time Budget Adjustments Amount
  • Fiscal Year to Date One Time Distributed Budget Request Amount
  • Fiscal Year to Date Recurring Base Budget Amount
  • Fiscal Year to Date Recurring Budget Adjustments Amount
  • Fiscal Year to Date Recurring Distributed Budget Request Amount


Upstream Data Changes in OFC

BIA has been alerted to some changes in Oracle that may impact reports built from the Financial Activity Hub (FinAH).  While there were no changes made by BIA to FinAH, we wanted to pass along the information.

These changes went into effect June 10th and were announced in the June 6 “Budget & Finance Weekly Digest” newsletter. You can subscribe to the "Budget & Finance Weekly Digest" here and also find past articles.

Other items were included in the newsletter, but some relevant paragraphs and effects are highlighted below.

  1. Updates to Department Reporting Categories
    This was mostly just a wording change from “Controlled” to “Portfolio”, however any calculated fields that check specifically for the previous text will have broken.
  2. Updates to Research Project Classifications
    Previously, within the Project Type: “UCSD Sponsor Project” there were multiple Categories/Codes which identified Clinical Trials.  Those categories/codes are gone and now all just say “Research”.
    Any reports that specifically target Clinical Trials may have broken.