Revenue Accounting Form Shows Created And Updated Year As 0014 Instead Of 2014 (Doc ID 2031320.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Transactions Related

Revenue Accounting form shows Created and Updated Year as 0014 instead of 2014.

The database tables and views show the correct value when queried, but only the application it shows as 0014, and not 2014.
This is noticed only in the Revenue Accounting form and not found in Transactions or transactions distributions, which also uses the same views.

This is happening for all Revenue Accounting forms in the system and not particular to an Operating Unit.
Profile Options and Language settings are correct.

It looks like only this form might have been deriving wrong NLS Date parameter

NLS_DATE_FORMAT : DD-MON-RR
NLS_DATE_LANGUAGE : AMERICAN
NLS_LANG : AMERICAN_AMERICA.UTF8

Form Name : ARXRAATR
Form Version : 11.5.48 

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