Last updated on NOVEMBER 17, 2015
Applies to:Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
The "Users of a Responsibility", "Active Users Report" and "Active Responsibility Report" reports from System Administration all display incorrect year dates.
The year in the system is 2095, but these reports display the year as 1995.
In these reports development had to add the following in the before paramform trigger:
srw.do_sql(''alter session set NLS_DATE_FORMAT="DD-MON-YYYY"'');
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