FTP 8.0.5 Install ORA-02291: Integrity Constraint (OFSAACFG.FK_CSSMS_ROLE_FUNCTION_MAP_1) Violated
Last updated on FEBRUARY 26, 2018
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle Financial Services Profitability Management - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.5 version, Install and Upgrade Issues
Funds Transfer Pricing (FTP) 8.0.5 Installation failed with below error in OFS_PFT_installation.log.
Steps to Replicate:
1. Install PFT 8.0.5 pack and only choose to install Funds Transfer Pricing application.
2. Found the above error in OFS_PFT_installation.log.
3. Check below tables:
select * from CSSMS_FUNCTION_MAST;
Select * from CSSMS_ROLE_FUNCTION_MAP_PACK;
select * from CSSMS_ROLE_FUNCTION_MAP;
Found the following functions are missing from CSSMS_FUNCTION_MAST table causing integrity error.
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