Overview of the Integration
Oracle Utilities Customer Cloud Service Integration to Oracle E-Business Suite for General Ledger and Accounts Payable helps to facilitate the transfer of refund and ledger information between the two applications.
This integration supports three key functionalities:
• Sends General Ledger information for bills, payments, adjustments, and cancellations from Oracle Utilities Customer Cloud Service to Oracle E-Business Suite for General Ledger and Accounts Payable for journal creation.
• Sends payable refund payment request from Oracle Utilities Customer Cloud Service to Oracle E-Business Suite for General Ledger and Accounts Payable for invoice creation.
• Once the payable request has been paid or void in Oracle E-Business Suite for General Ledger and Accounts Payable, the payment status and information are sent back to Oracle Utilities Customer Cloud Service.
General Ledger Integration
The objective of General Ledger interface is to integrate the General Ledger transactions originating in Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing with Oracle E-Business Suite - General Ledger. As Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing users take actions within the application that necessitates sending the accounting entries to Oracle E-Business Suite, this interface extracts the General Ledger transaction data from Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing, translate it and move it to cloud as Journal voucher transactions in the General Ledger.
This integration includes:
• Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Initiated: Batch process “GLASSIGN” is mandatory to run for this integration that helps to populate GL account of the financial transaction of General Ledger.
• Batch “GLS” is processed after assigning the General Ledger account that moves the appropriate General Ledger transactions to staging table in Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing.
• Batch process “C1-GLFCX” in Oracle Utilities Customer Care and Billing extracts all General Ledger transaction and load the zip file to object storage.
• Batch process “C1-GLFCX” in Oracle Utilities Customer Cloud Service extracts all General Ledger transactions and loads the zip file to file path location.
• Financial interface procedure(s) to pick up transaction information from the interface table and import the data into Financial General Ledger.
• The data imported into Oracle E-Business Suite will be posted by submitting the Posting Journal Program as per the business process.
• Verification of data can be done in Oracle E-Business Suite before making the posting.
• All the transaction are based on the existing code combinations interfaced by Oracle E-Business Suite system. Any correction or changes in the transaction would be new transaction to adjust the values (if needed).
Benefits of General Ledger Integration
The benefits of General Ledger integration are:
• Reporting Center for Oracle Utility to Oracle E-Business Suite for General Ledger and Accounts Payable.
• Central repository for accounting data transferred from all sub ledgers, such as accounts payable, accounts receivable, cash management, fixed assets, purchasing and projects.
Account Payable (Request)
• Oracle E-Business Suite for General Ledger and Accounts Payable receives requests from internal or external sources to disburse funds to payees that are not defined as suppliers. Payables records these requests as payment requests.
• Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing Payment requests are imported in the Payables Open interface tables: AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.
• To import the payment request to production tables, run the Payables Open Interface Import request and enter the required parameters.
One Time Payments are:
• Typically, these payment requests originate from external systems.
• Refunds to customers from an external billing system which is integrated with Oracle through Accounting Hub or General Ledger, and not through Oracle Receivables.
This integration includes:
• Oracle Utilities Customer Cloud Service Initiated: For the integration to work, batch process “C1-APFCX” is required to run in Oracle Utilities Customer Cloud Service that extracts all appropriate Adjustment transaction requests for refund from Oracle Utilities Customer Cloud Service.
• The above batch process in Oracle Utilities Customer Cloud Service extracts the AP request in CSV format and loads the zip file to object storage.
• The “C1-APFCX” batch process in Oracle Utilities Customer Care and Billing extracts the AP request in CSV format and loads the zip file to File Path for on-premises.
• EBS Flow: Batch process “Load to Interface” to pick up the transaction data from the file stored either in Oracle Object Storage or in SFTP location, insert the information into an Oracle E-Business Suite interface tables and invoke invoice creation data into the Oracle E-Business Suite Payables application.
• The data imported into Oracle E-Business Suite Payables creates Invoice with header and line details.
• Verification of data is done in Oracle E-Business Suite before making the payment.
Account Payable (Data)
• For the refund request invoice created, the payment details are sent from Oracle E-Business Suite for General Ledger and Accounts Payable to Oracle Utilities Customer Cloud Service/Oracle Utilities Customer Care and Billing.
• Oracle Integration Cloud gets the details of paid invoice through custom REST API and transforms into Oracle Utilities Customer Cloud Service load.
• Updates payment information and payment status for the adjustment in Oracle Utilities Customer Cloud Service.
• Passes the payment or void information and payment status for the account payment request from Oracle E-Business Suite to Oracle Utilities Customer Cloud Service.
• For information about the configuration to be performed in Oracle Utilities Customer Cloud Service and Oracle E-Business Suite for General Ledger and Accounts Payable for the integration, refer to Configuring Oracle Utilities Customer Cloud Service and Configuring Oracle E-Business Suite respectively.
• Integration updates the following payment information for each Adjustment AP Request record using a business event:
• A/P Request ID (Primary Key)
• Payment Status
• Payment Date
• Payment Method and Number
• Payment Amount and Currency