Re: Extra Columns to be added in Oracle Base Table
- From: Amit Dhingra <amit.dhingra77@xxxxxxxxx>
- To: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- Date: Fri, 26 Jun 2009 10:58:01 +0530
Thanks a lot, now I understand.
Regards,
Amit
On Thu, Jun 25, 2009 at 9:12 AM, Amar Kumar Padhi <amar.padhi@xxxxxxxxx>wrote:
> 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:
