My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.