My Oracle Support Banner

E1: TDA: Frequently Asked Questions on Table and Business View Design (Doc ID 626567.1)

Last updated on JANUARY 06, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.


This document contains answers to frequently asked questions about Table Design Aid (TDA) and Business View Design Aid.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Question 1: When should a table be generated?
 Question 2: Where can I find the table definition?
 Question 3: How can I view the data in tables?
 Question 4: What are the naming conventions for column prefixes in a table?
 Question 5: Why are modifications made to a table not seen?
 Question 6: When does the .h file for a table get created?
 Question 7: When selecting columns for a table, why should I not use data items with item occurrences?
 Question 8: What is the maximum number of columns allowed in a table?
 Question 9: Does using handles in Table I/O improve performance (vs select, fetch single, etc.) for an interactive application?
 Question 10: What are the steps to deploy a table after a table change?
 Question 11:  How do I change the table column prefix?
 Question 12: Data Dictionary data type Integer generates data type Decimal(31) in AS400 database.
 Question 13: How to get the Table and Business View information to display when using Item Help?
 Question 14: On AS400, unicode data retrieved from Blob field in Unicode table remains in Unicode format when inserted via Table IO.Insert to Blob field in non-Unicode table (clone copy of unicode table)
 Question 15:Can we delete indexes that seem to be mentioned in other indices?
 Question 16: Can we create Tables and Indexes in a different SQL Database filegroup other than the default filegroup?
 Question 17: When additional columns are added to a customized table, is it necessary to refresh Event Rules and every object related to this table, even if these objects do not use this modification? 
 Question 18: Custom data dictionary items have been created. In Table Design Aid, Data Dictionary Bowser window, Find on the custom data dictionary item does not return any record.
 Question 19: Is it possible to control the create table scripts from Object Management Workbench (OMW)? 
 Question 20: How to change the primary key from one index to another?
 Question 21: Is there a way to drop or generate a single index in a table?
 Question 22: Is it possible to generate a table via OMW in Microsoft SQL Server database where the Data Dictionary data type is Character BLOB and Variable String to be VARCHAR(MAX) and Binary BLOB to be VARBINARY(MAX) in the new table?
 Question 23: On AS400/iSeries why is System Name different from Column Name when viewing table in SQL Schema?
For example, F4211 Column Name SDKITAMTDOM is System Name SDKIT00001, Column Name SDKITAMTFOR is System Name SDKIT00002
 Question 24: In OMW is it possible to create special index in Oracle database e.g. create bitmap index, create index.. reverse or create index with INCLUDE parameter in SQL?
 Question 25: How to copy a table and table data?
 Question 26: How to compare one Table Design to another?
 Question 27: When UBE uses an index in Table I/O ER and that index is not generated in the database, will UBE fail ?
 Question 28: Is it alright to modify a Standard EnterpriseOne table like adding a new column?
 Question 29: If the table is to be generated in another environment, is it necessary to sign on to that environment on the fat client to do Generate Table?
 Question 30: How can the Unique Key(s) (key fields) be identified in a table?
 Question 1: When should a business view be generated?
 Question 2: When you create a business view or modify an existing one, do you have to generate it?
 Question 3: What is the limit to the number of tables for complex join business views?
 Question 4: Error on Table Load, Table not found, and Table not Installed after removing a table from the business view
 Question 5: Is there a limit to the number of columns in a business view?
 Question 6:  What is the maximum length of a business view name in Object Management Workbench (OMW)?
 Question 7: Why are additional columns added to the SQL statement that is generated by the business view?
 Question 8: Is it possible to create a join business view that joins columns of different types such as an alphanumeric and a numeric column?
 Question 9: How many columns can a business view have when using Auto Suggest?
 Question 10: Why can't a business view been seen from external database SQL tool like Oracle PL/SQL?
 Question 11: Is there a way to view the SQL statement generated by business view?
 Question 12: How to compare one Business View with another?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.