Do you have a chart of account segment to capture grant information?
We own the PPM module but are considering using a chart of account segment for the purpose of collecting costs (for grants or other purposes at users prerogative). Any thoughts as to whether this is a good idea or bad? Thanks!
Best Answer
-
In Oracle Fusion Cloud ERP, PPM and PGM are related but different layers used to manage projects and programs.
PPM — Project Portfolio Management - PPM in Oracle Fusion Cloud ERP is the overall functional suite in Oracle Fusion that manages project-related work and finances.
PGM = Project and Grants Management - PGM is the combined functional area used when managing projects that are funded by grants. PGM integrates standard project management with grant funding compliance.
My understanding is that PGM is technically an add-on or extension to PPM, not a separate product. Every core function in PGM relies on PPM's underlying infrastructure. So by that definition, we are implementing PPM as part of our solution, but our concentration is on PGM as our cost accounting solution, and grant management solution.
PGM adds capabilities on top of PPM for: Award Management (Tracking grants etc.), budgetary control by award, compliance & reporting by award, indirect cost rate management, effort reporting (time and labor charged to an award), award closeout etc.
I hope that helps. I am no expert, as we are not yet implemented, but we are going through the design and configuration processes currently.
Below is a snippet from Oracle Documentation
Answers
-
Hello. For the County of Orange (California), we do not have a dedicated segment to capture grant information, but we are using PGM for this. Our COA will have a "Project" segment that will map into the PGM details. Caveat to this is that we are still in design stages, and will not be live on Oracle Fusion Cloud until July of 2027. Our COA is currently anticipated to be: Fund—>Budget Unit—>Cost Center—>Account—>Project—>Interfund—>Future1—>Future2
-
Thank you for the response Jon. Do you mind telling me what PGM stands for? When you move into Fusion in 2027, do you intend to use the PPM in Oracle Fusion?
-
Jon, Thank you for all the info! Your comments are extremely helpful.
-
We've taken a similar approach, utilizing a COA segment that includes the Project Number that we've established in PPM. Our Grants in particular also sit in a separate fund for special revenue.
-
For what it is worth, consider how you plan to integrate your PPM project numbers to the GL Project segment. We did ours via OIC and it is working well, but if you aren't planning some sort of integration you will need a person to try and keep the two in sync with end dates, name changes, etc.
-
I'd love to hear more about that OIC solution for keeping the two in sync. We're entering ours into the GL manually now which is definitely more work than I'd like.
-
@Steven Greenway theres a project status change business event you can enable that contains all the info and OIC can subscribe to. Then you call the add value API for the project segment and the hierarchy add. Our project hierarchy is flat, no parents so that was easy for us. If you have a hierarchy in your project segment with parents you’ll have to fine a way to derive the parent programmatically. Happy to jump on a call if that would be helpful. We went live in 2019 and just got around to automating this process a month or so ago.
-
That would be spectacular! Would you happen to have a test IAL file that you could share as well?
-
Yeah I'll need to strip out some environment specific stuff. I'll PM you.
