Version Overrides

Alan Temke

Member
Greetings JDE Junkies,

We are upgrading from B7332 to ERP8 and have many undocumented version overrides on JDE Reports. Is there a quick way of identifying which UBE's have version overrides instead of manually checking each one??

Many thanks

Alan Temke
B7332, Oracle 8.1.7.2, Windows NT, Unix
 
Yes Alan there is a way,

- First go to jde.ini and under the [INTERACTIVE RUNTIME] section add this line :
TAMMenus=Show

- Then open UTB
- There is now three new icons in UTB
- Clic on the "Open Local" Icon
- Then Select RDASPEC.DDB
- Then add in the szVersion QBE "!+" to select only version not template, since template are identify as "+"
- Then add in the nRecordType QBE ">1" to select only overrides, since version overrides create multiple line with nRecordType greater than one.
- This way you have a list of versions with overrides, version with only one line with nRecordType = 1 have no overrides.

This should help a lot !

Christian Audet
 
Thank you for the info Christian. We had gone some way down the route of TAM Specs and you took us further. We were bemoaning the inability to cut and paste from the JDE grid when we remembered that TAM Specs were replicated from Central Objects. In this case RDASPEC comes from F98761 (RDA Spec Info). We will now interrogate F98761 to get a list of versions changed and how they have been changed

We would ideally like to decode the blob field in F98761 but the decoding of blob fields, going by previous posts in JDEList, does not appear to be easy.

Once again, thank you for your help.
 
Just wondering why you want to decode the BLOB?

Are you looking for any specific properties?

Regards,
Alex.
 
Back
Top