Table Conversion Creating dates for previous century (as from 1/1/2011)

enixon

Member
2011 Date fields in flat text files in the form MMDDYY are being converted to 19th century dates, beginning from 1/1/2011.

e.g. 01/03/11, in the input text file as 010311, is being converted to a JDE Data Dictionary DGJ field as 11003, instead of 111003.

Does anybody have any idea of what can be wrong?

The formatting of the Fiscal Date Pattern changed for 2011 as follows, which also indicates something different within JDE with respect to dates.

A 07/01/10 07/31/10 08/31/10 09/30/10 10/31/10 11/30/10 12/31/10 01/31/2011 02/28/2011 03/31/2011 04/30/2011 05/31/2011 06/30/2011 06/30/2011 06/30/2011

These table conversion have been in daily use since before 2000 and input the data from around 70 branch systems into JDE. The situation is quite critical, as processing of AR and AP data has come to a halt.

Thanks and regards - Edmund
 
Hi,

I guess your company didn't do any changes in the CENTCHG (see oracle announcement here).

You could create a support ticket to oracle or read more here.

Hope this helps.
 
Hi 'JDETECHNO'
Thanks for the lead. That was it! We never received the announcement from Oracle.
Thanks and regards - Edmund
 
Back
Top