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:
- Copy the “All Objects” version of R980011
- 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.
Would have been great if there was an option to give the data selection as upmj minus a month
I agree, Glen. I agree.