7Manage Import Objects

This chapter contains the following:

Import Objects correlate with the tables in Oracle Applications. Understand import objects and their attributes to manage the data that you want to import.

Import Object Details

Click Tools > Import Management > Import Objects. To see the details of an import object, select it on the Import Object Details page. Here are the details that you see about each importable object.

Column Description

Display Name

The object as it's called in the User Interface.

Language Independent Code

The internal name of the object.

Parent Object

The parent object of the selected object. If there are multiple parents for an object, they're shown separated by comma.

View Hierarchy

Clicking on the View Hierarchy icon shows the hierarchy between the parent and child objects in a graphical format.

User Key

The attribute or the group of attributes that's used to uniquely identify a record.

Required Attributes

The attribute or the group of attributes for which values are required to create a record. These can't be NULL when updating a record.

Description

A short description of the object.

Download

Link to download the template files for each object and its child objects.

Target Attributes

Here are the details that you see for each target attribute.

Column Description

Display Name

Name of the target attribute in the User Interface.

Attribute Name

Internal or field name of the attribute.

Required

Indicates whether the attribute is mandatory or not.

Default Value

The default value for the attribute, if any.

Type

Data type of the target attribute.

Length

Maximum allowed length for the target attribute values.

Description

A short description of the target attribute.

This topic tells you how to download an import template for an object, such as account, and use it as a source file to import data. Templates make it easy for you to use the automapping feature. For automapping to work, the column headers in the source file must match the names of the columns (attributes) of the objects imported. The column headers shown in the first row of the downloadable templates are the same as the column names of the corresponding objects. Therefore, building source files from the templates allows the automapping process.

For example, if your source file has a column "URL" then it's mapped to the Account URL column. However if your source file's column header is "Website", then automapping fails and you should map manually.

Download the Import Object Templates

To download an import object template:

  1. Click Tools > Import Management > Import Objects.

  2. On the Manage Import Objects page, click the Download icon for the object, such as account, for which you want to download the template.

The next section explains the procedure to update the template to import data.

Populate the Import Templates

Extract the contents of the ZIP file to a folder. The extracted folder contains the template text files for each of the parent and child objects. The readme text file within the folder contains instructions on how to use the template files to create source file for importing data. Here are the steps to import data using the downloaded template:

  1. Open the CSV template file for the object you want to import.

    The file for each object contains two rows. The first row contains all the column names in a format that's compatible with the automatic mapping functionality. The second row contains the display names as shown on the import mapping user interface.

  2. Before populating the CSV template file with the data to be imported, delete the display name values in the second row, and populate the columns with the data to import.

  3. Use the updated file as the source when you're creating an import activity on the import user interface. For more details on the import process, see the topic Import Data in the related links section.

The automatic mapping functionality maps all the columns automatically. You can see both the mapped column names and the corresponding column names in your language on the Map Fields page.