ORA-1841 : (full) year must be between -4713 and +9999, and not be 0 when login to AERS and execute Inbox query (Doc ID 1140524.1)

Last updated on FEBRUARY 02, 2016

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Jan-2012***
***Checked for relevance on 28-Jul-2014***


Symptoms

When more than one interactive INBOX query is assigned to a user via Adminstrator Console, After login, if user enters a value for the Query Parameter and clicks the 'Run' button, system displays error message and no Inbox queries are executed e.g.

 

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