Re: Extra Columns to be added in Oracle Base Table
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: <amit.dhingra77@xxxxxxxxx>
- Date: Thu, 25 Jun 2009 07:42:45 +0400 (GST)
Hi Amit,
Consider this scenario. You are applying a patch and you encounter an error.
you raise an SR with oracle. Oracle request you to run diagnostic tools to
extract output. This makes oracle realise that you have fiddled with the
existing ebiz objects. As this is clearly stated as not-supported, Oracle can
disown the instance now and you or your subsequent replacers will be left with
no one to turn to.
Besides as a DBA, you need to ensure business support continuity by following
the standard norms of 3rd party applications.
Your option of storing in custom table is the best, go for it.
Thanks!
Amar
www.amar-padhi.com
-original message-
Subject: Re: Extra Columns to be added in Oracle Base Table
From: "Amit Dhingra" <amit.dhingra77@xxxxxxxxx>
Date: 23-06-2009 11:59
Yes It's an EBS table (Order Management)
WSH_NEW_DELIVERIES
there are 15 Attributes, I need to add 5 more.
one way is I design a custom table and make the relation with the base
table.
Other way is I add 5 columns directly to base table and make a custom form,
which is easy to do and fast. Only if the same is the right approach.
When I am not at all hamering the existing columns why adding extra columns
with xxprefix not recommended (If not). Please suggest
Regards,
Amit
On Tue, Jun 23, 2009 at 1:15 PM, Jurijs Velikanovs
<j.velikanovs@xxxxxxxxx>wrote:
> Hi,
>
> Saying "one of the oracle base table" are you talking about one EBS
> tables installed initially?
> What is the table name? Generally speaking it isn't supported at all.
> It is less harmful to create a custom table in you custom schema
> XX____ as you can't predict any impact on adding new columns to am
> embedded table. Anything can go wrong starting from patching and
> future upgrades ending with data corruption.
>
> Yury
>
> On Tue, Jun 23, 2009 at 5:38 PM, Amit Dhingra<amit.dhingra77@xxxxxxxxx>
> wrote:
> > Hi ALL,
> >
> > I need to add 5 extra columns (Attributes) on one of the oracle base
> table.
> > I am using the custom form based on oracle base table.
> >
> > Just wanted to know is it the right approach.
> >
> > Any suggestions?
> >
> > Regards,
> > Amit
> >
> >
> > On Tue, Jun 23, 2009 at 12:59 PM, Harish Muramshetty
> > <harish.muramshetty@xxxxxxxxx> wrote:
> >>
> >> Hi DBA's,
> >>
> >> We are running 11.5.10.2 on 10.2.0.3 (HP-UX)
> >>
> >> Recent changes : Apps pwd changed through FNDCPASS
> >>
> >> When trying to open forms for the first time...Java initiator takes more
> >> time (5 -10 mins) which was not earlier.
> >>
> >> Issue is happening for all users with all forms.
> >>
> >> But once java invokes and open the forms..then on..No
> issues...everything
> >> is perfect...no perfomance issues.
> >>
> >>
> >> Any Suggestions ??
> >>
> >>
> >>
> >> Thanks,
> >> Harish.
> >
>
>
>
> --
> Jurijs
> +371 29268222 (+2 GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
>
Other related posts:
