Import Mappings
Click Tools Import Management Import Objects . Click the Object link to navigate to the Manage Mapping page.
You can create a mapping by clicking the Create Import Mapping button. For more details about creating a mapping, refer to the topic Create Import Mappings. Click the mapping you created to navigate to the Edit Import Mapping page where you can edit your mapping.
The Edit Import Mapping page contains the following sections:
-
Source File
-
Target Attributes
Source File
Here are the details related to columns provided in the source file:
|
Source Column |
Description |
|---|---|
|
Column Header |
The column name expected in the source file. |
|
Example Value |
Values from the first data row in the source file. |
|
Attribute Display Name |
Represents the target attribute that's to be mapped to the source column. |
|
Select Source File |
Use this button from the Action menu to import mapping from a source file. |
|
Delete Column |
Use this button from the Action menu to delete a column from the mapping file. This option is enabled only when at least one column is added to the Source File section. |
Target Attributes
Here are the details related to corresponding attributes in the target application table:
|
Target Attributes |
Description |
|---|---|
|
Target Attribute |
The attribute name that represents the corresponding table column for the object. |
|
Required |
Indicates whether the target attribute is a user key or a required key. |
|
Default Value |
Default value for the attribute if any. |
|
Description |
Provides a brief description of the attribute. |
For more information on how to import your data, see the object-specific import topics in the chapter Import Your Data. These topics are titled Import Your <Object-Name> Data. They provide the following information about importing data:
-
How to map your source data to Oracle Applications Cloud object attributes. This way the import process would know where to insert each of the information bits.
-
Required attributes and validations for the object.
-
How to create the source CSV file with the data you want to import.
-
How to kick off an import activity.
-
How to check the import results to know if the import went well.