Oracle SaaS FSM Object Type - Lookups

Lookups are one grouping of Setup Tasks. Make use of the Lookups object type to export and import individual Lookups by Lookup Type. This is available @since 5.7.0.2.

Object Type Identification

  • When populating files from source control management (SCM), FlexDeploy will classify all zip files containing "SetupTasks/Lookups" (case-insensitive) in their path as a Lookup. 

File Extensions

  • .zip

Object Type Code

LOOKUPS

Attributes

NameCodeDescriptionDefault ValueSupported Values
Task CodeTASK_CODEUnique id for Setup Task

Lookup TypeLOOKUP_TYPEThe 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

Related Project Properties

NameCodeDescriptionDefault ValueSupported Values





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.

How to find Task Code for a Setup Task?

To initiate the export or import process, Oracle endpoints requires providing a code for the task. Following these instructions to find the Task Code. We are assuming you have access to FSM resource.

  1. Click Navigator > My Enterprise > Setup and Maintenance.
  2. In the Setup and Maintenance work area, click Manage Setup Content from the Tasks panel tab.

  3. To search for the code of a task

    1. On the Manage Setup Content page, click Manage Task Lists and Tasks.
    2. In the Search field, select Tasks and click Search.

    3. In the search results, click the name of the task.

    4. On the Task page, look for value that appears against Code.

    5. Copy the code and use it where necessary

Permissions

During deployment, Lookup Types must be read, created, and/or updated via a REST service. Each LookupType will have a REST Access Secured settings. See the below table for possible values and potential actions to take if your Lookup Type has a restricted access level.

Rest Access Secured
Action Required
Description
AnonymousNoLookup will be available to anonymous-role and authenticated-role
AuthenticatedYes

Lookup will be available to an authenticated-role.

SecuredYes

Lookup will not be available at all in the generic resources. A separate resource will need to be created and secured to the correct roles using function security.

Example Task where REST Access Secured value can be viewed.

The following macros are not currently supported in the footer:
  • style