Dear Valued JD Edwards EnterpriseOne Customer,
According to our records your company is currently using Oracle JD Edwards EnterpriseOne. We want to make you aware of an important update that users should make in the EnterpriseOne CENTCHG data dictionary.
JD Edwards EnterpriseOne stores calendar dates in Julian date format. The system allows two-digit dates to be entered to facilitate data entry. The system uses data dictionary item CENTCHG (CenturyChangeYear) to determine the century to use for populating data tables. The system also uses this data dictionary item when automatically populating the default effective through and expiration dates in some data tables.
In releases Xe and ERP8.0, the default value for CENTCHG was set to 10. Thus dates populated using the CENTCHG default value are created as '12/31/2010'. In release 8.9, the default value was set to 15, creating a date of '12/31/2015'. In releases 8.10 through 9.0, the default value was set to 40, creating a date of '12/31/2040'. Oracle recommends that this value be increased for users in the Xe, ERP8.0, and 8.9 releases as well as users who have upgraded from these releases to 8.10 or higher so that the software will supply new effective through dates further into the future.
The document, linked below, outlines the function of CENTCHG in the software and recommends a change to the CENTCHG data dictionary default as soon as possible. This document also introduces the Date Utility, a tool designed to assist users with identifying and resolving business data with potential date issues. The Date Utility is designed for use with the currently supported tools releases.
Instructions (Knowledge Article 882478.1)
If you have any questions or concerns and we can be of assistance, please contact your Global Customer Support Center
Lyle Ekdahl
Group Vice President. General Manager
Oracle JD Edwards
No comments:
Post a Comment