My Oracle Support Banner

E1: 00: JD Edwards EnterpriseOne Default Century Dates - CENTCHG (Doc ID 882478.1)

Last updated on AUGUST 11, 2020

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.

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!


In this Document
Purpose
Details
 Julian Dates and JD Edwards EnterpriseOne
 Century Change Year (CENTCHG) Data Dictionary Value
 Recommended Default Value for CENTCHG
 Data Considerations
 Other Considerations - Work Day/Shop Floor Calendars
 Resolution
 Date Utility
 Recommendations
 Scan Mode
 Update Mode – Proof and Final
 Examples
 Date Utility Frequently Asked Questions
 Question 1: Why were some tables skipped when running the utility in Scan mode?
 Question 2: How can we add tables to UDC 98/UU? We have a number of custom tables that should not be included in the Scan.
 Question 3: Why didn’t the user receive a prompt to sign in to EnterpriseOne when running the Date Utility?
 Question 4: The Date Utility, in Update Proof Mode, results show fifty records in one table with the date value we indicated. How can we use the utility to update a portion of the tables? How can we selectively update records?
 Question 5: The customer is on Tools Release level 8.96.x. How can the customer use the Date Utility Tool?
 Question 6:  Customer is running the DateScan.exe utility and is receiving an error message indicating it is unable to find jdeunicode.dll. Another customer, when running JDEdwards\E900\DDP\system\bin32 DateScan.exe, receives the following error: "The Procedure entry point JDB_AssignColumnvalue@60 could not be located in the dynamic link library Jdekrnl.dll." How can these errors be resolved?
 Question 7: Why does the pdf file included with the download .PAR file, JD Edwards EnterpriseOne Date Utility, reference download names DATEUTILXE and DATEUTIL while this knowledge document lists the names as DATEUTILXE_V2 and DATEUTIL_V2?
 Question 8: When running DateScan.exe, the user received an error in the Command Prompt window and in the DateScanLog.txt file indicating "Invalid Parameters Entered . Exiting Date Scan Utility". What are possible causes for this error?
 Question 9: When running the Date Utility over tables using Data Dictionary items with a JDE UTIME as the Data Type, the scan does not find the date within these tables. For example, Customer Master Commission Information (F42140) Data Dictionary field CMSTMEDT (SalesTeamEndEffectiveDate) did not find data. Is this accurate?
 Question 10: The customer wants to run the DateScan.exe to list all tables.  How can this be accomplished? 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.