Quicker Cross Reference

Read Time:38 Sec

The biggest pain in the butt about the cross reference facility is the time that it takes to populate the tables when running the R980011. Jeff Stevenson has a great article on his blog, Partial Cross Reference Rebuild in EnterpriseOne, that explains how to run the R980011 with data selection to select only the objects that have been modified since a certain date.

The steps below will drastically shorten the runtime of the R980011:

  1. Copy the “All Objects” version of R980011
  2. Add a condition for BC Date – Update (F9861) (UPMJ) is greater than the date you last ran the rebuild

This will cause the R980011 to check the UPMJ field in Object Librarian and only process those records with a date more recent than the date specified.

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

2 thoughts on “Quicker Cross Reference

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Allow Firefox & Chrome To Access Restricted Ports
Next post How To Redeploy A Package To A Development Client (Fat Client)