Results 1 to 4 of 4

Thread: SQL to identify list of Custom, Modified and Cloned Objects for JDE Upgrade

  1. #1
    New Member Joshua Tomlin's Avatar
    Join Date
    Mar 2005
    Location
    NJ, USA
    Posts
    12

    SQL to identify list of Custom, Modified and Cloned Objects for JDE Upgrade

    We are looking to upgrade from JDE 9.1 to JDE 9.2
    Wanted to find out if any of you had a SQL to identify the list of Custom, Modified and Cloned Objects.
    Any help would be greatly appreciated

  2. #2
    Member
    Join Date
    Dec 2000
    Location
    Kwa-Zulu Natal, South Africa
    Posts
    70
    Hi Joshua,

    Chapter 2 in the upgrade manual does all this for you. You need to do this in the source 9.1 environment. I hope this answers your question.
    Kind regards,
    Gopal Kistasami
    Smiths Manufacturing (Pty) Ltd
    E1 9.0/9.1,SP 8.98.4.2/9.1.3.2,DB SE 11.2.0.1/11.2.0.3,OVM 2.2/3.2,WL 10.3.2
    Email: gopal.kistasami@smiths.co.za

  3. #3
    New Member Joshua Tomlin's Avatar
    Join Date
    Mar 2005
    Location
    NJ, USA
    Posts
    12
    Hi Gopal,

    Thanks for your response. I could not find any SQLs for this in the Upgrade Manual. I was just looking to get an object listing.

    Regards,
    Joshua

  4. #4
    Quote Originally Posted by Joshua Tomlin View Post
    We are looking to upgrade from JDE 9.1 to JDE 9.2
    Wanted to find out if any of you had a SQL to identify the list of Custom, Modified and Cloned Objects.
    Any help would be greatly appreciated
    Some stuff I've slopped together over the years:


    --Objects Modified in PD not by OMW promotion
    use JDE920
    select OL920.F9861.SIPATHCD as "Path Code", OL920.F9861.SIOBNM as "Object Number", OL920.F9860.SIMD as "Object Name",
    OL920.F9861.SIMKEY as "Workstation", OL920.F9861.SIUSER as "User", OL920.F9861.SIMRGMOD as "Mod Type",
    DATEADD(ss,CONVERT(int,right(OL920.F9861.SIUPMT,2) ),
    DATEADD(mi,CONVERT(int,left(right(OL920.F9861.SIUP MT,4),2)),
    DATEADD(hh,CONVERT(int,left(OL920.F9861.SIUPMT,len (OL920.F9861.SIUPMT)-4)),
    DATEADD( dd, CONVERT(int,OL920.F9861.SIUPMJ) % 1000,
    CONVERT(datetime, '12/31/' + CONVERT(varchar, left((OL920.F9861.SIUPMJ/ 1000 + 1899),4) )))))) as "Date Modified"
    FROM OL920.F9861
    JOIN OL920.F9860 on OL920.F9861.SIOBNM=OL920.F9860.SIOBNM
    where SIMRGMOD in ('C', 'A', 'D')
    and SIPATHCD = 'PD920'
    and OL920.F9861.SIOBNM NOT IN
    (SELECT POOMWOBJID FROM JDE920.SY920.F98222 WHERE POOMWPRJID IN
    (SELECT LHOMWPRJID FROM JDE920.SY920.F98210 WHERE LHOMWAC='38'))


    ORDER BY 7 DESC




    --Objects Modified
    use JDE920
    select OL920.F9861.SIPATHCD as "Path Code", OL920.F9861.SIOBNM as "Object Number", OL920.F9860.SIMD as "Object Name",
    OL920.F9861.SIMKEY as "Workstation", OL920.F9861.SIUSER as "User", OL920.F9861.SIMRGMOD as "Mod Type",
    DATEADD(ss,CONVERT(int,right(OL920.F9861.SIUPMT,2) ),
    DATEADD(mi,CONVERT(int,left(right(OL920.F9861.SIUP MT,4),2)),
    DATEADD(hh,CONVERT(int,left(OL920.F9861.SIUPMT,len (OL920.F9861.SIUPMT)-4)),
    DATEADD( dd, CONVERT(int,OL920.F9861.SIUPMJ) % 1000,
    CONVERT(datetime, '12/31/' + CONVERT(varchar, left((OL920.F9861.SIUPMJ/ 1000 + 1899),4) )))))) as "Date Modified"
    FROM OL920.F9861
    JOIN OL920.F9860 on OL920.F9861.SIOBNM=OL920.F9860.SIOBNM
    where SIMRGMOD in ('C', 'A', 'D')
    ORDER BY 1, 2




    --Versions Modified since 2003 in PY812 not including those by user 'JDE' (May eliminate ESU's)
    use JDE_PY812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)", VRUSER as 'User' from PY812.F983051
    where VRVCD > 103000
    and VRUSER ! = 'JDE'
    order by VRPID, VRVERS


    --Versions Modified since 2003 in DV812 not including those by user 'JDE' (May eliminate ESU's)
    use JDE_DV812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)", VRUSER as 'User' from DV812.F983051
    where VRVCD > 103000
    and VRUSER ! = 'JDE'
    order by VRPID, VRVERS


    --Versions Modified since 2003 in PD812 not including those by user 'JDE' (May eliminate ESU's)
    use JDE_PD812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)", VRUSER as 'User' from PD812.F983051
    where VRVCD > 103000
    and VRUSER ! = 'JDE'
    order by VRPID, VRVERS






    --Includes JDE user modified objects


    --Objects Modified
    use JDE920
    select OL920.F9861.SIPATHCD as "Path Code", OL920.F9861.SIOBNM as "Object Number", OL920.F9860.SIMD as "Object Name",
    OL920.F9861.SIMKEY as "Workstation", OL920.F9861.SIUSER as "User", OL920.F9861.SIMRGMOD as "Mod Type",
    DATEADD(ss,CONVERT(int,right(OL920.F9861.SIUPMT,2) ),
    DATEADD(mi,CONVERT(int,left(right(OL920.F9861.SIUP MT,4),2)),
    DATEADD(hh,CONVERT(int,left(OL920.F9861.SIUPMT,len (OL920.F9861.SIUPMT)-4)),
    DATEADD( dd, CONVERT(int,OL920.F9861.SIUPMJ) % 1000,
    CONVERT(datetime, '12/31/' + CONVERT(varchar, left((OL920.F9861.SIUPMJ/ 1000 + 1899),4) )))))) as "Date Modified"
    FROM OL920.F9861
    JOIN OL920.F9860 on OL920.F9861.SIOBNM=OL920.F9860.SIOBNM
    where SIMRGMOD in ('C', 'A', 'D')
    ORDER BY 1, 2




    --Versions Modified since 2003 in PY812
    use JDE_PY812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)" from PY812.F983051 where VRVCD > 103000
    order by VRPID, VRVERS


    --Versions Modified since 2003 in DV812
    use JDE_DV812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)" from DV812.F983051 where VRVCD > 103000
    order by VRPID, VRVERS


    --Versions Modified since 2003 in PD812
    use JDE_PD812
    select VRPID as "Object Name", VRVERS as "Version Number", VRJD as "Version Name", VRVCD as "Modified Date (E1 Julian)" from PD812.F983051 where VRVCD > 103000
    order by VRPID, VRVERS

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.