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

Symptoms

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

ERROR:
'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.

Changes

 Update As Of Date in the Application Preferences.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms