Encounter Invalid request/Error on Login and ORA-02291 Errors After Applying PFT 8.0.2 Pack

(Doc ID 2169850.1)

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)

Symptoms

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:

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 8.0.0.0.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.

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