My Oracle Support Banner

Applications Tab Does Not Appear After Clone from Lower Environment - No Decryption Issue (Doc ID 2447427.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
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)
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


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