ORA-12899 When Trying to Update As of Date in PFT Application Preferences Screen
(Doc ID 1607216.1)
Last updated on OCTOBER 04, 2016
Applies to:Oracle Financial Services Profitability Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
On PFT 18.104.22.168, while trying to save the As of Date for individual user or for all users, 'Save failed' error occurs. The error happens while also trying to restore default values.
'Save failed' error on the User Interface
The following error can be found in fsapps log file:
ERROR ~ FSAPPS ~ [COMMONAPP] executeUpdate failed due to:
java.sql.SQLException: ORA-12899: value too large for column "DEMOSETUP"."REV_APP_USER_PREFERENCES"."ENABLE_MASS_UNDO_SA" (actual: 4, maximum: 1)
Steps to reproduce:
1. Update the As of Date in PFT Application Preferences.
2. Attempt to save the new date, then error is displayed.
Update As Of Date in the Application Preferences.
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