E1: TDA: Frequently Asked Questions on Table and Business View Design
(Doc ID 626567.1)
Last updated on MAY 06, 2024
Applies to:
JD Edwards EnterpriseOne Tools - Version SP24 and laterInformation in this document applies to any platform.
Purpose
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
| Purpose |
| Questions and Answers |
| TABLES |
| 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 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 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 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 31: Why is custom index added to Bootstrap tables ( e.g. F986110, F9312, F00165 ) not generated though OMW Generate Index is successful? |
| BUSINESS VIEWS |
| 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? |
| Question 13: How to design Business View on web client? |
| References |