Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Lookups are one grouping of Setup Tasks. Make use of the Lookups object type to export and import individual Lookups by Lookup Type.

Object Type Identification

...

Name

Code

Description

Default Value

Supported Values

Task Code

TASK_CODE

Unique id for Setup Task

Lookup Type

LOOKUP_TYPE

The label for a static list that has lookup codes as its values. This can be found in FSM UI on any lookups setup task (IE. Manage Common Lookups).

FILE_NAME


Considerations

Source from Development Environment

In order to download file from an environment, you must configure file for Lookup as shown below. Note that File Name (with Path) should be entered first in format - /SetupTasks/Lookups/<TASK_CODE>/<LOOKUP_TYPE>.zip. File name is used as Lookup Type, and parent folder is used as Task Code. Task Code can be selected from drop down list if necessary. Also Lookup Type can be entered manually as well if necessary. Make sure to update File Name (with Path), respectively, if either of previous attributes are edited manually. Steps - Enter File Name in proper format, Click Evaluate, then click OK and eventually click Save to save configurations. Now you can add this file to Package and perform, export and import.

...

Source from SCM

The following convention is generally used for the File Name (with Path) in Source Code Repository. "/SetupTasks/Lookups/<TASK_CODE>/<LOOKUP_TYPE>.zip". If you follow these conventions, then you do not have to configure Files manually. You are ready to perform export and import using FlexDeploy package once files are discovered in FlexDeploy.

Task Code is derived from zip file sourced from SCM.

...

Export execution can fail if the artifact (CSV Packages files) contain no data or if the Lookup Type provided in the attributes does not exist on the source environment. First ensure the value for Lookup Type is valid and contains no spelling errors. If the error still persists, then you will need to try another Task Code appropriate for the Lookup Type you are managing. For example, take Manage Common Lookups (Task Code = FND_MANAGE_COMMON_LOOKUPS) and the Lookup Type of LOCATION_ADDRESS_USAGE_TYPE. If export were to fail, in that case Manage Location Lookups (Task Code is = PER_MANAGE_LOCATION_LOOKUPS) would make more sense.

...