Encounter Invalid request/Error on Login and ORA-02291 Errors After Applying PFT 8.0.2 Pack
Last updated on AUGUST 25, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Profitability Management - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
On OFSAA 8.0.2, after applying the OFSAAI/FTP/PFT 8.0.2 patch (<Patch 23054124> login to the application using SYSADMIN, SYSAUTH, or any other users fails with error:
"Invalid request / Error while processing request"
Also, in PFT installation logs OFS_PFT_patch_installation.log, see
Error:ORA-02291: integrity constraint
(OFSAACONF.FK_PR2_RULE_OBJECT_MEMBER_1) violated - parent key not found
ORA-12899 (Value too large for column) error
The issue can be reproduced at will with the following steps:
1 Applied OFS AAI/FTP/PFT 8.0.2 patch from 188.8.131.52.0 and have not faced any error during the installation in front end.
2 When access https://ip:port/OFSAA/auth/validldaplogin.jsp
3 Found some ORA errors in PFT installation logs.
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