For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
I need to update project manager on hundreds of projects as the project manager assigned to the project has left the business, can the project import spreadsheet be used for this or is it just used to create new projects?
Comment
We use the PPM REST API processes:
https://docs.oracle.com/en/cloud/saas/project-portfolio-management/19c/fapap/index.html
Project Team Members:
https://docs.oracle.com/en/cloud/saas/project-portfolio-management/19c/fapap/api-projects-project-team-members.html
Be the first to rate this
|
Sign in to rate this
Unfortunately the requirements for the API seem to suggest that it can only amend resources one project at a time which is OK when multiple resources are being updated on one project but of little use when one resource is being updated on hundreds of projects.
Be the first to rate this
|
Sign in to rate this
We use a REST API software tool to load from a spreadsheet and we update in mass.
Be the first to rate this
|
Sign in to rate this
Hi Meredith,
Thanks for replying again. Do you have any details of the process that you can share? Does this process use the project import template provided by Oracle or have you created your own process?
Be the first to rate this
|
Sign in to rate this
Hi Dennis,
ReadyAPI may be the software that Meredith is referring to, it's a very common tool in API development and testing. I've used that quite a bit for looping through an Excel source data file and calling Oracle APIs with that data. There's also Postman with the Collection Runner feature, looping through CSV or JSON data.
Both require some technical understanding of REST API calls, though, so not something you'd want to expose to your end users (at least not directly). That help?
Glen
Average Rating:



1 rating
|
Sign in to rate this
Thanks Glen, I'm not very technical so doesn't mean much to me but I will get our support team to have a look and see if either of these options will help us. Appreciate your help
Be the first to rate this
|
Sign in to rate this