How can the customer use the Date Utility Tool? Question 5: The customer is on Tools Release level 8.96.x. How can we use the utility to update a portion of the tables? How can we selectively update records?

Question 4: The Date Utility, in Update Proof Mode, results show fifty records in one table with the date value we indicated. Question 3: Why didn’t the user receive a prompt to sign in to EnterpriseOne when running the Date Utility? 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 1: Why were some tables skipped when running the utility in Scan mode? Other Considerations - Work Day/Shop Floor Calendars Julian Dates and JD Edwards EnterpriseOneĬentury Change Year (CENTCHG) Data Dictionary Value

To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started!

The Date Utility is designed for use with the currently supported tools releases. This document also introduces the Date Utility, a tool designed to assist users with identifying and resolving business data with potential date issues. This document outlines the function of CENTCHG in the software and recommends a change to the CENTCHG data dictionary default as soon as possible. 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. In releases 8.10 through 9.2, the default value was set to 25, creating a date of ‘’. In release 8.9, the default value was set to 15, creating a date of ‘’. Thus dates populated using the CENTCHG default value are created as ‘’. In releases Xe and ERP8.0, the default value for CENTCHG was set to 10. The system also uses this data dictionary item when automatically populating the default effective through and expiration dates in some data tables. The system uses data dictionary item CENTCHG (Centur圜hangeYear) to determine the century to use for populating data tables. The system allows two-digit dates to be entered to facilitate data entry. JD Edwards EnterpriseOne stores calendar dates in Julian date format. Information in this document applies to any platform. E1: 00: JD Edwards EnterpriseOne Default Century Dates - CENTCHG

Jd edwards enterprise one 8.10