Re: Extra Columns to be added in Oracle Base Table
- From: Amit Dhingra <amit.dhingra77@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 23 Jun 2009 13:28:31 +0530
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:
