Applications Tab Does Not Appear After Clone from Lower Environment - No Decryption Issue
(Doc ID 2447427.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and laterInformation 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)
Oracle Financial Services Asset Liability Management (ALM)
Websphere (WAS)
Symptoms
On OFSAA 8.0.5, the Applications tab is missing after OFS PFT 805 cloning from lower environment.
The SMSService.log has the following errors:
ERROR
[UMMLOG] Sep 6,18 14:54:42 : [SMSSERVICES][SMSServices][getEnabledMDBApps][appLst][]
[UMMLOG] Sep 6,18 14:54:42 : [INFORMATIONDOMAINSERVICES][ClsUCntSecUtilFuncs] Exception while trying to decrypt string :javax.crypto.BadPaddingException: Given final block not properly padded
[UMMLOG] Sep 6,18 09:15:47 : [SMSSERVICES][SMSServices][getAppsFrUsr][appAccesCodeQuery]select V_APP_ID, V_ACCESS_CODE from AAI_APP_B where V_APP_ID in (null)
[UMMLOG] Sep 6,18 09:15:47 : [SMSSERVICES][SMSServices][getAppsFrUsr][appIDs]null
[UMMLOG] Sep 6,18 09:15:47 : [SMSSERVICES][SMSServices][getAppsFrUsr][appLst][]
[UMMLOG] Sep 6,18 09:15:47 : [INFORMATIONDOMAINSERVICES][ClsUCntSecUtilFuncs] Exception while trying to decrypt string :javax.crypto.BadPaddingException: Given final block not properly padded
However, all values seem to decrpyt using the AESCryptKey.ext file without issue using the in the following tables:
CONFIGURATION
CSSMS_USR_PROFILE
CSSMS_USR_PROFILE_UNAUTH
DB_MASTER
AAI_DB_AUTH_ALIAS
AAI_APP_PACK_AUDIT_TRAIL
The issue can be reproduced at will with the following steps:
1. Clone from lower environment
2. Login to OFSAA
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |