When adding a new column from Form Layout, it does not check whether the field exists in a table that extended from the current table. Two columns with the same name would show up in both parent/child tables.

Steps to Reproduce

  1. From sys dictionary, create a new custom field on the Change Request table with the following values:

    • Name: A Test(u_a_test)
    • Type: String
    • Length: 40
  2. Open the change request form, and right-click the label of the field.

  3. Show u_a_test.

    Note that it shows "table=change_request".

  4. From sys_dictionary, try to create the field with the same information on Task table.

    Note that it posts the expected error message:

    Error: Invalid insert, the Column xyz already exists in this table or a table extended from it

  5. Go to, right-click in the header, and choose Configure > Form Layout.

  6. In the Create new field section, type "Name=A Test".

  7. Add the field then save the form.

    The field is created without error because the system does not check whether a column exists in child tables.

  8. Open the change request form, and right-click the label of the field.

  9. Show u_a_test.

    Note that it now shows table=task.

    u_a_test is on both Task and Change request.


This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.


Related Problem: PRB648343

Seen In

There is no data to report.

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:41:11