FTP 8.0.5 Install ORA-02291: Integrity Constraint (OFSAACFG.FK_CSSMS_ROLE_FUNCTION_MAP_1) Violated

(Doc ID 2366007.1)

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)

Symptoms

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.

Error:


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.

ADDPROD
ADDRATEREP
COPYPROD
CPYRATEREP
EDITPROD
EDITRATERE
REMRATEREP
SUMPROD
SUMRATEREP
VIEWPROD
VIEWRATERE

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