Thursday, September 25, 2008

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

No comments:

Post a Comment

Thanks for your comment!

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
JDEFusion is not affiliated with Oracle Corporation. Contents of this site are not endorsed nor approved by Oracle.
JDEFusion is part of Oracle official OTN blogs listing for Latin America under category JD Edwards and Fusion Middleware.