Error Handling
This section provides information about the different ways used to handle errors in the integration and also resubmitting the instances after rectifying the errors.
Error Handling Ways
In this integration, all integration flows are asynchronous. The next section describes error handling for asynchronous flows.
Asynchronous Flow Error Handling
Technical Fault
This fault occurs when there is a data mismatch or any Xpath related error. When this error occurs, the flow immediately goes to global fault handler and an optional email to the respective user is sent.
Remote Fault
This fault occurs when the target system is down. When this error occurs, the flow immediately goes to global fault handler and an optional email is sent to the respective user.
Business Fault
These faults are application-specific that occurs when there is a problem with the information being processed in the target application due to invalid data or business error validations.
For processing records in a file
When Oracle Utilities Work and Asset Cloud Service returns HTTP status codes 400 or 500, these are considered business faults by the integration. When these errors occur, the flow will not stop but continue to process the next record and the errors will be stored in a temporary error collection. When the file is done processing an optional email is sent with the list of errors to the respective user.
Summary of Integration Error Handling
Integration Process: Chart of Accounts Synchronization (COA Sync)
Type of error
Action
Notification Type
Retry
Technical or Remote Fault
Process Stop
Email
Resubmit Error Instance From OIC
Business Fault (WACS returns Status Not 400 or 500)
Process Stop
Email
Resubmit Error Instance From OIC
Business Fault (WACS returns Status 400 or 500)
Continue Process
Collect errors and send errors in Email
Data Fix in Integration - Reprocess COA file
 
Data Fix in WACS - Run Batch W1-SIOERR to reprocess error sync records
 
Integration Process: GL Extract Process (GL Extract)
Type of error
Action
Notification Type
Retry
Technical or Remote Fault
Process Stop
Email
Resubmit Error Instance From OIC
Resubmitting the Error Instances in Oracle Integration Cloud
In this integration, all processes are asynchronous, so the resubmit option is in Oracle Integration Cloud if the process ends in a fault.
To resubmit the error instances in Oracle Integration Cloud:
1. Login to Oracle Utilities Work and Asset Management.
2. Navigate Integrations > Monitoring > Errors.
3. Select the integration to resubmit.
4. Click the Resubmit icon.
Reprocess Chart of Accounts (COA) File
To reprocess the Chart of Accounts (COA) file:
1. Navigate to Oracle UCM.
2. Make sure the filename of the Chart of Accounts file to reprocess is FIN_COA_WACS. If it has been renamed to ERROR-FIN_COA_WACS, manually change the filename to FIN_COA_WACS so the COA Sync Process will pick up the file again.
3. Login to Oracle Integration Cloud.
4. Navigate to Integrations > Integrations.
5. Navigate to Oracle Utilities ERPFIN WACS ChartofAccounts Sync integration and click Run.
6. Click Submit Now to display the Schedule Parameters.
7. Click Submit.