ERP Connection: Oracle Financials Cloud
This form is available only if you have imported the KofaxAPAgilityERPConnector-1.0.0-For_OFC plugin.
Oracle Financials Cloud does not support one-time vendors.
Use the following settings to configure your Oracle Financials Cloud ERP connection:
Setting |
Description |
---|---|
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) Each time the AP Data Import process runs, the Start Data Load From date and time stamp is updated with the current date and time. This ensures that the entire ERP is not loaded each time, only the changes since the last import. |
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) |
Use the following buttons to manage your new ERP connection:
Button |
Description |
---|---|
Save |
Save the ERP connection and adds it to the table on the ERP Connections page. |
Close |
Closes the current page and returns to you to the ERP Connections page. If you click Close before saving your values, they are lost when you return to the ERP Connections page. |
Test |
Tests the connection to the SAP S/4HANA On-Premise ERP using the provided information. |