Design Details
The design details of this integration are described as follows:
Project Synchronization
The project synchronization flow supports the following cases:
• Create a project in Oracle Utilities Work and Asset Cloud Service on approval of construction and maintenance project in Oracle Project Management.
The flow enables automatic creation of Oracle Utilities Work and Asset Cloud Service project on approval of project in Oracle Project Management. The integration limits the data transfer of Fusion ERP projects based on the project work type lookup defined in Oracle Integration Cloud. The implementation will use the work type lookup in Oracle Integration Cloud to identify the construction and maintenance projects that need to be automatically created in Oracle Utilities Work and Asset Cloud Service based on project activation in Fusion ERP. The integration also stamps the Fusion ERP project number as the ERP Reference Number field in Oracle Utilities Work and Asset Cloud Service project.
• Update the project status in Oracle Utilities Work and Asset Cloud Service on status update of the integrated project in Oracle Project Management.
When the system status change of project in Oracle Project Management requires change in the Oracle Utilities Work and Asset Cloud Service project status, the status change information is passed on to Oracle Utilities Work and Asset Cloud Service. Oracle Integration Cloud lookup defines the mappings of valid Fusion ERP project system status to the Oracle Utilities Work and Asset Cloud Service project status. Only the status changes defined in the lookup are passed on to Oracle Utilities Work and Asset Cloud Service.
Activity to Task Synchronization
The activity to task synchronization flow supports the following cases:
• Create a project task in Oracle Project Management on approval of activity in Oracle Utilities Work and Asset Cloud Service
When an activity is approved in Oracle Utilities Work and Asset Cloud Service, the integration automatically creates a project task in Fusion ERP. The Fusion ERP project number is derived from the ERP Reference Number field of the topmost project in the project hierarchy of Oracle Utilities Work and Asset Cloud Service project assigned to activity/work order. The Fusion ERP parent task, if any, is derived from the ERP Reference Number field of the project assigned to activity/work order in case the Oracle Utilities Work and Asset Cloud Service project on activity/work order is not the topmost project in hierarchy.
• Update the task status in Oracle Project Management on the activity status update
When the Oracle Utilities Work and Asset Cloud Service activity status changes to COMPLETE, CLOSED, or CANCELED, the integration changes the Fusion ERP project task status accordingly.