Entering or updating a large volume of setup data using Functional Setup Manager (FSM) user interface (UI) can be taxing and repetitive. Even when the setup tasks are simple; downloading, uploading, and general management of the tasks using the setup task UI is not the most efficient method.

With FlexDeploy’s Oracle SaaS FSM plugin you can migrate setup data in bulk using CSV file packages. CSV File packages manage the setup data of a specific task. They allow easy migration into other Oracle SaaS environments.

In this blog, you will see how to leverage the FlexDeploy Oracle SaaS FSM Plugin to make deployment of setup tasks a breeze. Today we will be showing off an example application with respect to Human Capital Managment (HCM). However, FlexDeploy’s FSM support goes beyond just HCM into other Oracle Fusion Applications such as Supply Chain Management, Sales, Enterprise Resource Planning, and more.

Let’s begin.

Oracle SaaS FSM Cloud Account

FlexDeploy integrations represent an external technology instance. Data in integration accounts can be conveniently reused throughout FlexDeploy. We will need account(s) to connect to your Oracle SaaS FSM environment(s). Let’s assume this account is pointing to your DEV environment.

FSM Account integrated into FlexDeploy

Environment Instance

Each of your Oracle SaaS FSM environments will be mapped one-to-one with a FlexDeploy environment instance. Environment Instance defines the environment-specific properties which are required to communicate to the underlying technology. Here on the DEV -> Oracle SaaS HCM environment instance we will set the Oracle SaaS FSM Account to point to account information we just created.

FSM Env/Inst

There is much more to FlexDeploy Topology than what I’ve shown. I’ve glanced over details to keep the blog succinct so feel free to checkout our Topology User guide to learn more.

Create Build/Deploy Workflows

FlexDeploy utilizes workflows to determine what steps and operations will be used during build and deploy processing. To support the Oracle SaaS FSM build/deploy process we need two workflows:

  1. A build workflow that contains a step to execute the csvExport operation from the Oracle SaaS FSM Plugin.
  2. A deploy workflow that contains a step to execute the csvImport operation from the Oracle SaaS FSM Plugin.

Build Workflow

The build workflow will look like the following. A single csvExport step.

Build Workflow for csvExport

When configuring the csvExport you will also need to keep in the mind the following options:

  1. Oracle SaaS FSM Account – This dropdown value will override the account we selected in on the environment instance in the topology. I suggest only setting this value if you don’t need to deploy to multiple environments or for testing purposes. For those reasons I have not set it here but the option is there.
  2. API Timeout – It takes time to process export setup tasks. This is the maximum amount of time our workflow should wait for each individual file package to export. If it takes longer than the 5 minutes (default value), then execution will fail.
  3. The rest of the inputs are for reporting purpose only. Check these if you would like FlexDeploy to download a specific report after export has completed. This is the same reports you could download from the FSM UI.

csvExport inputs for plugin configuration

Deploy Workflow

In the same fashion, deploy workflow is a single csvImport operation.

FSM Deploy workflow

The csvImport has the same inputs as csvExport, except of course the report files would contain data about import.

csvImport inputs for plugin configuration

Create the Project

FlexDeploy projects represent the artifacts that can be built and deployed as a unit. The components we created, in Topology and Workflows come into play now. For Oracle SaaS FSM deployments we will need to create a specific project type to make the most use of the plugin and automation. Create a partial deployment project of type Oracle SaaS FSM. In the example below, we are creating a project for Human Resources.

create FSM Project

Project Configuration

The configuration portion of the project is used to define properties unique to the project including the build and deploy workflow, instances, and source control.

In this case, we are pointing to the CSV build and deploy workflows and Oracle SaaS HCM instance shown in previous setup. Notice SCM Type is set to None. The FlexDeploy Oracle SaaS FSM Plugin only supports environment to environment migrations and does not pull from SCM.

FSM Project Configuration

Project Files – Create your files

Now that our project is setup, we need to populate some setup tasks to start building and deploy. To do so, follow these instructions:

  1. Navigate to the project files section on the project and click Create button.
  2. Enter your File Name (with Path). FlexDeploy is expecting a specific file path: /SetupTasks/<Offering Code>/<Functional Area>/<TaskCode>.zip
    • Example: /SetupTasks/Compensation Management/Base Pay/PER_MANAGE_ACTIONS_AND_REASONS.zip
  3. Click Evaluate button and the attributes will populate underneath based on the File Name (with path).
  4. Verify the attributes are correct and click Ok button. If they are not correct, simply change the File Name and click the Evaluate button again until satisfactory.

Create Project File

Unfortunately, initially adding these files like this will remain a manual task. However, these file need not be added all at once. It can be an incremental process overtime as build and deployments of setup tasks are required for new files.

How do I find the required Task Code needed for FlexDeploy?

To find the relevant code you will need to login to your Oracle Cloud environment and follow these steps:

  1. Click Navigator > Setup and Maintenance.
  2. In the Setup and Maintenance work area, click Manage Setup Content from the Tasks panel tab.
  3. On the Manage Setup Content page, click Manage Task Lists and Tasks.
  4. In the Search field, select Tasks and click Search.
  5. In the search results, click the name of the task.
  6. On the Task page, look for value that appears against Code.

TaskCode screen

We are ready to start running FSM Setup Task migrations from FlexDeploy!

Example Adhoc Build and Deploy

We will use a package called GLORY-2 and add the files from project files we are interested in. In this case, we’ll migrate a few setup tasks under our Base Pay functional area. Now build can be executed on the package.

Files added to the Projects tab

After submitting the build, each setup task file will be sequentially exported into a single zip artifact and saved on the FlexDeploy server. Essentially, this is the same process as logging into your Oracle SaaS environment, downloading CSV File package for each task, and packaging those into a single zip file.

Once the build is complete, let’s deploy our GLORY-2 package to the Test environment.

Deploy button

At any time after the build or deployment request is submitted you can view real-time logs of the execution to see progression and to debug if any failures occur. By default, the log level is set to INFO level but log level can be increased for more debug information.

plugin logs

You can confirm deployment was successful by checking on your Oracle SaaS FSM environment.

FSM Confirm Import

Find the Export/Import Setup Task you’re looking for and then click on the Status link to see more detailed information about the setup task.

If desired you can use the Actions button in the top right to download process result, logs, or the CSV File Package itself. However, these files can also be downloaded from FlexDeploy if enabled in the workflows.

FSM UI Status

Here we can see the reports downloadable from FlexDeploy for each Setup Task on the Project Workflow Execution screen. Again these are the same file downloadable from FSM UI.

Reports

We have shown building and deploying with a package, but FlexDeploy projects can be built and deploy in multiple ways. Learn more about Building and Deploying projects.

Conclusion

In conclusion, you have seen a quick setup and execution of Oracle SaaS FSM setup tasks. Although, initial setup can take some time, it pays off when you realize the time saved versus manual deployments. Logging in and out of various environments, comparing setup data, and downloading setup data. FlexDeploy tracks the versions for you and allows that automated build and deployment at a touch of button. Using FlexDeploy’s release and pipeline features, the movement of FSM CSV file packages (Setup Tasks) can easily be incorporated into a release and deployment to any number of environments automatically.

For more information on release and pipeline features in FlexDeploy:

Share this:
Jay-Ar Brouillard

I am a Software Developer at Flexagon working primarily in Java. In addition, I have experience working on UI/UX, REST APIs, java based plugins, and consulting for Flexagon clients. I always continue to learn more about DevOps and emerging technologies to further my professional career.

More posts by Jay-Ar Brouillard

Leave a Reply

Your email address will not be published. Required fields are marked *