Last updated on JULY 28, 2017
Applies to:Oracle Receivables - Version 126.96.36.199 and later
Information in this document applies to any platform.
On : 188.8.131.52 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
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