Cannot Migrate Lookup Table Driver Attached to Allocation to a New Folder (Doc ID 2246795.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Oracle Financial Services Profitability Management - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Profitability Management (PFT) 6.1.1.1, you cannot migrate a Lookup Table Driver used in an Allocation to a new folder in the target environment.  You can migrate a Data Filter and an Expression successfully to the new folder but not the Lookup Table Driver.

According to the Object Migration documentation, you should be able to migrate dependent items to a new Folder if you explicitly migrate them. From the guide:

"Explicit Migration: When you need to migrate the dependent objects to a specific folder (different than the dependent's Source Folder), explicitly select the dependent object and the desired Target Folder for it."

This works for Filters and Expressions but does not work for Lookup Table Drivers.

Steps to Reproduce:

1. Create an Allocation the uses a Data Filter, Expression, and Lookup Table Driver in the Source environment
2. Create one migration rule to move these items to a new folder in the target environment

Example:

Add the data filter used in the Allocation to the rule.
Add the expression used in the Allocation to the rule.
Add the Lookup Table Driver used in the Allocation to the rule.
Finally, add the Allocation to the rule.

All items have source folder of "OFSAASEG".
All items have target folder of "TESTSEG".

3. Run the Object Migration rule

The following is the result:

Data filter is migrated to new folder.
Expression is migrated to new folder.
Lookup Table Driver is *not* migrated to new folder and remains in the Source folder.
Allocation is migrated to new folder.

Only the Lookup Table Driver is not migrated to the new folder.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms