ORA-12899 When Trying to Update As of Date in PFT Application Preferences Screen
Last updated on OCTOBER 04, 2016
Applies to:Oracle Financial Services Profitability Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
On PFT 22.214.171.124, 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms