| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Apps customization help working with consultants
The attribute1 - 10 columns are standard Oracle Applications infrastructure. They are
used to hold
context sensitive information about the record. I also would worry about the use of
serrogate keys
(sequences) as a primary key. This is standard fare in most ER designs.
What I would be concerned about is there lack of trying to keep you involved in the
project as it is
you who will have to support it in the future. Be kind, understanding, but very
demanding about
this one put.
BTW, what shop is doing the implementation?
Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
"I'm too sexy for my code." - Awk Sed Fred
KathyD_at_belkin
.com To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity. Subject: Oracle Apps customization help
working with consultants
com
07/18/01
04:01 PM
Please
respond to
ORACLE-L
First some background
We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and
I am the first
DBA hired in house who has walked into several projects mid streams that consultants
are working on
and they continue to exclude me from design meeting and I get little or no information
about the
project.
A consulting group is customizing 11i Apps. Part of this involves an EDI application
that will take
in files load them into staging tables that then will be loaded into the appropriate
11i App table.
There are various Oracle and Crystal Reports that will be extracting information from
these tables
as well. Why use both... go figure... they are using Crystal for some reports and
Oracle Reports
for others. Just like some of the screens are being done in Forms and some done in
ASP.
These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the
middle of the
table. These are extra columns to that may be used in the future for what ever
reason. I have
asked these be removed and real column names and data types be added as needed. They
refuse saying
they will have to redesign the forms they have created to use with these tables.
Isn't is
reasonable that the Forms should also reflect real column names not Attribute 1...10?
Isn't it
better to add columns to tables as I need them with an appropriate name and data type?
At the very
least I asked that they put these columns at the end of the table. They have agreed
to this.
They are also using a lot of sequences for Primary Keys instead of using columns from
the table that
would make an intelligent primary key and would be unique.
They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4).
Is there any
pros or cons to using NUMBER without defining a data length? That is besides the
obvious that
NUMBER you don't have to worry about losing precision data precision.
Also they use a lot of char(1) in defining what they think will only be one character
fields. I was
under the impression that it was better to use varchar2(1)? Any comments... This is
probably a
trivial issue but I would like to know people's opinions.
I am just a bit brain dead from arguing with them anyway about using a consistence
naming
convention, including me on the database design, etc. Even with renaming a column I
get "We are on
a tight schedule and this would put us behind". Or this is how Oracle Apps works.
My point is
that Oracle Apps as a generic product and this EDI application shouldn't be made
generic but
specific to our company needs. That is not putting in this Attribute fields into all
the EDI
tables, using intelligent keys not sequence numbers, defining the data length of the
NUMBER Fields.
I am really worried about performance since I will have to maintain this in January
after they are
long gone.
Any help or suggestions would be appreciated. Any good books to get me quickly up to
speed on how
to tune Oracle Apps?
Thanks very much.....
Kathy
Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: KathyD_at_belkin.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jul 18 2001 - 18:08:44 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: rthomas_at_hypercom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |