Bulk Upload Lookup Types and Lookup Codes – Oracle Fusion ERP

Lookup Type File.

HeaderDescriptionRequired or Optional
LookupTypeThis value displays the lookup type.Required
MeaningThis value displays the name of the lookup type.Required
DescriptionThis value displays the description of the lookup type.Optional
ModuleTypeThis value displays the module associated with the lookup type.Required
ModuleKeyThis value displays the module code.Required
LookupType|Meaning|Description|ModuleType|ModuleKey
XXORA_LKP_003|003|XXORA_LKP_003 Description|APPLICATION|FND
XXORA_LKP_004|004|XXORA_LKP_004 Description|APPLICATION|FND

Lookup Code File

HeaderDescriptionRequired or Optional
LookupTypeThis value displays the lookup type.Required
LookupCodeThis value displays the lookup code associated with the lookup type.Required
DisplaySequenceThis 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 codeRequired
MeaningThis value displays the name of the lookup code.Required
StartDateActiveThis 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
EndDateActiveThis 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
DescriptionThis value displays the description of the lookup code.Optional
LookupType|LookupCode|DisplaySequence|EnabledFlag|Meaning|Description
XXORA_LKP_003|01|1|Y|One|One Description
XXORA_LKP_003|02|2|Y|Two|Two Description

Steps to perform Import

•Data file should be separated by ‘|’

•File extension should be preferably .csv

•Prepare and load the Lookup Type File into UCM

•Prepare and load the Load the Lookup Code File into UCM

•Manage Common Lookups à Action à Import

•Insert/Update are done for the lookup type and lookup values

•IF data file name is same, latest file is considered for processing

Upload Lookup Types

1.UCM Upload

2. File Import

Upload Lookup Values

1.UCM Upload

2.File Import

Validation From UI

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: Uncategorized