1. Implementing Applications
  2. File Format for Importing Lookups

File Format for Importing Lookups

You can import lookups to your application by creating separate text files containing lookup types and lookup codes. You can then upload these files to the Oracle WebCenter Content document repository.

Here are a few things that you need to keep in mind while creating these files:

  • Use a vertical bar or pipe ( | ) as a delimiter between fields for both the header and the value rows.
  • According to the Oracle WebCenter Content specification, set the file encoding to UTF-8 without the Byte Order Mark (BOM).
  • The first line in the file must be a header line, and the files must look exactly the same as shown in the sample file.

The following sections contain details about the specific lookup types and codes.

Prerequisite

You must have worked with lookups in Oracle Fusion Cloud applications.

Standard and Common Lookups

The lookup types and codes are similar for standard and common lookups. To create a file containing the lookup types, include the following headers:

Header Description Required or Optional
LookupType This value displays the lookup type. Required
Meaning This value displays the name of the lookup type. Required
Description This value displays the description of the lookup type. Optional
ModuleType This value displays the module associated with the lookup type. Required
ModuleKey This value displays the module code. Required

Here's a sample file with the header values at the beginning of the file, followed by line entries of the two lookup types. For importing several lookup types, add more line entries in a similar format.

LookupType|Meaning|Description|ModuleType|ModuleKey
AFLOG_22APR_1|Log1|AFLOG_desc_1|APPLICATION|FND
PROD_22APR_2|Product1|PROD_desc_2|APPLICATION|FND

To create a file containing the lookup codes, include the headers specified in this table:

Header Description Required or Optional
LookupType This value displays the lookup type. Required
LookupCode This value displays the lookup code associated with the lookup type. Required
DisplaySequence This value displays the sequence in which the lookup code appears in the list of values. Required
EnabledFlag This value lets you enable or disable the display status of the lookup code:
  • Y: Enable the display status of the lookup code
  • N: Disable the display status of the lookup code
 Required
Meaning This value displays the name of the lookup code. Required
StartDateActive This value displays the beginning of the date range during which the lookup code is active and visible on the page. The format is dd/MM/yyyy. Optional
EndDateActive This value displays the end of the date range during which the lookup code is active and visible on the page. The format is dd/MM/yyyy. Optional
Description This value displays the description of the lookup code. Optional
Tag This value indicates any tag associated with the lookup code that you can use for a quick reference or retrieval of information. Optional
Seg This value displays the API name used for a global segment that you can define for the descriptive flexfield associated with the lookup. Optional
CONTEXT_ATTRIBUTE This value displays the context value specified in the CSV file for a particular descriptive flexfield. Optional
ctxSeg This value displays the name of the API for a context-sensitive segment defined for a context attribute. Optional

Here's a sample file that contains two lookup codes:

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag|Seg|CONTEXT_ATTRIBUTE|ctxSeg
TASK_22APR_1|Code1_1|1|Y|25/12/2014|25/5/2015|TASK_22apr_1|Task_desc_1|Tag1_1|testSeg1|TEST_CTX1|ctx1Seg1
TASK_22APR_1|Code1_2|2|N|25/1/2014|25/11/2015|TASK_22apr_2|Task_desc_2|Tag1_2|testSeg1TEST_CTX1|ctx1Seg1
TASK_22APR_2|code2_1|3|N|25/12/2012|25/7/2015|TASK_22qpr_2_1|Task_desc_2|tag2_1|testSeg2|TEST_CTX2|ctx2Seg2
TASK_22APR_2|code2_2|3|Y|25/12/2012|25/7/2015|TASK_22qpr_2_2|Task_desc_2_2|tag2_2|testSeg2|TEST_CTX2|ctx2Seg2

Set Enabled Lookups

To create a file containing the set enabled lookup types, include the headers specified in this table:

Header Description Required or Optional
LookupType This value displays the lookup type. Required
Meaning This value displays the name of the lookup type. Required
Description This value displays the description of the lookup type. Optional
ModuleType This value displays the module associated with the lookup type. Required
ModuleKey This value displays the module code. Required
ReferenceGroupName This value displays the name of the reference group that contains the reference data set. Required

Here's a sample that contains two set enabled lookup types:

LookupType|Meaning|Description|ModuleType|ModuleKey|ReferenceGroupName
CODE_22APR_1|CODE_22apr_1|Code_desc_1|APPLICATION|FND|BU_APAC
CODE_22APR_2|CODE_22qpr_2|Code_desc_2|APPLICATION|FND|BU_APAC

To create a file containing the set enabled lookup codes, include the headers specified in this table:

Header Description Required or Optional
LookupType This value displays the lookup type. Required
LookupCode This value displays the lookup code associated with the lookup type. Required
DisplaySequence This value displays the sequence position at which the lookup code appears in the list of values. Required
EnabledFlag This value lets you enable or disable the option to view the display:
  • Y: Enable the option to view the display
  • N: Disable the option to not view the display
 Required
Meaning This value displays the name of the lookup code. Required
SetName This value displays the name of the reference data set. Required
StartDateActive This value displays the beginning of the date range during which the lookup code is active and visible on the page. The format is dd/MM/yyyy. Optional
EndDateActive This value displays the end of the date range during which the lookup code is active and visible on the page. The format is dd/MM/yyyy. Optional
Description This value displays the description of the lookup code. Optional
Tag This value indicates any tag associated with the lookup code that you can use for a quick reference or retrieval of information. Optional

Here's a sample file with the header values at the beginning and lists four set enabled lookup codes. For importing several lookup codes, add more entries in the same format.

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag|SetName
DATA_22APR_1|Code1_1|1|Y|25/12/2014|25/5/2015|DATA_22apr_1|Data_desc_1|Tag1_1|TEST SET CODE 2
DATA_22APR_1|Code1_2|2|N|25/1/2014|25/11/2015|DATA_22apr_2|Data_desc_2|Tag1_2|TEST SET CODE 3
DATA_22APR_2|code2_1|3|N|25/12/2012|25/7/2015|DATA_22qpr_2_1|Data_desc_2|tag2_1|TEST SET CODE 2
DATA_22APR_2|code2_2|3|Y|25/12/2012|25/7/2015|DATA_22qpr_2_2|Data_desc_2_2|tag2_2|TEST SET_ERR_CODE_Z

Related Topics