My Oracle Support Banner

User Maintenance Edit Screen Gets Stuck for Expired User and Encounter Error java.sql.SQLDataException ORA-01843: not a valid month (Doc ID 2962925.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version and later
Information in this document applies to any platform.
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)


On OFSAA, while trying to edit specific expired user A from User Maintenance screen, it hangs with spinning icon.

See the following error from $FIC_HOME/logs/SMSService.log

java.sql.SQLDataException: ORA-01843: not a valid month

The format for D_LASTLOGGED_DATE:
to_char(to_date(d_lastlogged_date,'MM/DD/YYYY HH12:MI:SS AM'), 'MM/DD/YYYY HH24:MI:SS AM') as d_lastlogged_date


1. Login to OFSAA as your SYSADMN user.
2. Navigate to User Maintenance screen.
3. Search for the expired user, select it and click Edit.
4. See the new edit screen shows hanging with spinning icon.


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.