|
Symptom:
Data dictionary
item CENTCHG performs two functions:
-
1. Controls how EnterpriseOne determines dates values.
When entering a date value the year associated with the
date is based on the data dictionary item CENTCHG. The
value in the Default Value tab of CENTCHG determines when
the cutoff is for dates with a century of 20 and when
dates will have a century of 19. For example, when the
default value is set to 10:
• Dates entered with a year up to 10 will be proceeded
by the 20 - i.e. 2005, 2006, 2007, etc.
• Dates entered with a year after 10 will be preceded
by a 19 and assumed to belong to that century - i.e. 1911,
1912, etc.
If the current value for this data dictionary item is
set to 10 and a user enters a date of 01/01/11, the system
compares this value to the default value for the CENTCHG
data item, and since 11 is greater then the default of
10, it adds the value 19 and returns a date of 1/1/1911.
- 2.
Concantenates with the CTRY data item and the hard coded
value of 12/31/ to populated expiration date fields with
a last system date. For example, if CTRY is set to 20
and CENTCHG is set to 10, and users do not populated the
Expired Date on the Print Messages application PP40162),
the system populates 12/31/2010. There are many applications
and tables that use this default value if the date in
not entered by users.
What do you need to do?
Users can change
the default value of the CENTCHG data dictionary item to
control when the system uses the century 20 value and when
the system uses the century 19 value. When users change
the default value on the data dictionary item CENTCHG to
a higher default value such as 25 and appropriately deploy
the data dictionary change, a date entered as 01/01/11 will
correctly format to 1/1/2011.
When
this change is made, the system cannot update existing data
in the tables. Some expiration dates may be valid. Users
must evaluate the dates that should be revised. Users can
update existing tables by:
*
Using a database tool to update tables
* Revising records in the associated application
When
upgrading from older releases to new releases, the system
does not update the expiration dates on existing records.
Note:
Data Dictionary Item DCYR shares the same default value
as CENTCHG. The Data Dictionary application will make the
same default value change to DCYR when the default value
of CENTCHG is changed by the user. If the default value
of DCYR is changed by the user, the same default value change
is also applied to CENTCHG.
|
