• Post category:Others
  • Post comments:0 Comments
  • Post last modified:January 22, 2021
  • Reading time:14 mins read
You are currently viewing Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

In this article we will look into the most frequently asked question of how to migrate the Table based Value Sets, Fast Formulas, Lookups, Payroll Flow Patterns etc.

We cannot migrate Table based Value Set and Payroll Flows using any means except this method.. For HCM Extracts, we can do export and Import, for Fast Formulas we can use HDL and bulk loading for Lookups.

Table of Contents

Security/Roles required:

Application Implementation Consultant role is required to access this functionality.

Instructions to Migrate objects:

Let’s look into step by step on how to do this migration in Source and Target.

Login to Source POD.

Navigate to Setup and Maintenance
From Right hand side menu click on Manage Implementation Projects

image 51 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Click on Manage Implementation Projects
image 52 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Click on + icon to add a new implementation project

Create Implementation Project

image 42 1024x224 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Create a Test Project and Click on Save and Open Project

– Choose Create

– Update the Project Name if desired

– Select ‘Save and Open Project’ to proceed

– Click the Create icon

– Click the Add icon

– Set the Search drop-down to Tasks, and search by Task Names:
Payroll Flow Patterns

– Highlight the result

– Click on Apply then Done

– Click the Done button

Add the Extract, Value Sets, Fast Formula tasks

image 43 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Adding HCM Extract Task Name
image 44 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Adding Fast Formula Task

For Valuesets and Lookups we need to select the module specific task instead of the generic tasks as we cannot select the scope for these objects. We will get to know what is scope in the later part of this article.

Generic Tasks – Manage Value Sets, Manage Common Lookups
Module Specific Tasks –
Manage Value Sets for Global Human Resources – It will export all the Value Sets with module setup as Global Human Resources
Payroll Value Sets – It will copy all the Value Sets with module setup as Global Payroll

image 45 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Adding Value Sets Task
image 46 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Adding Lookups Task

Click on Done after adding all tasks that needs to be migrated.

Now, get back to Setup and Maintenance

From Right hand side tasks, select Manage Configuration Packages

image 53 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Click on Manage Configuration Packages

Click on New to create a new config package

image 54 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Click on New

Now select the previously selected project “Test Project

image 55 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Select the Test Project and click Yes on Warning

Click on Next again

New screen will show up with the list of all objects that will be migrated as per the list of tasks that we have selected in the Implementation Project.

image 56 1024x396 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
List of Business Objects in the package

Now, select the business object “HCM Extract Definition

image 57 1024x614 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Add the Scope for HCM Extract Definition and add search for the Extract Name

Click on + for scope and search for extracts and click on Add. Whatever object names we add to the scope, only those will be migrated. If you don’t include anything in scope, then all extracts will be migrated. Make sure you select the right scope for the migration to happen seamlessly. When we add scope for the extracts, the other objects dependent on extracts like extract attributes, data groups will also get extracted as per the scope defined for HCM Extracts object.

image 58 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Extract has been added to scope

So the extracts which have been added to the scope will only be migrated as part of this package.

Note: If you don’t add any scope, then all extracts will get migrated and it might cause issues with unwanted extracts getting migrated or not so tested extracts getting migrated and would land you into trouble. So keep note of the scope and use it effectively.

Now, we need to add the scope for Value Sets, Lookups, Fast Formulas, etc.

Fast Formulas:

image 59 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
Adding Scope for Fast Formula

For Lookups and Valuesets, we cannot define the scope.. So we need to use the right task like Manage Value Sets for Global Human Resources or Payroll Value Sets etc.

We can set the scope for only the core tasks like “Fast Formula, Payroll Flow Definition, etc.” and automatically the scope will be set for the dependent tasks like “Fast Formula Function, Payroll Flow Task Payroll Flow Definition Parameters, etc”.

We also need to set the scope for Payroll Flow Definition and select the Payroll Flow that needs to be migrated.

image 23 1024x443 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Once the scope is set for all tasks, click submit

image 24 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Click on Yes when it prompts for do you want to continue.

image 25 1024x169 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Wait for the process to complete and then you can download the Configuration Package by clicking the Download Icon. This Config package of zip file contains all the data that we have exported now.

We need to import this package into the target environment to migrate the objects.

Now, Let’s login to Target POD

Navigate to Setup and Maintenance > Manage Configuration Packages

image 26 1024x221 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Click on Upload to upload the config package.

image 27 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Click on Choose File and browse for the zip file on your local machine and then click Get Details.

image 28 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

We can verify the configuration package details and then click submit.

image 29 1024x248 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Once submitted, it will upload the package and then we will have to import it.

Select the Project and Click on “Import Setup Data” which will take us to the next screen.

image 30 1024x409 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Click on Submit to start the import process.

image 31 1024x328 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another
image 32 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

We have to wait for the import to be successful. Once is is successful, we can go to respective tasks and verify the objects.

We can also download the log files and the import report if the import is not successful to identify the cause and fix it at source/target.

image 33 - Migration of Objects Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another

Post-Migration Steps:

For Fast Formulas, they need to be compiled in target POD once migrated.

For HCM Extracts, they need to be compiled and validated in target POD.

Note: Make sure the Source and Target PODs (20B or 20C or whatever) are at same patch level before migrating the objects using this approach as there might be difference in the features and the migration might fail.

Video on Cloud Customer Connect explaining the migration processhttps://ora-fusion-apps.custhelp.com/euf/assets/fusion/videos/replays/303800/presentation.html

Hope this helps when you have a requirement to migrate the configuration changes from one POD to another.