Mass update of effectivity dates?

[Krusador]

When my company first implemented JD Edwards back in 2000-2001, the standard practice by the implementation team at that time was to set all of the effectivity dates to 2010 for those items where effectivity dates aren't that big of a concern to us, which is most of them.

Now that we are in 2009, I would like to find a way to do a mass update of all these dates to push them out to 2020.

Does anyone have any good ideas on how to accomplish this? Or where to maybe find a list of all the JDE files that have effectivity dates?

TIA
Bob Cagle
IT Manager
Lynk, Inc.
System i5 520 v6r1; JDE A9.1

 

[Nichelle]

Here is a list of files we recently made the same change on...but we went to 2030. We did it with an sql. I believe your #cyr DD should also be set to 2030 otherwise you will continue to create records with a 2010 date.
F41061 Supplier/Catalog Price File
F43090 Supplier/Item Relationships
F4207 Price by Item – This one is listed on this email below
F41291 Item Cost Components
F4016 Text Messages
F4106 Base Price File
F4104 Item XREF File
F3002 and F3003
Print Message F4016

 

[Robertrieck]

Do you still have the program that was used to update files to 2010?

Update that field(s) in that program and run it.

If you know what field(s) are involved and you have a change control packag e you can find out what files on the system have that field in it.=C2=A0=C2 =A0 Write/update a program to reflect those changes.



--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316

 

[Krusador]

No, I don't have the program that was used, if any. The effectivity
dates were established before my time.



And a single file update program isn't going to cut it, as the dates are
strewn throughout several files, as Nichelle as already indicated.



From: [email protected] [mailto:[email protected]]
On Behalf Of Robertrieck
Sent: Tuesday, June 02, 2009 4:09 PM
To: [email protected]
Subject: Re: Mass update of effectivity dates?






Do you still have the program that was used to update files to 2010?

Update that field(s) in that program and run it.

If you know what field(s) are involved and you have a change control
packag e you can find out what files on the system have that field in
it.=3DC2=3DA0=3DC2 =3DA0 Write/update a program to reflect those changes.



--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected]
[email protected]
Office/Residence (847) 838-3743
Cell (630) 421-0316

-- Best Regards, Weber Technologies, Inc. Robert J. Rieck
[email protected] [email protected]
Office/Residence (847) 838-3743 Cell (630) 421-0316

 

[Robertrieck]

I do not want to sopund like a smart but ... BUT

since you know the names of the files then write a program to change the fi eld(s) in the file to be he correct date




--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2 =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316

 

[TerryWin]

We had a similar problem so I created a text member with the following SQL statements and run it in batch with the RUNSQLSTM command. Remember to END any journaling first...

-- Bill of Materials Master File
update PRODDTA/F3002 set IXEFFT = 120365 where IXEFFT = 110365;

-- Routing Master File
update PRODDTA/F3003 set IREFFT = 120365 where IREFFT = 110365;

-- Bill of Materials Change File
update PRODDTA/F3011 set IZEFFT = 120365 where IZEFFT = 110365;

-- ECO Parts List Detail
update PRODDTA/F3013 set CYEFFT = 120365 where CYEFFT = 110365;

-- Tax Areas
update PRODDTA/F4008 set TAEFDJ = 120365 where TAEFDJ = 110365;

-- Text Messages
update PRODDTA/F4016 set TUEXDJ = 120365 where TUEXDJ = 110365;

-- Base Price File
update PRODDTA/F4106 set BPEXDJ = 120365 where BPEXDJ = 110365;

-- Lot Master
update PRODDTA/F4108 set IOMMEJ = 120365 where IOMMEJ = 110365;

-- Supplier / Catalog Price File
update PRODDTA/F41061 set CBEXDJ = 120365 where CBEXDJ = 110365;

-- Related Salesperson File
update PRODDTA/F42003 set RECXPJ = 120365 where RECXPJ = 110365;

-- Commission Constants File
update PRODDTA/F42004 set CMCXPJ = 120365 where CMCXPJ = 110365;

-- Price by Item
update PRODDTA/F4207 set PMCXPJ = 120365 where PMCXPJ = 110365;

-- Vendor/Item Relationships File
update PRODDTA/F43090 set PCCXPJ = 120365 where PCCXPJ = 110365;

Terry

 

[a_boninsegna]

We are working on the same issue. See update A818576750.

Anne Boninsegna
International Brake
World 8.1



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of Robertrieck
Sent: Wednesday, June 03, 2009 1:18 AM
To: [email protected]
Subject: Re: Mass update of effectivity dates?




I do not want to sopund like a smart but ... BUT

since you know the names of the files then write a program to change the fi
eld(s) in the file to be he correct date




--
Best Regards,



Weber Technologies, Inc.
Robert J. Rieck
[email protected] =C2=A0
[email protected] =C2=A0=C2=A0
Office/Residence (847) 838-3743
Cell=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 (630) 421-0316



-- Best Regards, Weber Technologies, Inc. Robert J. Rieck
[email protected] [email protected] Office/Residence
(847) 838-3743 Cell (630) 421-0316



_____


The entire
thread is available for viewing.


Looking for a job? Check out the Job
forum

This is the JDELIST World Mailing List.

To unsubscribe from this list via email, Click <mailto:
[email protected]?Subject=Unsubscribe&Body=Sirs,

Please
remove this address from the JDELIST World Mailing List.

Thank You.>
here.

.

 

[Eric Lehti]

Thank you for posting, Bob Cagle (and others).
We at Ameristar face the same deadline.

 

[dhuggins]

First thing I did was write a program to identify all files containing fields xxxDJ with values >= 110001 and produce a list for me to review to determine what to actually change.

Using the list of files/fields a program was created to execute a series of SQL strings such as:

Update f4106
set bpexdj = bpexdj + 10000
where bpexdj between 110001 and 110365

So far it has worked out.

 

[ssolberg]

I ran into this some time ago and attempted to do some research so I'm dragging up my notes here. First of all, once you identify the files, you only need to write a World Writer over that file(s) to correct the date. That's what I did and works great, no RPG needed. Just create a new WW Group (QEXPIRE or something). Create a WW for each file you need to update and run as needed!

Here is la list of Data Dictionary Items that look like they should be looked for: (there may be others)
CXPJ
EEFD
EFDJ
EXDJ
EFTE
EFFT

I tried to do a cross-ref lookup on these items and I found them living in these files:
F42003
F4207
F43090
F0050
F0150
F4008
F4020
F4015
F4016
F4072A
F4104
F4106
F41061
F4340
F49085
F00692
F01092
F06005
F060146
F06022
F06024
F06053
F06210
F069056
F069116
F069126
F069226
F069246
F06931
F069311
F069312
F08001
F08092
F08320
F083203
F08330
F08336
F08346
F08351
F08360
F08920
F08990
F08991
F12002
F12003
F12092
F1212
F12851
F1301
F1307
F1501
F15012
F15014
F15015
F15016
F1502
F15072
F15110
F1525
F1530
F1531
F3002
F3003
F3011
F3013
F3104
F3293
F3711
F41291
F48098
F48099

 

[Krusador]

I received a very nice e-mail from Brad Nolan, the Customer Support
Director for JDE World at Oracle. He informed me that Oracle has
released a mass update program that will enable us to move our dates
forward. For those on support, program P4028 is available.



I would definitely rather not re-invent the wheel, so this is the route
I will be taking.



Thanks for all the replies.



Bob Cagle

IT Manager

Lynk, Inc.



From: [email protected] [mailto:[email protected]]
On Behalf Of Krusador
Sent: Tuesday, June 02, 2009 2:39 PM
To: [email protected]
Subject: Mass update of effectivity dates?



When my company first implemented JD Edwards back in 2000-2001, the
standard practice by the implementation team at that time was to set all
of the effectivity dates to 2010 for those items where effectivity dates
aren't that big of a concern to us, which is most of them.

Now that we are in 2009, I would like to find a way to do a mass update
of all these dates to push them out to 2020.

Does anyone have any good ideas on how to accomplish this? Or where to
maybe find a list of all the JDE files that have effectivity dates?

TIA
Bob Cagle
IT Manager
Lynk, Inc.
System i5 520 v6r1; JDE A9.1

Bob Cagle IT Manager Lynk, Inc. System i5 520; A8.1c5;

 

[ARIASMA]

Re: RE: Mass update of effectivity dates?

Bob, I appreciate your response. The problem here is that we do not have support, and its my understanding to re-establish support is extremely expensive.

 

[Jim_rubino]

RE: RE: Mass update of effectivity dates?

You need to call world support and ask about getting back on support, it
may not be as painful as you've been told.



Jim Rubino

Fike Corporation

 

[tpayne]

Probably the simplest way in this case would be to use a Worldwriter Update.

With Worldwriter you can select the data to be updated, check the report to ensure that this is correct, then add an update field for the expiration date and set it to the required value.

You just need to add security for the WW Group and the File/Field to be updated for the user who is to run the job.

Hope this helps.