ERP Connection Name

Enter a unique name for the ERP connection. (Mandatory)

Description (Optional)

Provide any important details about this ERP connection. (Optional, but recommended)

User

The name of the user needed to connect to the Oracle Financials Cloud ERP system. This user must have privileges to perform required function in Oracle Financials Cloud, such as creating invoices, reading suppliers and purchase orders, etc. (Mandatory)

Password

The password needed to connect to the Oracle Financials Cloud ERP system. (Mandatory)

System URL

The URL to connect to the Oracle Financials Cloud ERP system. (Mandatory)

Distribution Combination Template

This specifies the data from Kofax AP Agility that you want to use for the distribution combinations in Oracle Financials Cloud. (Mandatory)

You can use a plain-text fixed value or a variable enclosed in percent characters (%). (Default: %$BuyerExternalId%-%AccountCode%)

Distribution Combination Separator

This value should match the delimiter that is configured in Oracle Financials Cloud. (Default: -)

The Distribution combination template setting and the Distribution Combination Separator setting work together. If you modify the separator it is necessary to modify the template. If you modify the template using another separator, the connection does not work.

EU Countries

The list of countries that are members of the EU or that use the same rules for taxes as EU countries. (Default: AT, BE, BG, CY, CZ, DE, DK, ES, EE, FI, FR, GB, GR, HR, HU, IE, IT, LT, LU, LV, MT, NL, PL, PT, RO, SK, SI, SE)

Use Default PO Header Status

When selected, the default PO header status is used. (Default: Selected)

When selected, all invoices with one of the following statuses are returned: OPEN, CLOSED FOR RECEIVING, CLOSED.

Custom PO Header Status

This is a comma-separated list of purchase order statuses supported by Oracle Financials Cloud. Example statuses include INCOMPLETE, OPEN, CLOSED FOR RECEIVING, or CLOSED.

If values are defined for this setting and the Use default PO Header status setting is selected, these entries are ignored.

Payment and Invoice Currency are Same

AP Agility is only able to handle one type of currency. However, in Oracle Financials Cloud it is possible to have two types of currency; InvoiceCurrency and PaymentCurrency. (Default: Cleared)

When this setting is selected, the extracted currency value from is AP Agility used for both InvoiceCurrency an PaymentCurrency.

When this setting is cleared. only the InvoiceCurrency is populated from the extracted value from AP Agility

Always Try to Validate Invoice

When selected, the validation process runs in Oracle Financials Cloud. (Optional)(Default: Selected)

There is a sequence of requests to Oracle Financials Cloud to validate an invoice. This includes calculating taxes, updating the total amount of the invoice if it has changed because of taxes, updating invoice installments, and then validating the invoice again. This can take a long time so it may be preferable to manually validate invoices in Oracle Financials Cloud instead of , calculate taxes, update the total amount of the invoice if it has changed because of taxes, update invoice installments, and then re-validate the invoice. These requests take time, so there is a

Show Mapping to DFF

If selected, additional invoice descriptive Flexfields are available for configuration. (Default: Cleared)

Descriptive Flexfields in Oracle Financials Cloud consist of several segments. When importing an invoice, Kofax AP Agility uses global segments that are visible without any conditions only. There can be one descriptive Flexfield per invoice header and that DFF can have several segments.

The custom fields must be mapped to the API name of the segments in the Kofax AP Agility ERP system.

The configured custom fields must be activated in the Settings > Invoice Processing > Capture Profiles > Field Settings.

Custom1

Populate with an invoice descriptive Flexfield. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

Custom2

Populate with an invoice descriptive Flexfield. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

Custom3

Populate with an invoice descriptive Flexfield. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

Custom4

Populate with an invoice descriptive Flexfield. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

Custom5

Populate with an invoice descriptive Flexfield. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

LineItems.Custom1

Populate with an invoice descriptive Flexfield line item. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

LineItems.Custom2

Populate with an invoice descriptive Flexfield line item. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

LineItems.Custom3

Populate with an invoice descriptive Flexfield line item. (Optional)

This setting is available only when the Show mapping to DFF setting is selected.

LineItems.Custom field for ShipToLocation

When selected, you can use one of the LineItems.Custom fields to set the Ship To location. Enter "ShipToLocation" into the chosen line item custom field.

This setting is available only when the Show mapping to DFF setting is selected.

Page Size

A positive integer that indicates the number master data records that are returned by the ERP connection for each call. (Mandatory)

Start Data Load From

Set the date for when you want to start loading information from the ERP system. (Mandatory)

Start Data Load To

Set the date for when you want to stop loading information in Kofax AP Agility. The interval between this and the Start Data Load From value indicate what is considered old and new data.

Use Default Null Values For Data Import

Converts any values that are equal to "NULL," "Null," or "null" into actual null values when the data is imported. (Default: Selected)