ERP Configuration for Account Payable Request

This section focuses on the import of the Payment request that come as a part of refund that needs to be made for Oracle Utilities Customer Cloud Service. Oracle ERP Financial Cloud provides functionality for importing all the payment line into the Accounts payable module. One Time Payment (OTP) is a method of entering vouchers and payments for a supplier that you do not need to add to the Address Book system.

Oracle Utilities Customer Cloud Service generates a data file based on the Payment request template in a comma-separated value (CSV) format. Oracle Utilities Customer Care and Billing on premise places the generated file on the server and Oracle Utilities Customer Cloud Service to Object Storage. The Oracle Integration Cloud flow picks file from Object Storage or server and places it in UCM.

• The file scheduled within Oracle ERP Financial Cloud from the UCM folder. This schedule process loads the data to AP_PAYMENT_REQUESTS_INT table.

• UCM account: fin/payables/import

Configuration Overview for AP

In addition to the setups to run Accounts Payable request in Oracle ERP Financial Cloud, for importing request with a specific source, we need to create a reference Source in Oracle ERP Financial Cloud.

AP Payment process request creates payment request data from payment data imported from Oracle and non-Oracle feeder systems. Once the records are stored in AP_PAYMENT_REQUESTS_INT, Importing Invoice program is schedule that creates the Invoice from above mentioned table.

One Time Payment feature

For one-time payment where supplier does not exist in the system, Oracle ERP Financial Cloud should be enabled for the feature.

1. Login to the system.

2. Navigate to Others > Setup and Maintenance > Financial.

3. Select Financial > Change Feature Opt In.

4. Click the Edit icon (pencil icon) against Payables.

5. Select the One Time Payment checkbox.

Payables Lookup Type

To identify payment request from the Source system, create the source in Oracle ERP Financial Cloud. This value is passed in CSV. A lookup is a way to provide validation (using list of values) for a user input field in a user interface. A typical example could be a field on UI form say Gender which might only allow values like 'Male' or 'Female'. The application would not allow any other value apart from the ones listed in the drop down list attached to the form field.

The different lookup types based on this classification are:

• Common Lookups: These are migrated from the Legacy Systems as is (they belonged to the Common Lookups Category in other ERP systems) and are provided to ensure backward compatibility is maintained. They are defined in the Common Lookup View.

• Standard Lookups: Standard lookups are the simplest form of lookup types consisting only of codes and their translated meaning. They are defined in the Standard Lookup View.

• Set-Enabled Lookups: Set enabled lookup types store lookup codes that are enabled for reference data sharing. At runtime, a set-enabled lookup code is visible because the value of the determinant identifies a reference data set in which the lookup code is present.

To create a payable lookup type:

1. Navigate to Others > Set up and Maintenance > Financial.

2. Select Financials > Payables > Manage Payables Lookups.

3. In the Lookup Type field enter “Source” and click Search.

4. Click “+”. Enter the Oracle Customer Care and Billing values.

5. Click Save and Close.

Manage Trading Community Source System

The existing Source lookup will link with the trading community system.

To manage trading community source system:

1. Navigate to Financials > Payables > Manage Trading Community Source System.

2. Click + to enter the following details.

Code: CCB

Name: CCB One time payment

Description: CCB One time payment

Enable for Trading Community Members: YES

3. Click Save and Close.

Accounts Setup

For One time payments, Oracle ERP Financial Cloud uses Liability and Expense account. Generally, if left blank, value of this field will be defaulted from the setup.

Enter default Liability and Expense accounts in the Manage Common Options for Payables and Procurement option.

All business units for which GL is imported should have accounts defined.

To set up accounts:

1. Navigate to Others > Set up and Maintenance > Financials > Payables > Manage Common Options for Payables and Procurement.

2. Enter the valid Account combination in Liability and Expense account.

3. Click Save and Close.

Default Location Setup

For One-time payment, business unit used in the import template should have a default location in the Manage Business Unit setup.

To create the default location setup:

1. Navigate to Others > Set up and Maintenance > Financials > Organization Structures > Manage Business Unit.

2. Select the Business Unit.

3. Enter the Location.

4. Click Save and Close.

Scheduling the Payment Process Request

Select the file from UCM that loads the records to the interface table. For the records to transfer to journal, Oracle ERP Financial Cloud needs to run Payment Process Request.

To schedule to run over time as per business requirement:

1. Navigate to Tools > Scheduled Processes.

2. Select the report from the Name list. Select Import Payables Payments Requests.

3. Click OK.

4. Enter the Source.

5. Click Advance > Schedule.

6. Enter the Schedule details. Select the Frequency and Start Date. Click Submit.