Hi Janos,

I would strongly advise against doing this with SQL.

There is a non-public REST APIs to create a staffing Profile for a project - possibly copying it from another Staffing Profile. You can also pass an array with the IDs of the positions to copy over of you do not want to copy everything over.

As with all non-public REST API, it's not officially supported and there's no guarantee it'll work as expected, but it'll still be better than to write your own PL/SQL and end up with inconsistent DB Data.

You may want to submit an idea to make this private REST API officially supported & better documented. But please don't use direct SQL update for this.

Hello Etienne,

thanks for this post. Unfortunately we have the staffing profile in a request, the customer just need to do resource management, the project will be done in Octane. 

Some positions of the staffing profile are already provided in the request. The efforts estimation are coming from Octane and we actually just need to transfer the efforts into the staffing profile and the resource manager need to assign the resources afterwards.

Greetings

János