Quicker Cross Reference
Share
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.
Author
Stewart Schatz
Average Rating
2 thoughts on “Quicker Cross Reference”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Would have been great if there was an option to give the data selection as upmj minus a month
I agree, Glen. I agree.