Technical Overview
This is a direct integration between Oracle Utilities Customer Care and Billing and Oracle E-Business Suite.
• This integration use two types of end-to-end integration processes: Asynchronous and Synchronous.
• Most of the integration processes interact with edge applications using data base adapters except for CCBCancellationWebService process where it invokes the Oracle Utilities Customer Care and Billing webservice. These integration processes extract data from source application data base tables and convert the data extracted from source data base table into an xml format.
• Then the source XML data is transformed into target application format using XSLT.
• Transformed data is inserted into target application data base tables.
• When the target system receives this data, it validates and converts imported data into the appropriate format of entries in the target application.
• In case of any error in the process, the error data is inserted into INTEGRATION_ERROR_STORE table and an optional email notification is sent based on the configuration.
• For the main integration processes extension callouts have been provided.
• The pre- and post-extension scopes are executed based on the extension flags enabled in INTEGRATION_LOOKUP_TABLE.
• The extension point flags are defaulted to ‘false’ in INTEGRATION_LOOKUP_TABLE table.
The following table shows the integration points, source and target applications, tables, and process used to load the data that is imported from the other system:
Integration Points
Source System
Target System
Process
Target Table
General Ledger
CCB
EBS
Journal Import
GL_INTERFACE
AP Request
CCB
EBS
Payables Open Interface Import
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP Data
EBS
CCB
 
The appropriate AP Request within Oracle Utilities Customer Care and Billing.