EPM Processes Not Running Post Object Migration in Target Environment Due to Reverse Population Not Running

(Doc ID 2123290.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Enterprise Performance Management (EPM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On FTP 8.0.1 it appears that the FTP processes and reverse population are not working in a new test instance after object migration.

ACTUAL BEHAVIOR
No FTP process are completing successfully in a new test instance due to reverse population not working.

EXPECTED BEHAVIOR
Expect all FTP processes to work as they did on source Dev instance.

The issue can be reproduced at will with the following steps:
1.Migrated all rules and metadata from Dev to Test environment.
2.Transfer Pricing completes immediately but with no results (as_of_date,IRCS,etc. all checked and valid).
3. All ALM_COA_ID's (custom Leaf) hierarchies do not exist in IDT_ROLLUP,reverse population fails when running separately (saving a hierarchy in new environment does as well). Guessing not finding this rollup and/or the instrument to coa mapping is causing the run to complete with no changes to data.

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