Solution Overview
The technical aspects involved in the integration between Oracle Assets and Oracle Utilities Work and Asset Cloud Service are:
The integration layer consists of integration processes deployed on Oracle Integration Cloud.
The integration processes interact with other applications using the following adapters:
Oracle ERP Cloud Adapter to invoke Asset FBDIs and scheduled processes in Oracle ERP Cloud/Oracle Assets. This invokes:
Fixed Asset Mass Additions FBDI
Prepare Asset Transaction Data scheduled process
Project Asset and Assignment FBDI
Fixed Asset Mass Transfer FBSI
Fixed Asset Mass Adjustment FBDI
Fixed Asset Mass Retirements FBDI
FTP adapter to interact with the Oracle Utilities Work and Asset Management FTP server to search, get, and rename the asset extract files.
REST Adapter to interact with the Oracle Utilities Work and Asset Cloud Service Object Storage to search, get, and rename the asset extract files.
REST Adapter to invoke ERPFA REST APIs to get the Asset Details and the Schedule Process/job status.
REST Adapter to receive and send asset records across Oracle Integration Cloud integration flows and also used to invoke the Common Error Handler Oracle Integration Cloud integration flow.
The integration pattern used for the solution is:
One-way asynchronous for all flows.
Email notification is optional in most cases. Configure the email.flag property name in the OUTL-BRT-WACS_ERPFA_CONFIGPROPS lookup to ‘true’ to receive email notification when errors are encountered. By default, this is set to ‘true’.
The recipient(s) of the email notification is configured in the OUTL-BRT-WACS_ERPFA_EMAIL_ID lookup.
Refer to the Integration Flows section for more information about each integration process.