Configuring Admin Data

To configure Oracle Utilities Customer Cloud Service admin data 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.

5. Update Financial Transaction Options. Refer to the Feature Configuration 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 ERP Financial Cloud.

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 ERP Financial Cloud.

Characteristic Type: GLEDGER

Characteristic Value: Valid Ledger ID in Oracle ERP Financial Cloud

• 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 ERP Financial Cloud.

Characteristic Type: C1-JNLSC

Characteristic Value: Valid Journal Entry Source Name in Oracle ERP Financial Cloud

• 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 ERP Financial Cloud.

Characteristic Type: EBSORGID

Characteristic Value: Valid Business Unit in Oracle ERP Financial Cloud

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 ERP Financial Cloud

• Journal Source Characteristic Type, Characteristic Value: Valid Journal Entry Source Name in Oracle ERP Financial Cloud

• Business Unit Characteristic Type, Characteristic Value: Valid Business Unit in Oracle ERP Financial Cloud

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.

For 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.