Aug 27 2009

Identify UBE Versions with Overrides

VN:F [1.9.22_1171]
Rating: 5.0/5 (7 votes cast)

The Client over here was trying for an upgrade, so we were trying to list out versions with overrides for estimation purposes. Then we started off with F983051, just to find out that there’s not a single field which would let us know that it has a version override.

Finally on web search, and from Oracle Metalink Documents we found that the RDASPEC information is updated locally in the TAM spec when the version override is created, and then in Central Objects when the version is checked-in.

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. For example, if the user performs data selection overrides, then records are created in the RDASPEC for that report/version with record type 7 with the selection overrides for the version. If section layout overrides are performed, multiple records with record type 3 are created in the RDASPECS. If data sequencing changes are made, then record type 6 records are created in TAM spec and if event rule overrides are performed, record type 16 records are created.

This same information can be seen in the Central Objects when the version has been checked in. If no overrides exist for the version, there will be only one record in the F98761 RDASPEC central object table with the report name in RSOBNM, the version name in RSVERS and a record type RSRCRDTP of ‘1’. However, for additional overrides, additional records are written to the central object table with the corresponding record type for the type of override. GNCID1 stores the Section-ID of the report, while the VERS contains ‘+’ for the base template.

At runtime the system looks at the RDASPEC for the version and, depending on the records that exist for
the version, it knows what overrides have occurred on the version and pulls the appropriate override information. Any record types that do not exist at the version level are then pulled from the report template
RDASPEC information.

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: Oracle Documentation/Knowledge Garden

Published under the license.

VN:F [1.9.22_1171]
Rating: 5.0/5 (7 votes cast)
Identify UBE Versions with Overrides, 5.0 out of 5 based on 7 ratings
(Visited 1,214 times, 1 visits today)

About the author

Deepesh M Divakaran

Deepesh MD is more of a Gizmo Geek, and a techie.
A very experienced Technical Consultant on Oracle JD Edwards EnterpriseOne, and OneWorld. As a consultant he has worked for wide range of industries, from Manufacturing, Media, Oil & gas etc. and has worked on re-engineering modules, and areas of customization.
With a touch of class and understanding towards what ever he does, he is often regarded by his colleagues as the one stop answer for all Technical/Software related queries.

1 comment

  1. Vishal Pawar

    Gr8 info,

    Thanks for sharing such a valued information.

    Vishal Pawar

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)

Leave a Reply