Upload Comma-Separated Values File for Import Process

This process uploads a flat file containing comma-separated values for various artifacts, such as flexfields, messages, lookups, and so on. You can use this process to add setup data for these artifacts or update existing ones.

Before running this process, you must create the flat file in the given format and upload it to the content repository using the File Import and Export work area. To run this process, use the Scheduled Processes work area and specify the required parameters.

Note:

Here are some alternate ways of doing this task:

Using the File Import and Export page. For more information, see Export and Import of CSV File Packages.
Using the SOAP web services or REST APIs. For more information, see the Value Sets REST Endpoints section in the REST API for Common Features in Oracle Fusion Cloud Applications guide.

Parameters

Flat File Name

Enter the name of the file you uploaded using the File Import and Export page.

Account

Enter the user account containing the file in the content repository to upload.

File Type

Select the file type for the file you uploaded using the File Import and Export page.

Here are the supported file types and the corresponding file formats and examples for various application artifacts.

Artifact	File Type	File Formats and Examples
`ValueSet`	VALUE_SET	File Format for Importing Value Set and Value Set Values
`Value Set Values`	VALUESET_VALUES	File Format for Importing Value Set and Value Set Values
`Related Value Set`	RELATEDVALUESET	File Format for Importing Related Value Sets
`Related Value Set`	RELATEDVALUESETVALUES	File Format for Importing Related Value Sets
`Messages`	MESSAGES	File Format for Importing Messages
`Messages`	MESSAGE_TOKENS	File Format for Importing Messages
`Lookups`	STANDARD_TYPE	File Format for Importing Lookups
	COMMON_TYPE
	SETID_TYPE
	COMMON_CODE
	STANDARD_CODE
	SETID_CODE
`Profiles`	PROFILE_OPTIONS	File Format for Importing Profile Values
	PROFILE_CATEGORIES
	PROFILE_CATEGORY_OPTIONS
	USER_PROFILE_VALUES
`Descriptive Flexfields`	DFF_CONTEXT	File Format for Importing Descriptive Flexfields
	DFF_LABELED_SEGMENT
	DFF_SEGMENT
`Extensible Flexfields`	EFF_CONTEXT	File Format for Importing Extensible Flexfields
`Extensible Flexfields`	FileEFF_CONTEXT_SEGMENT	File Format for Importing Extensible Flexfields
`Data Security Objects Data`	DS_OBJECTS	File Format for Importing Data Security Instance Sets and Grants
	DS_CONDITIONS
	DS_ACTIONS
	DS_GRANTS
`Document Sequence Data Loaders`	DOCUMENT_SEQUENCE_CATEGORY	File Format for Importing Document Sequences
	DOCUMENT_SEQUENCE
	DOCUMENT_SEQUENCE_ASSIGNMENT
`Hierarchies Data Loaders`	HIERARCHYNODE