Limitations

Prior to 24C, access to create and maintain Projects via the More4apps Financial Projects integrator could not be limited in any way. The 'Manage Project Service' privilege provided super user access to all Projects in in the entire instance via the REST web service. This security weakness concerned customers and caused them to allow access to the REST web service only to Super Users.

In 24C, Oracle released new data security policies, enabling Manage Project Service to be controlled in a number of ways. Click here for more information about how to implement these data security options.

Refer to the Descriptive Flexfields documentation for more information about them and their limitations.

To work around potential performance issues in the Projects Integrator, a grouping methodology is used to load each section of the Integrator. For example, if 500 Tasks are to be created from the Integrator, it will group 10 tasks at a time and upload these to the supported Oracle ERP Cloud web service. If any one of the 10 tasks have an error, the entire group will be rejected by the REST web service and the error is to be corrected before another upload is attempted. It is recommended that before a large set of Tasks are created, a “Validate” run is done to identify any errors in advance.

If a Project Template has mandatory Quick Entry fields such as Classifications or Team Members, the Financial Projects Integrator, which uses the Supported Oracle ERP Cloud web service, will ignore them. For example, a project without Classifications will be created using the Financial Projects Integrator even though Classifications is set up as a mandatory field to be populated as part of the Quick Entry form in Oracle.

Currently, suitable Oracle ERP Cloud LOV web services do not exist for Business Units and Legal Entity. It is, therefore recommended that these columns are left blank for the upload process. The values against the Source Project Template will be copied to a new Project when it is created from the Integrator. Business Unit and Legal Entity are currently read-only columns on the sheet.

The 'Project Status Change Comment' field can be used when creating or updating a project’s status through the Financial Projects Integrator. However, due to a REST web service limitation, this field is not available for download from Oracle ERP Cloud. While the comment is successfully recorded in the system, it will not appear when you download project data in the Integrator sheet.

The Parent Task cannot be changed using the integrator, as Oracle’s REST web service does not provide functionality to update or reassign a Parent Task once it has been created. An idea has been logged with Oracle Idea Lab for this functionality to be available. Please vote on the idea number 917467 for Oracle to consider.