Skip to main content

How to identify UBE versions with override

Very useful information.
In the company I'm working right now we need to identify all the UBE versions with override in layout and event rules (unfortunately there are a lot!) aiming a future upgrade. The question is: How to do that without entering version by version and verifying the sections flags?

Here is the solution:

"There is not a standard report or simple inquiry that can be performed to see all versions with overrides. The easiest way to determine this information would be to look at the F98761 table in the central objects data source and find all records with a specific version name that have record types other then just 1. This would indicate some type of override was performed on the object. Depending on the value in the record type field (RSRCRDTP) you can determine what type of override exists for the version. You can also use the Universal Table Browser (UTB) and add the setting of TAMMENUS=Show in the [INTERACTIVE RUNTIME] section of the jde.ini to be able to view local TAM spec information and central object information from UTB.

Based on testing and review of the RDASPEC records, the record types are the following:
1 = Base Record
2 = Sections (will have one type 2 record for each section of a report)
3 = Report objects (one record for each report variable and constant on the report)
4 = Column calculation defined on tabular sections
5 = Subsection join (defines join information between sections)
6 = Data Sequencing (will have one record for each data item included in data sequencing)
7 = Data Selection (will have one record for each data item included in data selection)
8 = Database output (one record indicating destination for output -filename)
9 = Database output (one record for each mapping in database output)
10 = Row on tabular section (one record for each row)
11 = Cell on tabular section (one record for each cell)
13 = Row calculation defined on tabular section
16 = Event rule overrides performed at version level
17 = Row on tabular section (record for defined row criteria
18 = Cell on tabular section (record for defined cell criteria)
19 = Column data selection on tabular section
20 = Column and row overrides (tabular section only) "

Source: Knowledge Garden

Good work!

Eduardo Camargo dos Santos


Popular posts from this blog

JD Edwards 9.1 Standalone Installation Tutorial

Hello and welcome to! Here's a video tutorial on how to install the newest JD Edwards 9.1 version! In only six steps and no magic, you will have your JD Edwards up and running, including the Web version! The JD Edwards team did an outstanding job on this new version and I'm proud to be the first to document in video the installation steps and show you the system working after the installation. The tutorial is divided in the following steps: Images download - E-Delivery Directory preparation Oracle 11g 32 bit installation JDE Demo installation Post installation procedures System check By following the video you'll be able to have your own JD Edwards' instance running directly in your PC or you may also install as a Virtual Machine using Oracle Virtual Box. The base OS I'm using for this tutorial is Linux and as you can see, the Virtual Box VM works fast and is also stable. Please let me know if you need some information on how to se

Tools Release

JDEdwards 9.0 DEMO Installation Tutorial

Hello! Here's the new tutorial on JD Edwards 9.1 You may want to install the 9.0, but I do recommend you to install and try the 9.1 with the new user interface and the "pages" feature. Click the link above and enjoy the video tutorial! Oracle announced JDEdwards most recent version: 9.0 in September 2008. Below, a complete tutorial of how to download and install this version. Feel free to comment if you have any questions about this tutorial. After that, we'll discuss many new features included in this version, as the new "Save" option. Now you can save your specs in a file and restore in another location without deployment, just using OMW. So, let's rock! The first step is to download the DEMO version to your machine. Go to click Continue 1. Media Pack Search Choose JDEdwards Enterprise One and your platf