My Oracle Support Banner

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 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)


On PFT, 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

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