E1: 00: JD Edwards EnterpriseOne Default Century Dates - CENTCHG
(Doc ID 882478.1)
Last updated on JANUARY 25, 2024
Applies to:
JD Edwards EnterpriseOne Information in this document applies to any platform.
Purpose
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.2, the default value was set to 25, creating a date of ‘12/31/2025’. 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.
This document 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.
Scope
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
