FTP 8.0.5 Install ORA-02291: Integrity Constraint (OFSAACFG.FK_CSSMS_ROLE_FUNCTION_MAP_1) Violated
(Doc ID 2366007.1)
Last updated on MAY 04, 2021
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document