2 Replies Latest reply: Mar 30, 2013 12:24 PM by Hussein Sawwan-Oracle RSS

    Add a column in base table of R12

    948832
      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
          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
            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