Jun 19 2009

Changing the Century for Calendar or Defaults for Effective dates

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

The maximum value of Effective Thru (EFFT) date (as in some fields, like BOM Effective Date, Lot Effective Date, Etc …) the default value is 2010/12/31

Similarly, when you key in the dates like 06/20/11, the dates will automatically default to 06/20/1911, which is absurd.

Now you can change it via two data dictionary items – Century Change Year (CENTCHG) and DCYR.  Set it’s default value to 30 or 40, 50. The Effective Thru Date can be to 2030/12/31, 2040/12/31, 2050/12/31, its default value is 2010/12/31.

CENTCHG - DD Details

But make sure that You deploy to get the changes effective.

Published under the license.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
(Visited 322 times, 1 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

1 comment

  1. Sudhakar Motade

    Hi Deepesh,

    I have one Date (i.e CWK)using this i want to get year and century and want to store both year and century in variable for further calculation

    kindly suggest

    Sudhakar Motade

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)

Leave a Reply