E1: UPG: INST: Information and Troubleshooting Known Issues For UBEs R9698711 And R9698713
(Doc ID 642925.1)
Last updated on MARCH 11, 2023
Applies to:
JD Edwards EnterpriseOne Tools - Version SP24 and later Information in this document applies to any platform.
Purpose
This knowledge document is designed to direct you through understanding the purpose and troubleshooting known issues on UBE R9698711 (Compare Tables and Indexes Against Central Objects or TAM Specifications) and UBE R9698713 (Index Recreation) mostly during a EnterpriseOne Application Release Software Upgrade. Note that these UBEs can be also run for EnterpriseOne Installations.
The knowledge provided is not meant to be as a substitute for the Install or Upgrade Guides, but as an aid for better understanding and troubleshooting UBEs R9698711 and R9698713 issues during an E1 Software Upgrade or during an E1 Installation.
The knowledge included in this document is meant for users that have a basic understanding of the Install / Upgrade process and have read the Upgrade Guides. Refer to <Document 705521.1> JD Edwards EnterpriseOne Applications Release 9.0 Upgrade Guides, Update. Refer to <Document 705463.1> JD Edwards EnterpriseOne Applications Release 9.0 Installation Guides, Update.
R9698711 (Compare Tables and Indexes Against Central Objects or TAM Specifications UBE)
You can run the R9698711 UBE program from Batch Versions after an install or upgrade. The report compares database tables and indexes against Release 9.0 Central Objects or TAM specifications. Use this report to verify the format of Application Release 9.0 tables in your database.
The "Understanding Table Format Verification" section of the upgrade guides provides some instruction for setting the Data Selection before you run the UBE.
Data Selection - set as indicated below:
Where BC Product Code (F9860) (SY) is not equal to "55,89"
And BC Data Class (F9860) (CLDF) is equal to " ,B,T" <where the first value is a space character that specifies blank>
And BC Object Type (F9860) (FUNO) is equal to "TBLE"
R9698713 (Index Recreation UBE)
This report is for installation, upgrade and cumulative update customers. The R9698713 program is run from Batch Versions after an install or upgrade. It compares database indexes versus Application Release 9.0 index specifications in F98712 and F98713. If you run the program in Update mode, it recreates incorrect indexes.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
