When you’re planning to upgrade EnterpriseOne, how can you identify all versions that have version overrides?
Whenever a new version is created, if no overrides are performed, only one RDASPEC record is created with a Record Type of ‘1‘. If additional overrides are performed on the version, then additional RDASPEC records are created.
There is not a standard report or simple inquiry that can be performed to see all versions with overrides. However, if you 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 than ’1′ you would discover that 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.
The record types are:
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)
