Load Interface File for Import Process

Use the Load Interface File for Import scheduled process when you need to import external setup or transaction data from your CSV files into the interface tables. The process prepares the data for import into application tables.

Run this process from the Scheduled Processes page. You can run it on a recurring basis.

When to Use

Use this scheduled process when you load data from the CSV files into the interface table that corresponds to the template that you use to prepare the data.

Before running this process, you must complete these steps:

Prepare your data file. For details, see File Import Templates.
Create the import file. For details, see Use Excel Integration Templates to Generate Data Files.
Transfer the data file to the content repository. For details, see Transfer Data Files to UCM Using Manual Flow.

Privileges Required

Privileges are granted to duty roles, which are granted to job roles. To see which job roles inherit the required privileges, use the Security Console or see Security Reference for Financials and Security Reference for Common Features.

Specifications

Use these specifications when you run the scheduled process.

Specification	Description
Job Type	We recommend that you use Scheduled, but you can also run it on demand, when needed.
Frequency	There are no constraints.
Time of Day	Run it when your system isn't processing a lot of transactions.
Duration	Not applicable.
Compatibility	None.

Parameters

The Import Process parameter and the Data File parameter are required. Set the parameters, as necessary.

Parameter	Description
Import Process	Select the target import process.
Data File	Do these steps. Click the down arrow in the Data File attribute. Scroll down, then click Upload a New File. In the Upload File dialog, click Select File. In your Windows Explorer window, locate and select the .zip file that you created when you used the Price List Import Template, then click Open. In the Upload file dialog, click OK. In the Process Details dialog, make sure the Data File attribute displays the name of the .zip before you continue.

Parameter

Description

Import Process

Select the target import process.

Data File

Do these steps.

Click the down arrow in the Data File attribute.
Scroll down, then click Upload a New File.
In the Upload File dialog, click Select File.
In your Windows Explorer window, locate and select the .zip file that you created when you used the Price List Import Template, then click Open.
In the Upload file dialog, click OK.
In the Process Details dialog, make sure the Data File attribute displays the name of the .zip before you continue.

Troubleshooting Information

See:

Correct Import Load Process Errors