Cookies on this website
We use cookies to ensure that we give you the best experience on our website. If you click 'Continue' we'll assume that you are happy to receive all cookies and you won't see this message again. Click 'Find out more' for information on how to change your cookie settings.
  1. Under 'Import', select 'Oracle Finance Project Import' and click on 'Start new import session'
  2. Add the UO Projects Management Overview.xls file
  3. Run report
  4. Review all results/pages - grants requesting immediate attention will appear on the first page(s)
  5. Once you are happy with all the changes that have to be make, click 'Apply Updates'

Finance projects that are automatically updated are shown by the Status 'Automatic Update'; clicking on the magnifying glass 'View' will show the changes that will be applied.
Spot checks are recommended.

The Import report is saved as you progress. If you log out, you can continue by selecting: Import > Resume

How to confirm a manual update

  1. Click 'Edit'
  2. Select either from Oracle or from  PINFOX the value you want to keep. Select 'Hidden' if the End date is now in the past
  3. You may add a note - please add a date & your initials
  4. 'Save update'

How to ignore/restore a finance project

  1. Click the red cross 'Ignore'
  2. Add in a 'Reason for ignoring' - please include date & your initials within the note
  3. If you want this finance project to appear flagged (yellow) in subsequent reports, tick the box
  4. Click 'Ignore entry'

To restore a finance project that has been previously ignored, click the green plus 'Restore'

Scenarios produced by R12

  • NDM project - non NDM task - non NDM PI: ignore & don't flag
  • NDM project - non NDM task - NDM PI: ignore & don't flag
  • NDM project - NDM task - non NDM PI: ask grant manager who is the NDM PI
  • non NDM project - non NDM task - NDM PI: add in PINFOX
  • non NDM project - NDM task - non NDM PI: ask grant manager who is the NDM PI
  • non NDM project - NDM task - NDM PI: add in PINFOX

Notes:

  • Unless the funding body is John Fell Fund, ignore all Projects starting with D instead of R (after the first two letters = cost centre)
    as 'Reason for ignoring', add the Project Type (e.g. Department Indirect)
  • Projects with a T instead of an R are studentships and should be ignored with the following note: 'Studentship awaiting new display format [date] [initials]'
  • Tasks ending with a letter insted of a number are usually (but not always) for external contractors

How to update the Full Name of finance projects

  1. Under 'Import', select 'Oracle Oracle Project Names'
  2. Click 'Browse and add the UO Projects Portfolio.xlsx  file
  3. Run report

How to update the Sponsor Reference Number of finance projects

  1. Under 'Import', select 'Oracle Sponsor References'
  2. Click 'Browse and add the UO Agreement Funding.xlsx  file
  3. Run report

NDM Cost centres

  • AJ: Target Discovery Institute - NDM research building
  • AW: Medawar Building
  • B5: Structural Biology
  • B9: Tropical Medicine
  • CR: Big Data Institute
  • H2: Centre for Cellular and Molecular Physiology
  • H5: Wellcome Trust Centre for Human Genetics
  • H9: Structural Genomic Consortium
  • HB: Experimental Medicine
  • HC: Jenner Institute
  • HP: Ludwig Institute