Projects REST web services do not respect user security
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 clickhereto add your vote to the idea.
Descriptive Flexfields
Please refer to the Descriptive Flexfields documentation for more information about them and their limitations.
Bulk Data Load
To work around potential performance issues in the Project 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.
Mandatory Quick Entry fields
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.
Business Unit / Legal Entity
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.
