While reviewing the legacy data that was exported into a flat file, you realize that there is a certain
field that contains irrelevant data. Which method describes how the field is handled during the
import process?
A.
Create the custom field in Fusion and map the data to the field, but do not display the field in
the GUI.
B.
Select the ignore check box next to the field when you create the mapping.
C.
Click the Delete icon for the field when you create the mapping.
D.
Open the flat file in a text editor, and manually delete the data in each row for the appropriate
field.
E.
Enter a constant value for the field during the import process.
Explanation:
Source File Options
Map each column that the source file is expected to contain with a specific attribute.
The following table describes the details pertaining to columns provided in the source file:
Source Column, Description
* Sequence
The sequence number in which the columns are expected to be provided in the source file. Two
rows cannot have the same sequence number.
* Column Name
The column name expected in the source file if a header row is included, or more generic values
such as Column A, Column B, and so on, if the header row is not included for Text file types.
The tagging structure is represented for XML file types.
Column Width
Use when the delimiter value is fixed width for Text file types only.
* Ignore
Ignore the source file column to exclude the data from being imported.
* Required
If selected, a value must exist in the source file or the row will not be imported.Explanation/Reference: Oracle Fusion Applications Sales Implementation Guide, Source File Options