Integration Schema
The integration requires a database to host the required integration schema. This schema can be created in any of the following:
• An integration database, if one exists.
• As part of the Oracle Utilities Customer Care and Billing database.
• As part of another database as determined by your specific technical needs.
The tables listed here are created in the integration schema defined during installation, for the purpose of this integration product.
Note: The integration does not require any database objects to be added to Oracle Utilities Customer Care and Billing or Oracle E-Business Suite Financials for General Ledger and Accounts Payable databases other than the objects mentioned here.
The following database tables are required to operate the Oracle Utilities Customer Care and Billing process integration for the Oracle E-Business Suite Financials for General Ledger and Accounts Payable Financials product:
Table Name
Description
INTEGRATION_LOOKUP_TABLE
A lookup table to store all the configuration parameters used by the integration processes. This table is also used to configure the email addresses to be notified if errors occur. This table is seeded with data at the time of integration product installation.
INTEGRATION_PROCESS_ACTIVATION
This table is used to activate or de-activate various integration points available in the Integration product. This table is seeded with data at the time of integration pack installation and is by default populated to activate all the available integration points in the product.
INTEGRATION_ERROR_STORE
The table is used to hold the information regarding the errors encountered during integration transactions. A record is inserted for each error encountered by the integration process. The MailNotification process, accesses this table to get the error information needed to construct the notification email. This table is delivered with no data.