Limitations

Currently, the REST web services for Financial Projects Integrator lack user security features, which essentially means that anyone can use the Integrator to download projects from any Business Unit without any access restrictions or authorization protocols in place. Please be aware of this restriction when giving users access to the integrator as this absence of user security measures may raise concerns about data confidentiality and access control within the system. You may want to limit the use of this Integrator to ‘Superusers’ of the system. We have raised an idea with Oracle to improve this functionality. Please click here to add your vote to the idea.

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.