FTP 8.0.5 Install ORA-02291: Integrity Constraint (OFSAACFG.FK_CSSMS_ROLE_FUNCTION_MAP_1) Violated
(Doc ID 2366007.1)
Last updated on MARCH 02, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and laterOracle 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 |