R12 E-Business Suite User And Responsibility Reports Incorrectly Display End Date As 2095 Instead Of 1995 (Doc ID 2051780.1)

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.

Symptoms

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.


Changes

 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"'');

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