This discussion is archived
2 Replies Latest reply: Mar 30, 2013 10:24 AM by Hussein Sawwan-Oracle RSS

Add a column in base table of R12

948832 Newbie
Currently Being Moderated
Hi,

I need a help

Requirement is, i have to add a column in AP_SUPPLIERS table.We cannot do it directly.
So,is there any way through API or something else to do so.
Please guide me as i am new in apps.

Thanks
  • 1. Re: Add a column in base table of R12
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Changing seeded objects in EBS is not supported. Applications code will fail, and future patches/upgrades will also fail - and Support will not be able to help you.

    One possible solution is to create a custom table with the needed columns and link it to the AP_SUPPLIERS table using necessary key columns.

    HTH
    Srini
  • 2. Re: Add a column in base table of R12
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    945829 wrote:
    Hi,

    I need a help

    Requirement is, i have to add a column in AP_SUPPLIERS table.We cannot do it directly.
    So,is there any way through API or something else to do so.
    Please guide me as i am new in apps.

    Thanks
    Why do you need to add a column to a seeded table?

    What is the column you are planning to add?

    Oracle does not provide public APIs to add columns (or alter tables).

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points