Results 1 to 2 of 2

Thread: Periodic Maintenance - Cross Reference Rebuild

  1. #1

    Periodic Maintenance - Cross Reference Rebuild

    Maintenance Item - Cross Reference Rebuild


    Description - The Cross Reference Facility (P980011) shows E1 object relationships. The relationships between E1 objects are stored in two tables - F980011 and F980021. The Cross Reference rebuild should be done periodically to ensure that new objects or changed relationships changed show up in P980011.


    Method - R980011


    Frequency - Monthly


    Notes- Use update mode after initial run. Data selection for update mode is Date updated [UPMJ] >= [last run date]. Rebuild the indexes afterward on tables F980011 and F980021. The Cross Reference rebuild operation is environment specific so ensure that you are in the correct environment. I usually only build Cross Reference in DV as the tables can be quite large.

    Warnings - This initial Cross Reference build process can generate *very* large tables (over 10GB) so make sure you have the necessary disk space prior to beginning. This operation can also take a looooong time and consume disk IO and CPU resources on the database server. Best to do the initial Cross Reference build during the weekend. The update Cross Reference build is not so intense.


    Run Method - Manual submission from a fat client.


    Disclaimer - As with all postings please ask questions on the forum and do not contact me personally unless:

    1) you are my buddy and want to buy me a beer, 2) you wish to tell me "Happy Birthday" or 3) you wish to engage my services during December and your company is in Miami.


  2. #2
    New Member YCT's Avatar
    Join Date
    Aug 2005
    Location
    CANADA
    Posts
    6

    Re: Periodic Maintenance - Cross Reference Rebuild

    Thank you for the information.

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, Oracle or Peoplesoft.