Configuring Admin Data
To configure the Oracle Utilities Customer Cloud Service setup for the integration:
1. Login to Oracle Utilities Customer Cloud Service.
2. Define the Journal Categories in algorithm C1EXGLFCREC to be used for the GL Extract. Refer to the
Algorithm section for details.
3. Define the Characteristic Values to be used for GL and AP Extracts. Refer to the
Characteristic Values section for details.
4. Define the Characteristics in CIS Division to be used for GL and AP Extracts. Refer to the
CIS Division section for details.
Algorithm
Define the Journal Categories in Algorithm C1EXGLFCREC. The parameter values for the different journal categories must be a valid value in Manage Journal Categories Setup Task page in Oracle E-Business Suite for General Ledger and Accounts Payable.
Characteristic Values
To define the Characteristic Values for the following Characteristic Types:
• For General Ledger Characteristic Type: Define the Ledger ID for the journal entries data to be used for the GL Extract integration. The Ledger ID provided must be a valid value in Manage Primary Ledgers page in Oracle E-Business Suite for General Ledger and Accounts Payable.
Characteristic Type: GLEDGER
Characteristic Value: Valid Ledger ID in Oracle E-Business Suite for General Ledger and Accounts Payable
• For Journal Source Characteristic Type: Define the Journal Entry Source Name to be used for the GL Extract integration. The Journal Entry Source provided must be a valid value in the Manage Journal Sources Setup Task page in Oracle E-Business Suite for General Ledger and Accounts Payable.
Characteristic Type: C1-JNLSC
Characteristic Value: Valid Journal Entry Source Name in Oracle E-Business Suite for General Ledger and Accounts Payable
• For Business Unit Characteristic Type: Define the Business Unit to be used for the AP Extract integration. The Business Unit provided must be a valid value in Oracle E-Business Suite for General Ledger and Accounts Payable.
Characteristic Type: EBSORGID
Characteristic Value: Valid Business Unit in Oracle E-Business Suite for General Ledger and Accounts Payable
CIS Division
Create a new CIS Division or use an existing CIS Division for the business. Define the following characteristics needed for this integration:
• General Ledger Characteristic Type, Characteristic Value: Valid Journal Entry Source Name in Oracle E-Business Suite for General Ledger and Accounts Payable
• Journal Source Characteristic Type, Characteristic Value: Valid Journal Entry Source Name in Oracle E-Business Suite for General Ledger and Accounts Payable
• Business Unit Characteristic Type, Characteristic Value: Valid Business Unit in Oracle E-Business Suite for General Ledger and Accounts Payable
Feature Configuration
Create a new feature configuration for Feature Type Financial Transaction Options. If one already exists, update the existing feature by adding the option type mentioned below.
To create a new feature configuration:
1. Navigate to the Feature Configuration page from the Admin menu or from the Search menu.
2. Enter a unique feature name and description.
Example: Name = FINCONF, Description = Financial Transaction Options
3. Set the Feature Type field to Financial Transaction Options.
4. In the Options Collection field, add:
• Option Type = Adjustment Cancel Reason For A/P Request Cancellation
• Sequence = 1
• Value = Valid Adjustment Cancel Reason Code
Note: When sending an adjustment cancellation to Oracle Utilities Customer Cloud Service and the adjustment cancel reason is not provided, it will get the default from this option.