New Features Summary

The following enhancements are included in this integration release:

• Oracle Utilities BI ERP FIN for CCS-ERPFIN Connection

• Oracle Utilities REST Trigger for CCS-ERPFIN Connection

Batch Payments Integration

This integration process is used to send Batch of AP Refund Request Payments information from Oracle ERP Financial Cloud to Oracle Utilities Customer Cloud Service.

The Batch of Payments information for system-generated checks to customers is generated when the submit payment process request is processed in Oracle ERP Financial Cloud and then sent to Oracle Utilities Customer Cloud Service. Only payments information that corresponds to the AP refund requests originally generated in Oracle Utilities Customer Cloud Service are sent back. The integration process updates the original AP Request in Oracle Utilities Customer Cloud Service with the details of the payment including the payment status, check number and date.

This integration includes:

• Subscribe to Payables Payment File Created Event. Oracle ERP Financial Cloud sends a signal, along with the Account Payable (AP) payment information when Submit Payment Process Request is created in the application. The integration process will only accept payments with Payment Method = 'CHECK_CCB'. This criteria is used to identify payments made to Oracle Utilities Customer Cloud Service specific payables.

Note: This payment method must exist in Oracle ERP Financial Cloud. When sending AP Request from Oracle Utilities Customer Cloud Service, payment method of the Payables record must be 'CHECK_CCB'.

• The Payment File Reference Number received from the business event does not return the Paid Invoice Number. Invoke the Oracle ERP Financial Cloud BI Report to get the all the paid invoices details.

• For each Invoice Payment:

• Transform the payment information payload from Oracle ERP Financial Cloud format to the Oracle Utilities Customer Cloud Service format.

• Invoke the Oracle Utilities Customer Cloud Service REST API - AP Check Request to pass the payment information to Oracle Utilities Customer Cloud Service.

Batch Void Payments Integration

• This integration process is used to update the Oracle Utilities Customer Cloud Service AP Refund Request Payment status to 'canceled' status when a batch of payments are voided in Oracle ERP Financial Cloud using Manage Payment Files.

• Only voided payments that correspond to the AP refund requests originally generated in Oracle Utilities Customer Cloud Service are sent back. The integration process updates the original AP Request in Oracle Utilities Customer Cloud Service with the canceled status.

• This integration includes:

• Payables payments are voided in Oracle ERP Financial Cloud with the Account Payable Manage Payment File. The integration process will only accept void payments with Payment Method = 'CHECK_CCB'. This criteria is used to identify payments made to Oracle Utilities Customer Cloud Service specific payables.

Note: This payment method must exist in Oracle ERP Financial Cloud. When sending AP Request from Oracle Utilities Customer Cloud Service, the payment method of the Payables record must be 'CHECK_CCB'.

• The integration runs on schedule basis which will invoke the BI Report with the LastRunDateTime.

• BI Reports returns all the voided invoice details with the UpdatedDateTime > LastRundateTime.

• For each Invoice Payment:

• Transform the Payment Data from Oracle ERP Financial Cloud to the Oracle Utilities Customer Cloud Service format.

• Invoke the Oracle Utilities Customer Cloud Service REST API - AP Check Request to change the status of the AP request to 'canceled' status in Oracle Utilities Customer Cloud Service.

Batch Data Extractor OIC Flow

This integration process is used in Account Payable Batch Payment Process and Account Payables Batch Void Payment Process. It is used as an abstract process to invoke ERP Financials BI Reports.

This integration includes:

• Payables Payments Paid or Voided in Oracle ERP Financial Cloud. The integration process will only accept payments/void payments with Payment Method = 'CHECK_CCB'. This criteria is used to identify payments made to Oracle Utilities Customer Cloud Service specific payables.

• Note: This payment method must exist in ERP. When sending AP Request from Oracle Utilities Customer Cloud Service, the payment method of the Payables record must be 'CHECK_CCB'.

• The integration is invoked from AP Data Batch Payment/AP Data Batch Void Payment integrations.

• It will invoke the Payment or Void Payment BI Reports based on the ReportType Parameter.

• If the Input ReportType value is "Payment", it will invoke the Payment Report.

• If the Input ReportType value is "VoidPayment", it will invoke the Void Payment Report.

• Process the BI Report data and send back to the corresponding called integration.

Oracle Utilities BI ERP FIN for CCS-ERPFIN Connection

This connection is used to communicate with Oracle ERP Financial Cloud External BI Report using the SOAP adapter and this connection is used in following integration.

• Oracle Utilities ERPFIN CCS Data Extractor

Oracle Utilities REST Trigger for CCS-ERPFIN Connection

This connection is used to communicate with Oracle Integration Cloud local Integrations. Configure the Oracle Utilities REST Trigger for CCS- ERPFIN connection and this integration is used in following integration.

• Oracle Utilities ERPFIN CCS Data Extractor